Forum Discussion
Refresh error - Single Sign-on (SSO)-enabled Direct Query data source.
Hi mihaicrt
I found a post with a similar problem to yours with several solutions mentioned by other users, I hope it helps you.
Refreshes for Datasets containing Calculated Table... - Page 7 - Microsoft Fabric Community
I put screenshots of the number of messages with the workaround below so you can find them faster.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mihaicrt
I found a post with a similar problem to yours with several solutions mentioned by other users, I hope it helps you.
Refreshes for Datasets containing Calculated Table... - Page 7 - Microsoft Fabric Community
I put screenshots of the number of messages with the workaround below so you can find them faster.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I'm encounterign the same issue: "We cannot refresh this dataset because the dataset contains calculated tables or calculated columns based on data from a Single Sign-on (SSO)-enabled Direct Query data source. Please configure the dataset to use an explicit connection with granular access control to access this data source and then try again."
Reading the solutions in the forum I tried to grant the access control but the option is not availavble:
The option is greyed out also for the workspace owner.
Do you have any idea why this is appening?
Thank you