PowerBI Embeded report with RLS cannot display with 401 error code

tobyfan1980 — Mon, 20 Feb 2017 07:43:39 GMT

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.

Re: PowerBI Embeded report with RLS cannot display with 401 error code

vinaypugalia — Tue, 21 Feb 2017 11:32:27 GMT

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

topic PowerBI Embeded report with RLS cannot display with 401 error code in Developer

PowerBI Embeded report with RLS cannot display with 401 error code

Re: PowerBI Embeded report with RLS cannot display with 401 error code