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