Refresh error Premium_ASWL_Error - explicit connection with granular access control

[nmckeown1]

I have a dataset build from sql and has been refreshing fine for months.

Today I get the error:

"Premium_ASWL_Error"

Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"

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

The dataset is in my own workspace and I have not changed anything in the model/tables/dataset. I've tried signing in again in the SSO in the data source credentials but get the same error.

Any help please?

[v-achippa · Accepted solution]

Hi @nmckeown1,

Thank you for reaching out to Microsoft Fabric Community.

• Please verify if there are any known issues or bugs related to this.
• If there are no issues or bugs, I suggest you to move the calculations to the data source. Since the issue is from power bi's inability to handle calculated columns/tables with SSO-enabled DirectQuery, you can push these calculations directly to the source database or a staging area.

Let me know if you need any further assistance on this. If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @nmckeown1,

Thank you for reaching out to Microsoft Fabric Community.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Anjan Kumar Chippa

[v-achippa]

Hi @nmckeown1,

We wanted to kindly follow up to check if the solution I have provided for the issue worked.

 If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. Don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you for being a part of the Microsoft Fabric Community Forum!

Regards,

Anjan Kumar Chippa

[v-achippa]

Hi @nmckeown1,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thank you for being a part of the Microsoft Fabric Community Forum!

Regards,

Anjan Kumar Chippa