Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
According to the official reply on my support ticket this is not an issue, it’s a feature.
I’m still owned an explanation on why it worked before and then it stopped working but I’ve given up on waiting and redesigned all reports that failed (5 or 6) from scratch.
Thanks Microsoft! Very clear documentation, policies and procedures.
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.
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
Posting to keep the thread alive.
Still facing the issue. Any roadmap to have a resolution on this?
