Forum Discussion
PowerBI Embedded problem with Direct Query on Azure SQL
Direct Query is supported for the Embeded and you would need to configure the datasource after the import, here is how: https://msdn.microsoft.com/library/mt711498.aspx
https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-get-started/
Hope this helps,
Irina
When I embed a report using Direct Query into the app without any RLS configured, it works fine.
But when I configure RLS in the same pbix file and embed that into the application, the report opens up but the visuals dont.
So, I dont think its an issue with the credentials. It has something to do with the RLS part.
When I use Import option and embed this report with RLS into the app, it all works fine. Looks like some issue with Direct Query+RLS.
Have you modified the EmbedToken on the embedded report to contain RLS role and user name?
string[] roles = { "NAMEOFTHEROLE" };
PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id, USERNAME, roles);