Forum Discussion
Solved
CustomGPT Fabric integration with RLS
Hey has anyone successfully connected a Custom GPT to Microsoft Fabric data using the REST API or any other supported query endpoint? We're using OAuth 2.0 with delegated scopes like Dataset.Rea...
yes we got it working for semantic endpoints.
Hi softbrendan
Thanks for reaching out to the Microsoft fabric community forum.
As your objective is to use RLS with your Fabric data, you can try to use XMLA endpoint with third party tools with which you will be able to use RLS roles
Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn
The following limitations apply when working with roles through the XMLA endpoint:
- The only permission for a role that can be set for semantic models is Read permission. Other permissions are granted using the Power BI security model.
- Service Principals do not work with RLS and OLS, and cannot be added as model role members.
- Build permission for a semantic model is required for read access through the XMLA endpoint, regardless of the existence of semantic model roles.
I hope this information helps. Please do let us know if you have any further queries.
Thank you