Skip to main content

Power BI

New

Import Query with Advanced SQL Statement should not qualify as Composite Model

Vote (1) Share
Andrew's profile image

Andrew on 05 Oct 2018 23:41:20

I have Import Queries utilizing SQL Statements within the Advanced options of the SQL Server Database for a "Get Data" query.

Even though I still have this set to Import, I cannot publish to Power BI Service. It gives me an error saying my model is a Composite Model and this preview feature cannot be published.

Please make a fix that BI Desktop does not think of this as falling into the category of a Composite Model since it is still all Import. I am not mixing Import and Direct Query that would make it qualify as a Composite Model