Forum Discussion
Live connection limitations
Hi MiaOlly - As mentioned, Calculated columns and tables can behave differently based on the type and number of data sources referenced. If you are combining tables from multiple sources or have different types of storage modes (DirectQuery and Import), limitations may arise. For instance:
Single Source: Calculated tables and columns typically work well if you’re referencing only one data source, especially in Import mode.
Multiple Sources: If your calculation involves tables from multiple sources, particularly in DirectQuery mode, you might encounter restrictions due to differences in how each data source handles DAX expressions and relationships.The error message you shared, "This semantic model contains calculated tables or calculated columns that refer to remote tables," highlights that calculated columns/tables referencing remote sources require explicit permissions and granular access configurations, especially when using DirectQuery connections.
Sometimes, you may see errors such as refresh failures or messages about unsupported operations. These are usually due to Power BI's limitations on combining complex DAX calculations across tables in composite models, as well as refresh constraints for calculated tables/columns in DirectQuery.
Thanks so much! That helps a lot. Can I ask you another question? I find in composite model, sometimes the calculated table/column works and sometimes are not. for example, when only referring to one data source and DAX syntax is not complex, it works sometimes. While when calculated columns/tables refer to two or more tables with relative complex DAX syntax, it does not work. Can you please shed more light on it? Which situation works and which are not? Here are some error codes I got when it is not working.
Hi MiaOlly - As mentioned, Calculated columns and tables can behave differently based on the type and number of data sources referenced. If you are combining tables from multiple sources or have different types of storage modes (DirectQuery and Import), limitations may arise. For instance:
Single Source: Calculated tables and columns typically work well if you’re referencing only one data source, especially in Import mode.
Multiple Sources: If your calculation involves tables from multiple sources, particularly in DirectQuery mode, you might encounter restrictions due to differences in how each data source handles DAX expressions and relationships.
The error message you shared, "This semantic model contains calculated tables or calculated columns that refer to remote tables," highlights that calculated columns/tables referencing remote sources require explicit permissions and granular access configurations, especially when using DirectQuery connections.
Sometimes, you may see errors such as refresh failures or messages about unsupported operations. These are usually due to Power BI's limitations on combining complex DAX calculations across tables in composite models, as well as refresh constraints for calculated tables/columns in DirectQuery.