Forum Discussion

Rohitb's avatar
Rohitb
Helper I
2 years ago
Solved

Embedding Power BI Reports: Direct Query & Import

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?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

4 Replies

  • Rohitb's avatar
    Rohitb
    Helper I
    2 years ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.