PowerBI Embedded problem with Direct Query on Azure SQL

[christiank]

Hi,

I have a Power BI Embedded report with an SQL Azure data source using the Direct Query method.

First I created a PBIX file using Power BI Desktop and then uploaded it using the Power BI Embedded sample app.

When embedding the report on a web page (using the JavaScript SDK), all visualizations of the report fail to load.

If I use the Import method instead of Direct Query on the same dataset, the visualizations show up fine.

Any ideas why Direct Query isn't working on SQL Azure datasources?

Do I have to provide the credentials for the data source somehow after uploading the PBIX file?

Thanks

[vanessa]

@irinag

Yes. I have done that. RLS worked fine when the source was SQL server table. But the visuals don't show up when the source is Azure SQL Data warehouse.

[Felix]

@vanessa

Ok now I understand your problem. Unfortunatly I haven't tried RLS in combination with Power BI Embedded... But it could be possible that there is a problem with this combination. Perhaps opening a support request could solve your problem.

I suppose you have already seen the example Power BI Embedded with RLS?

[leamx]

Hello, I am facing the same issue with direct query and an azure database. Where exactly do you set the Path Gateway Datasource?

Thanks.