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
ManuGP's avatar
ManuGP
Advocate I
3 years ago

I support you AugustoChaves !Posting just to keep the topic alive, as it is still a problem in 2023.

I use it to build effective dimension tables (based on data in the fact tables) with SUMMARIZE. It is also one of the things that work perfectly fine in desktop and there is no reason to suspect they wouldn't in the service until you publish and try to refresh.

 

 

MartyCollins's avatar
MartyCollins
New Member
3 years ago

Posting for extra attention:

I cant believe this is a "feature".. 

Below is the error im getting.. it makes no sense that this works in the desktop but not in the service..

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Posting to keep the thread alive. 
    Still facing the issue. Any roadmap to have a resolution on this?