Forum Discussion
Refresh error Premium_ASWL_Error - explicit connection with granular access control
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?
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
4 Replies
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
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
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