PowerBI Embeded report with RLS cannot display with 401 error code

[tobyfan1980]

I found that my customer page cannot show embedded report. 

I added roles to my report, import my report to azure powerbi workspace. Following the example at https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls, I get access token and embeded url of my report.   

Then only thing different from the example is that I am using direct query, so I update dataset connection string after I import the report.

However, the report in my web app cannot be displayed. All tiles is empty with a cross at the center. I got the http response as bellow.

Http Status Code401

Activity ID79d3cd7a-07cf-4e33-8110-967e16c3870c

Correlation IDdf6e5c94-6d50-212f-7c4c-64acc4f6f748

Request ID43bfe546-7e56-81cd-400f-33ae93960af5

TimeSun Feb 19 2017 23:38:26 GMT-0800 (Pacific Standard Time)

Version13.0.1700.1204

Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net/

I remove the role in my report, and retry, then, I can see my report in my web app correctly.

I was wondering, what did I miss.  What kind of special thing should I do if my report has role.

Please help. 

[vinaypugalia]

Hello,

If you are using DirectQuery with Power BI Embedded, please note that as on date, only SQL Azure & Azure SQL Warehouse are the only 2 data sources which are supported. Any data source using data gateway is not supported.

So, this might be a reason of you not seeing the data.

Thanks,

Vinay