Forum Discussion
Power BI button to refresh report when embedded on SharePoint page doesn't work
I have a report which includes a refresh button (using the standard 'insert, power automate' option), and the associated flow simply triggers a refresh of another power bi dataset.
This button works perfectly fine in the report on the service, when pressed it triggers the flow and the dataset is refreshed - perfect!
But when embedding this report into a sharepoint page (to give a more holistic experience with other materials) the button no longer works - I press the refresh button and the 'triggering' wording appears but nothing happens. The flow isn't triggered, there is no error message on screen and no failed flow attempt.
Why doesn't this button work when the report is on a sharepoint page ??
Thanks Anonymous I think it's some permissions issue, which behaves differently when using the Power BI web part on a SharePoint page. None of the above helped unfortunately, but I did then try to just use the normal 'Embed url' web part instead and that works fine!
So, if anyone wants to use buttons which trigger power automate in their Power BI and embed it in SharePoint, then don't pick the Power BI web part, just use the normal embed web part!! Sorted.
2 Replies
Hi DDDDD ,
First, go to the SharePoint page where you embed the report.
Press F12 and check if a Power BI related request is sent when you click the button.
If there is check the error message.
If not, go into Power BI Service, change some data for the current report, and then go back to SharePoint to see if the data has changed.
If it feeds the data change correctly you can create a new test flow in Power Automate and associate it to the button to see if it works.
If the data changes do not feed back correctly, you can create a new test report in Power BI Service, add the same button and then embed it in SharePoint to see if a different report has the same issue.
Sometimes the visual objects Embedded to SharePoint have bugs that you can fix by clearing the Site Data in SharePoint and Power BI Service.
These are the steps to troubleshoot the issue and I would appreciate if you could cooperate.
You are welcome to contact me anytime.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Thanks Anonymous I think it's some permissions issue, which behaves differently when using the Power BI web part on a SharePoint page. None of the above helped unfortunately, but I did then try to just use the normal 'Embed url' web part instead and that works fine!
So, if anyone wants to use buttons which trigger power automate in their Power BI and embed it in SharePoint, then don't pick the Power BI web part, just use the normal embed web part!! Sorted.
