'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Power BI Power Automate Button Not Working in SharePoint
Question details
Users are unable to trigger a Power Automate flow using a button within a Power BI report when the report is displayed on a SharePoint modern page.
- Product
- Power BI and SharePoint
- Device & OS
- not provided
- Scenario
- Displaying a Power BI report containing a Power Automate visual button within a SharePoint modern-page web part.
- Observed behavior
- The Power Automate button works correctly in Power BI online and Desktop, but fails to trigger the flow when interacted with via the native SharePoint Power BI web part. The flow run history registers no attempt.
Verify that you have page editing privileges in SharePoint and that the Power Automate flow is shared correctly with the intended users.
Use the SharePoint Embed Web Part
Bypass the limitations of the native Power BI web part by using the standard Embed web part with a Power BI embed code, which fully supports the Power Automate visual.
The native Power Automate visual is currently not supported by the SharePoint modern-page Power BI web part. To resolve this, you must embed the report using a standard iframe or embed code.
Open your report in Power BI online, click on 'File', navigate to 'Embed report', select 'SharePoint Online', and copy the provided URL.
Navigate to your modern SharePoint page, click 'Edit' in the top right corner, and delete the existing Power BI web part that is causing the issue.
Click the '+' icon to add a new web part to your page and search for 'Embed'. Select the Embed web part from the menu.
In the Embed web part property pane on the right, paste the Power BI embed URL you copied earlier into the website address field.
Click 'Republish' or 'Save' on your SharePoint page. Click the Power Automate button inside the embedded report to confirm it now triggers the flow successfully.
Verify Flow Run-Only Permissions
Ensure that the users interacting with the embedded report have the appropriate permissions to trigger the underlying Power Automate flow.
Looking for a Lightweight Office Suite? Try WPS Office
While WPS Office doesn't directly manage Power BI or SharePoint integrations, it serves as a powerful, free, and lightweight alternative to Microsoft Office for your daily document, spreadsheet, and presentation needs. Experience seamless compatibility without the heavy subscription costs.
- 1. Visit the WPS Website: Go to the official WPS Office website to find the latest free version.
- 2. Download the Installer: Click the 'Free Download' button compatible with your operating system.
- 3. Install and Launch: Run the downloaded installer and follow the on-screen instructions to set up your new office suite.
Frequently Asked Questions
Why does my Power Automate visual work in Power BI Desktop but not in SharePoint?
The native Power BI web part in SharePoint modern pages restricts certain external scripts and visuals, including the Power Automate visual, from running. It works in Desktop and Power BI online because those environments natively support the visual's execution requirements.
Can I use the native Power BI web part for reports without Power Automate buttons?
Yes, standard Power BI reports that do not rely on the Power Automate visual or custom external scripts will work perfectly fine using the native Power BI web part in SharePoint.
How do I check if my flow was triggered by the button?
Log into Power Automate, navigate to 'My flows', select the flow linked to your button, and check the '28-day run history' section to see if there are any successful, running, or failed attempts.
