Power BI Report Access to External Users

Steps for creating a public access link for a power bi report @ powerbi.com 


  • Login to powerbi.com and navigate to your workspace.


  •  Clicking on the file menu we get below options.

  • Click on publish to web option and the below window appears.


  • Click on the "Create embed code" option, we get below window.



  • Click on publish to get the link for the report.


You can copy the link from first text box which contains encrypted URL and that does not require and login to view the report. Now if we want to embed the report in a website then we need to copy the iframe code and paste in our application.

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...