Get the URLs for Power BI reports into an iFrame-friendly shape.

If you try to use this...

https://app.powerbi.com/groups/fdf0afb1-b82f-4f2c-9b18-3a155e641da4/reports/e94cc465-3b7c-4423-aee4-e54d11461023/ReportSection?filter=Template_x0020_FileUpload/FileName eq 'Something.xlsx'

 
 

...in the src setting in an iFrame. You will get this error:

Refused to display 'https://app.powerbi.com/groups/fdf0afb1-b82f-4f2c-9b18-3a155e641da4/reports/e94cc465-3b7c-4423-aee4-e54d11461023/ReportSection?filter=Template_x0020_FileUpload/FileName%20eq%20%27Something.xlsx%27' in a frame because it set 'X-Frame-Options' to 'deny'.

 
 

Reshape the report like so to beat the problem:

https://app.powerbi.com/reportEmbed?reportId=e94cc465-3b7c-4423-aee4-e54d11461023&autoAuth=true&ctid=a0992d83-4b6b-4c73-9f94-93de63f4a60d&filter=Template_x0020_FileUpload/FileName eq 'Something.xlsx'

 
 

Note that we have kept the report's identifier and dropped the group's identifier. You also have to have the ctid already from making another iFrame-friendly report to begin with. Note how the one GET variable above gets bolted on to the end of a set of variables.