Forum Discussion

AugustoChaves's avatar
AugustoChaves
Advocate II
4 years ago

Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th

Hello,  Refreshes of datasets that contain calculated tables from DQ to AS started failing March 30th, 2022. This worked completely fine until March 29th which points to a change at Power BI service...
Need Help
dbeavon3's avatar
dbeavon3
Memorable Member
3 years ago

Nevermind, I found the documentation about this limitation:


https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services#considerations-and-limitations

"Calculated tables aren't supported in the Service using this feature. Attempting to perform a refresh on a dataset with a calculated table or a calculated column that references a DirectQuery data source will result in a "Single sign-on (SSO) credential isn't provided" error message."



It still seems obnoxious that they allow you to build a report on the desktop, which is unable to be used when published to the service.  I think people would be a lot less frustrated if they weren't being "teased" with a feature on the desktop, only to find out that it isn't going to work in production.

ManuGP's avatar
ManuGP
Advocate I
3 years ago

I agree 100% with all that you mentioned. The error I am getting is not exactly as anticipated (SSO credentials):

 

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