Embedding Power BI Reports: Direct Query & Import

[Rohitb]

I have two Power BI reports that I need to embed on my website:

1. A report using Direct Query to an Azure SQL Database.
2. A report using Import from Blob Storage.

How can I embed these reports on my website? Is it possible to do this without using Azure Power BI Embedded?

Additionally, how will Row-Level Security (RLS) work with these reports? Will RLS applied to the Direct Query report and the Import report function correctly, or will adjustments be needed?

[Rohitb]

I have two Power BI reports that I need to embed on my website:

1. A report using Direct Query to an Azure SQL Database.
2. A report using Import from Blob Storage.

How can I embed these reports on my website? Is it possible to do this without using Azure Power BI Embedded?

Additionally, how will Row-Level Security (RLS) work with these reports? Will RLS applied to the Direct Query report and the Import report function correctly, or will adjustments be needed?

[v-linyulu-msft]

Hi,@Rohitb 
Regarding the issue you raised, my solution is as follows:

1.If you want to embed a Power BI report on a website without using Azure Power BI Embedded, you can use the Embed option available in the Power BI service.

2.It's important to note that report access needs to be authenticated regardless of whether the user opens the report URL directly or is embedded in the web portal.

Here is a screenshot of the official document:

3.And only users with view permissions can view the report in Power BI. All row-level security (RLS) rules are also applied.

Here is a screenshot of the official document:

4.Here is the relevant documentation:
Embed a report in a secure portal or website - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rohitb]

Hello @v-linyulu-msft 

Thankyou for your response.

What is the difference between the PowerBI Embeed in PowerBI service vs the Azure Power BI Embedded.
I am refereencing below article to understand Azure PowerBI Embedded. 
https://datafloq.com/read/what-power-bi-embedded-azure/

[v-linyulu-msft · Accepted solution]

Hi,@Rohitb 
Thanks for the quick reply.
 

In my understanding, the solution I provided to you earlier should actually be biased towards secure embedding, and the "Azure Power BI Embedded" you mentioned is actually more biased towards "Power BI embedded analytics solutions".

So your question can be translated into the difference between secure embedding and Power BI embedded analytics solutions:

Here is a screenshot of the official documentation:
 

Essentially, secure embedding is a simple, no-code option that meets basic embedding needs, while Power BI embedded analytics provides more advanced functionality and flexibility for internal and external use cases.

Here are links to the relevant documentation, I hope you find it helpful:

Power BI embedded analytics overview - Power BI | Microsoft Learn

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.