Forum Discussion
The query referenced calculated column '_Table'[Column] which does not hold any data because evaluat
So, just to follow up on my last comment:
I changed the model by duplicating the DQ table that was being referenced by the calculated column in my mixed-mode model. (the calculated column residing in a table from the on-premisses workbook.
Duplicating the model and changing some dependencies, the refresh now failed (before it refreshed just fine, but the report consequently "crashed"), stating the following error, confirming my suspicions:
COM error: Microsoft.PowerBI.AS.ConnectionDetailsProvider, Single sign-on (SSO) credential is not provided which is required to execute the current request. Note that performing a refresh over a dataset with a calculated table or a calculated column which references a Direct Query data source is not supported within the Power BI service..
So basically, it simply is not possible to reference a DQ data source in a calculated column.
Cheers,
Niels
I encountered the same issue and fixed it by switching the direct query table-containing the column referenced by the breaking measure-to import mode.