Refresh error - Single Sign-on (SSO)-enabled Direct Query data source.

[mihaicrt]

Hello all,

I’m working on both the development and support sides of Power BI. So far, I’ve had two incidents related to this error, which took me a long time and a lot of effort to resolve. I’m looking for a more efficient way to handle it in the future if I encounter similar issues.

The problem occurred when trying to refresh reports in Power BI Service, and the error message was as follows:

"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."

After investigating the data model, I discovered that the issue was caused by the report using other semantic models as data sources set to 'Direct Query' storage mode, which contained calculated tables and columns.

The solution was challenging and time-consuming because I had to identify all the data sources used in the report, obtain the necessary access permissions for the user, and rebuild the model by connecting directly to those data sources and setting them to 'Import mode.'

Has anyone else faced this error before? If so, how did you solve it? I feel like I might be missing something.

Also, I should mention that eliminating the calculated tables or calculated columns wasn’t a viable option in my case.

Thank you! 

[Anonymous · Accepted solution]

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.

[EliasForma]

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