The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I created a report and I am using RLS. The report is connected to a Azure SQL database using direct query. When I am testing RLS in the report it all works fine. I am using Power BI embedded to interate the report in my application.
So I first publish the report to service. But when I publising the report I get a message "Publishing succeeded, but the published report cannot connect to the data source because we were unabaile to find a gateway. Please install and configure a gateway."
The data source is an Azure SQL database, so if I am right I don't have to use a gateway.
In Power BI service I can open the report. When I Don't pass indentities to the embed token API I can upload the report in my application. The moment I add roles and username and to the API the report is not uploaded.
When I use the same setup as described above with the only difference that I am using csv files instead of Azure SQL and direct query everthing works fine. I can pass username and roles to the API and RLS works fine.
Do I do something wrong or is it just not possible to use RLS in Power BI embedded in combiation with direct query?
Kind regards,
Arno
Have you got any answers to this since january?
I can't make it work too..
Hi MWpower,
With the help of MicroSoft I was able to figure out what the problem was. I was passing a fixed dataset id using the API. So PBI only worked using that dataset. I changed the script so that I can, besides Username and Role, also multiple datasets id's. That worked for me.
Regards,
Tairo
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
19 | |
10 | |
5 | |
4 | |
3 |