'%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 Access Power BI Dataflows in Two Separate Organizations
Question details
The user needs to connect a single Power BI report to dataflows that are hosted in two separate Microsoft organizational accounts (tenants) belonging to different vendors.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Attempting to retrieve and combine data from multiple cross-tenant Power BI dataflows into one consolidated report.
- Observed behavior
- The connection is blocked or fails because Information Rights Management (IRM) settings and tenant boundaries restrict access across different Microsoft organizational accounts.
Verify that you have the appropriate access credentials or Azure AD B2B guest permissions for both organizational tenants before attempting cross-organization data retrieval.
Address IRM Restrictions via Microsoft 365 Support
Information Rights Management (IRM) often restricts files and dataflows to specific organizational emails. You need to adjust these permissions or seek Microsoft support.
When attempting to open or connect to files shared across organizations, IRM settings typically mandate that your email address matches the provider's organization. If a request access option is unavailable or fails, it might be a product-level restriction.
When prompted during the connection or file opening process, select the option to request access. This sends an automated email to the owner of the dataflow to grant you permissions.
Reach out to your IT administrator to verify if cross-tenant collaboration (B2B) or IRM configurations are currently blocking the external dataflow connection.
If the issue persists, have your administrator navigate to the Microsoft 365 admin center. Go to Support > New service request to ask Microsoft specialists for a resolution regarding cross-organization dataflow IRM limitations.
Utilize Alternative Data Consolidation Methods
If direct cross-tenant dataflow connections remain unsupported, consolidate the data using alternative architectures.
Streamline Your Data Analysis with WPS Office
While Power BI handles complex cross-tenant dataflows, you often need a reliable desktop application to view exported datasets, document data models, and share insights. WPS Office is a free, lightweight, and user-friendly alternative to Microsoft Office that easily handles complex spreadsheets and reports.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and follow the simple installation instructions.
- 2. Open Your Exported Data: Launch WPS Spreadsheet and open any .csv or .xlsx files exported from your Power BI dataflows.
- 3. Analyze and Share: Use pivot tables, charts, and formulas to analyze your data, then save or export your findings as a PDF to share with your vendors.
Frequently Asked Questions
Why can't I access a Power BI file from another organization?
Access is frequently blocked by Information Rights Management (IRM) settings or tenant-level sharing restrictions, which require your email address to belong to the provider's organization unless external guest access is explicitly configured.
Can a single Power BI report connect to multiple tenants simultaneously?
Directly authenticating to dataflows in multiple Microsoft 365 tenants within a single report is restricted by standard authentication boundaries. You usually need to consolidate the data into one tenant or use Azure AD B2B collaboration.
How do I request access to restricted IRM files?
If IRM restricts your access, look for a 'Request Access' prompt when attempting to open the file. Clicking this will send an email to the file owner so they can approve your external account.
