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.
Hi!
The same thing is happening to us. Hit the same wall.
We are dealing with an issue refreshing a dataset in a composite model, with an opened support ticket since June 18th.
We spent 3 months building the composite model and couldn't get it to update inside the service.
And now, in version PBI desktop version 2.19.986, they added this warning popup.
It's a shame.
Months of work wasted.
Best,
Adrian.