Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
Wow, just hit this issue also. Very disappointing ... i was happy updating a report, reday to publish and bam
"Publishing to Power BI"
"This dataset contins calculated tables or calculated columns that refer to remote tables, which will result in refresh failures after publication. Are you sure you want to continue publishing?"
Is there a formal ticket on this or just forum complaints? Any discussions or comments from MS PMS or others on Twitter?
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
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.
A few related items from the ideas pages. Please go vote for them, addcomments and share if there are other ideas.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=83567bed-3451-ec11-a3f3-281878de4cf8
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6b14127d-4400-ee11-a81c-6045bdb98602
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=4c2702a6-e4b1-4240-a3f5-c1baf31e4204
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=22546afa-efd2-ed11-9139-501ac5249853
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6c461101-3ac7-46ad-a442-fe2f2e2976ea
This is a shame. Voted.
