Answered

Power BI report URL in power apps

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

PatilChetan 126 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
PatilChetan 126 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PatilChetan 126 on at

Like (0)

Report
Copy link

Link copied!

@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-core

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

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PatilChetan 126 on at

Like (0)

Report
Copy link

Link copied!

@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-troubleshooting

Regards,
Chetan

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Chetan,

I tried passing parameters in filters to the Power BI URL, but it did not work.
Could you please help me

Was this reply helpful? Yes No
PatilChetan 126 on at

Like (0)

Report
Copy link

Link copied!

@vakula

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

Please provide more details. Can you share screenshots?

Regards,
Chetan

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report
Copy link

Link copied!

@PatilChetan I did Embed report and selected website or portal, I have got the embed URL, I am passing filters to the embed URL, below is the URL.

EmbedURL&$filter=Master_Item/Item Format ID & Name eq '152034-AS01 - NA NA NA ULTIMATE SURPRISE ASST '
Filter is not applying may be because I have spaces in attribute name and value. I have tried passing _x0020_ for space, but it still did not work.

When I tried below filters, it worked. I am getting data only for US-WALMART.
EmbedUrl&$filter=Master_Cust/SPA eq 'US-WALMART'"

Was this reply helpful? Yes No