Link to home
Start Free TrialLog in
Avatar of Juan Ocasio
Juan OcasioFlag for United States of America

asked on

Change Power BI reports in Power BI web part based on quick link clicked in SharePoint

Hello Experts:


I have a modern SharePoint Site with a Power BI Web part. What I would like to do is have my quick links change the report that is showing in the web part. I have 4 Power BI reports and I want to have 4 links (buttons) so when a user clicks on a button, the corresponding report shows.  Currently, I have 4 separate pages for each report, but I would rather have 1 if possible.


Thanks for your help!

Avatar of Juan Ocasio
Juan Ocasio
Flag of United States of America image

ASKER

Thank you for your detailed instructions. I think I am missing something. I can add a Power BI web part and then assign the Power BI Report's URL to it. This displays that one report. If I then create a quick link web part on the page and then assign the URL to another report, that report doesn't show in the Power BI web part. Instead, the link takes me to the workspace where the report is located. How do I associate the change in the quick link to the power bi web part?

Amit: Yes, that helps add 1 report to the page. What I want to do is have 4 links and when each link is pressed they target the 1 Power BI webpart and change the URL to the Power BI report that was selected. So the links will act as events that change the Power BI web part to point to a different URL. I'm starting to sense this can not be done. I believe the classic SharePoint had a javascript web part that would allow me to write JavasScript to do this, but it doesn't appear to be functionality SharePoint can handle.


Let me know if you have other thoughts. The approach you outlined above works if you have 4 pages with the different Power BI reports and then quick links that links to each, but it didn't solve the issue of using the quick links to target the same page's Power BI web part to change reports.

ASKER CERTIFIED SOLUTION
Avatar of Juan Ocasio
Juan Ocasio
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial