Unable to refresh Power BI report in service with a composite data model

[deepeshxdv]

Hi,

I have a data model in place where couple of tables are coming from SharePoint import mode and a few tables through direct query. I have a requirement where I have to create a measure and calculated table referencing columns from both direct query table and imported table.

Once I publish this report to Service, it is throwing me below error while refreshing. 

"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery"

Is there a workaround to handle this situation?

Thank you!

Deepesh

[v-binbinyu-msft · Accepted solution]

Hi @deepeshxdv ,

The existing limitations of DirectQuery still apply when you use composite models. Many of these limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an import table can refer to other tables, but a calculated column on a DirectQuery table can still refer only to columns on the same table. Other limitations apply to the model as a whole, if any of the tables within the model are DirectQuery. For example, the QuickInsights feature isn't available on a model if any of the tables within it has a storage mode of DirectQuery.

For more details, you can read related document: Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.