Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I embedded a report into a web application using direct query to Azure SQL DW and all the visuals show up just as required.
But when I add RLS to the PowerBI desktop file and embed the report into the app, it says "Couldn't load the data for this visual"
Do I need to make any change in the EmbedSample code? (I am using the code that Microsoft has provided on github)
Hi @vanessa,
Yes, for RLS to work, you’ll need to pass some additional context as part of your app token:
You create the token by using the CreateReportEmbedToken method. If the username property is present, you must also pass at least one value in roles.
For example, you could change the EmbedSample. DashboardController line 55 could be updated from
var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id);
to
var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id, "Andrew Ma", ["Manager"]);'
For more details about how to set up Row level security with Power BI Embedded, you can refer to this article.
Regards
I have already done that. RLS worked fine when the source used was SQL server table. But the visuals don't show up when the source is Azure SQL Data warehouse.
Hi, I'm struggeling qith the same problem. RLS with imported data was no problem. But now with DirectQuery I'm getting the same error. Did you find an solution?
Regards, Florian