'%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 SharePoint List Power BI Integration Missing for Users
Question details
Some users, including list owners, cannot see the "Integrate with Power BI" option in a SharePoint Online list, and are only able to see the "Power Apps" option despite having active Power BI licenses.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Attempting to create or view a Power BI report directly from a SharePoint Online list using the integration menu.
- Observed behavior
- The "Integrate with Power BI" button is visible to one user but is completely missing for other users, including those with list owner permissions and different Power BI license types.
Verify that you have administrative access to your Microsoft 365 tenant settings and confirm the exact Power BI licenses assigned to the affected user accounts.
Consult Microsoft Fabric Community and Check Tenant Settings
Because this issue involves complex Power BI integration and tenant-level licensing configurations, the most effective resolution path is to consult specialized Microsoft support and documentation.
SharePoint and Power BI integration relies heavily on Microsoft 365 tenant admin settings and user-specific licensing. Even if a user is a list owner, tenant policies might restrict their ability to see the integration button.
Collect detailed information about the affected users, including their site permissions, tenant-level settings, and exact Power BI license types (e.g., Free, Pro, or Premium Per User).
Navigate to the Microsoft Fabric Community forums. Create a detailed post explaining that the integration is missing for list owners despite having valid licenses, and include the account details you gathered.
Check Microsoft's official documentation regarding sharing Power BI reports and dashboards to ensure all prerequisites for SharePoint integration are properly configured in your workspace.
Looking for a Reliable and Free Office Suite? Try WPS Office
While WPS Office does not directly resolve Microsoft SharePoint and Power BI integration issues, it serves as a powerful, lightweight alternative to Microsoft Office for your daily document, spreadsheet, and presentation tasks. Enjoy a familiar interface and seamless compatibility without complex licensing tiers.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to set up the suite on your device.
- 3. Open and Edit Files: Launch WPS Office to instantly open, edit, and save your existing Office files without any formatting loss.
Frequently Asked Questions
Why is the Power BI button missing in my SharePoint list?
This can occur if the Microsoft 365 tenant administrator has disabled Power BI integration at the tenant level, if the user lacks the appropriate Power BI license, or due to specific site-level permission restrictions.
Do I need a Power BI Pro license to integrate with SharePoint?
Yes, typically creating and sharing Power BI reports from SharePoint lists requires a Power BI Pro or Premium Per User (PPU) license, depending on how your workspace and organization are configured.
Can SharePoint list owners be restricted from using Power BI integration?
Yes. Even if a user has full control or owner permissions on a specific SharePoint list, tenant-wide settings managed by the global admin can override these permissions and hide the Power BI integration option.
