'%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)
How to Connect SharePoint Data from Multiple Microsoft Accounts to Power BI
Question details
Connecting data from multiple SharePoint sources that are associated with different Microsoft accounts into a single Power BI dashboard.
- Product
- Power BI, SharePoint
- Device & OS
- not provided
- Scenario
- A user is trying to build a unified Power BI dashboard by pulling data from cross-tenant or multi-account SharePoint lists and folders.
- Observed behavior
- Power BI typically restricts multiple Microsoft account authentications in the same setup for a single domain, resulting in credential conflicts or access errors.
Before starting, ensure you have administrative access to the Power BI workspace and the necessary permissions (such as Site Collection Administrator or Member) for all the SharePoint sites you intend to connect.
Consolidate Data Using a Centralized Database
Since Power BI limits authentication to a single Microsoft account per root domain, the most reliable method is syncing your cross-tenant data into one unified location.
Power BI Desktop caches credentials based on the data source domain. When connecting to multiple SharePoint sites that require different credentials, the system will attempt to use the cached credentials of the first account, leading to authentication errors.
To bypass this limitation, you can use automated flows to consolidate your data into a single source before connecting it to Power BI.
Create a centralized database (such as Azure SQL) or designate one single primary SharePoint tenant to host all necessary lists.
Use Power Automate to create flows that automatically copy or sync data from the secondary SharePoint accounts into the primary repository on a scheduled basis.
Open Power BI Desktop, click 'Get Data', and select your new consolidated data source (e.g., Azure SQL or the primary SharePoint site).
Log in using the single set of credentials associated with the unified data source to build your dashboard without credential conflicts.
Configure an On-Premises Data Gateway
An on-premises data gateway can serve as a bridge, allowing you to configure different data sources with distinct credentials in the Power BI Service.
Analyze and Manage Exported Data Easily with WPS Office
If you are dealing with complex cross-tenant SharePoint data, you might need to export it for manual review before importing it into Power BI. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, making it incredibly easy to process CSV and Excel exports.
- 1. Download and Install: Visit the official WPS website and download WPS Office Free to your device.
- 2. Open Your Data File: Launch WPS Spreadsheet and open your exported SharePoint CSV or Excel files.
- 3. Analyze and Format: Use built-in pivot tables and formulas to clean your cross-tenant data before feeding it into your centralized Power BI repository.
Frequently Asked Questions
Why do I get an authentication error when adding a second SharePoint site to Power BI?
Power BI Desktop caches credentials based on the root domain (e.g., sharepoint.com). When you try to connect to another SharePoint site that requires different Microsoft account credentials, it automatically attempts to use the previously cached credentials, resulting in an access error.
Can I use Azure AD B2B to solve cross-tenant SharePoint access in Power BI?
Yes. If the administrator of the secondary SharePoint tenant grants your primary Microsoft account Guest Access (B2B), you can authenticate using your primary account across both sources without needing two separate logins.
How do I clear cached SharePoint credentials in Power BI Desktop?
Go to File > Options and settings > Data source settings. Select 'Global permissions', locate the specific SharePoint URL, click 'Clear Permissions', and then try connecting again to enter the correct account details.
