Power BI report URL in power apps

[vakula]

Hi, 

I have power BI report, Is there a way I can show the URL of power BI report in canvas app and redirect to power BI report on click of URL, without the login screen in between?

Thanks.

[PatilChetan · Accepted solution]

@vakula 

To add link in Canvas app use HTML Text control.

HTML Text: "<a href='https://app.powerbi.com'>Click here.</a>"

For Power BI report refer the link https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web 

Regards,

Chetan

[vakula]

I have placed the link in the app, but on click of the link, it should redirect to the URL. How can I do this?

[PatilChetan]

@vakula 

Try below code

Launch( "https://bing.com" )

Refer link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-param 

Regards,

Chetan

[vakula]

I have placed a HTML Text and on click of that, I have written Launch('URL'). It worked, but it is  asking for the authentication while redirecting to the Power Apps. I want the same authentication to be continued which I logged in for Power apps.

[PatilChetan]

@vakula 

Refer below links:

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal 

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-sample-for-customers?tabs=net-cor... 

Video link: https://www.youtube.com/watch?v=ZhMfpdXLIw0 

OR

Refer link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-param 

Regards,

Chetan

[vakula]

I have added a link in canvas app and redirected to Power BI dashboard. But my report shows for 10 different Items.

How can I apply filters in power BI based on selected Item in canvas app. I need not show report in power apps. Filter should be applied in Power BI report.

Please help me with this.

[PatilChetan]

@vakula 

For passing parameters in URL to filter Power BI report, refer the links: https://carldesouza.com/passing-parameters-in-url-to-filter-a-power-bi-report/  

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters 

But, if you are using 'Publish to Web' feature, then the query string filtering does not work.

Refer: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#considerations-and-t... 

Regards,

Chetan

[vakula]

Hi Chetan, 

I tried passing parameters in filters to the Power BI URL, but it did not work.

Could you please help me

[PatilChetan]

@vakula 

How you are embedding? By using 'Publish to Web' or 'Embed report'.

Please provide more details. Can you share screenshots?

Regards,

Chetan