Fix Power BI External Data Menu Missing for Guest Users
Question details
The External Data menu is missing for a guest user trying to access a Power BI dataset shared from a different Microsoft 365 tenant.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- A guest user is attempting to access and interact with a dataset shared across different Microsoft 365 tenants using composite models.
- Observed behavior
- The Power BI External data menu does not appear for the guest user, even though licensing and preview settings appear to be configured correctly.
Verify that your Microsoft 365 guest user account has the appropriate Power BI Pro or Premium Per User (PPU) licenses assigned in both the home and target tenants.
Consult the Official Microsoft Power BI Community
Because cross-tenant dataset sharing involves complex Azure AD (Entra ID) and composite model configurations, the official Power BI Community is the most effective resource for resolution.
Power BI external sharing between tenants relies heavily on Azure B2B collaboration settings and the latest product updates regarding composite models. Troubleshooting this specific missing menu requires product-specific guidance from dedicated Microsoft specialists.
Open your web browser and go to the official Microsoft Power BI Community at https://community.powerbi.com/.
Use the search bar to look up 'External data menu missing guest user' to see if a recent service update has caused a temporary interface change or bug.
If no existing fix is found, create a new post detailing your cross-tenant setup, composite model usage, and current tenant admin settings to get tailored help from Power BI engineers.
Verify Tenant Settings for Guest Users
Ensure that the host tenant explicitly allows guest users to work with shared datasets and external data.
Need a simpler way to analyze data? Try WPS Office
While Power BI handles complex cross-tenant BI environments, everyday data analysis, reporting, and visualization can often be handled perfectly in a robust spreadsheet tool. WPS Office offers a free, highly compatible alternative to Microsoft Office, equipped with powerful data visualization features.
- 1. Download and Install: Get the lightweight installer from the official WPS website and set it up in minutes.
- 2. Open Your Datasets: Launch WPS Spreadsheet and open any .xlsx, .csv, or text-based dataset directly from your local drive.
- 3. Analyze and Visualize: Use built-in pivot tables, formulas, and charts to build comprehensive data reports easily.
Frequently Asked Questions
Why can't I see the Get Data button as a guest user in Power BI?
Guest users often have restricted permissions by default. The host tenant administrator must explicitly enable the 'Allow guest users to build content with shared datasets' setting in the Power BI Admin portal.
Do guest users need a Power BI Pro license to view shared datasets?
Yes. Unless the dataset is hosted in a Power BI Premium capacity environment, both the user sharing the dataset and the guest user accessing it need an active Power BI Pro or Premium Per User (PPU) license.
Can a guest user connect to a Power BI dataset via Excel?
Yes, guest users can use the 'Analyze in Excel' feature for shared datasets, but they must first authenticate with the host tenant's directory and possess the necessary Build permissions on the target dataset.
What are composite models in Power BI?
Composite models allow users to combine direct connections (such as connecting to a dataset hosted in another tenant via DirectQuery) with imported data or other DirectQuery sources, which is often required when pulling in external data.
