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
Correct. You cannot move data like that across islands (DQ vs Vertipaq). You can move filters, not data.
Great answer to this issue. Now I have a follow up question to this.
My PBI data model contains excel workbooks and powerbi datasets that are read only .
I am trying to bring fields in from the PBI dataset, and lookupvalues function doesn't see any of the fields in the dataset tables.
The problem is that i can't recreate the table locally because it's locked out to me as read only dataset.
and when i use something like TREATAS, it does work functionally but when i pubish the report, I get this error.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.
