Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I'm really confused right now and hope someone can point me into the right direction.
I want to share a dataset with users from outside of my organisation, actually I want the external users to be able to connect to the dataset through Excel and also creating reports by themselves. Also the dataset and reports should be available in the external users tenant (cross tenant sharing).
Alright. In order to test settings I created a user that is not inside my regualar organization. I did a planned invite and am able to select the user from the dropdown. The username has EXT in the name, so that worked. I gave the user full permission and enabled external sharing on dataset level like adviced (https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-external-org-share-prov...
So far so good.
1)
When I go to app.powerbi.com and log in with this user, I'm only able to see my (blank) workspace. No external dataset. Same applies for Excel and PowerBI Desktop (with the preview feature enabled). I even did wait for several days like suggested in another post (althougt that would be a strage behaviour).
2)
When I use the tenant url I am able to see the shared dataset and reports, but I have no idea how to connect to this tenant through excel and PowerBI Desktop. I tried the analye in excel button but once I open the excel file, the connection fails.
When loggin in with app.powerbi.com (1) I'm able to see workspaces and all the other buttons, also I can see the remaining days of the trial phase. When using the tenant url (2) I do not have the menu on the left side and also no trial phase.
Unfortunatelly I'm no PowerBI admin so I can not tell you any specific settings. Maybe one of you can let me know which settings our admin needs to set.
Thanks!
Solved! Go to Solution.
Hi @whereismydata ,
Please check that the following steps are followed:
In addition to this there are some restrictions:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Has this issue been solved (especially the analyzing semantic model as external tenant in Excel part)?
We're experiencing many problems with this despite following all steps suggested by @v-tangjie-msft .
We have a premium capacity in place and wanted to retire or AAS Model, which is currently used with our external users. But as of now, it does not seem to work properly.
hi, unfortunatelly not. In our case it was a tenant setting I was not aware of since I am no admin. My company blocked this feature because it is still in preview. I switched to datamarts instead, although still in preview, my company can not block me from using it.
Hi @whereismydata ,
According to the documentation, you can use guest users from different tenants to share datasets with guest users on their own tenant using Azure Active Directory guest accounts. To help allow guests to log in to Power BI, please provide them with the tenant URL.
To enable sharing datasets with guest users, you must enable the "Allow external users to discover and use this dataset" option in the dataset settings.
To access the shared dataset, you must use Power BI Desktop and turn on the Preview feature: PBI Dataset and AD's Direct Query and Connect to External Dataset Shared with Me.
If you encounter errors when connecting to a Power BI dataset using the direct query mode in PBI Desktop, you can turn on the "Allow XMLA endpoints and use local datasets for analysis in excel" switch in the tenant settings.
It is also important to note that linked sharing is not yet supported for external users, but users can still share with external users using direct sharing.
Please refer to the following documents for more information.
Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Learn
Share B2B datasets with external guest users (preview) - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
I think I followed the documentation.
still I do not see the dataset inside power bi desktop.
is there some tenant setting missing?
Hi @whereismydata ,
Please check that the following steps are followed:
In addition to this there are some restrictions:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In new powerBI Desktop, we can't see Direct Query for powerBI Datasets and AS option.
Also we are able to see dataset in powerBI Desktop but getting
and error as "Live connection is not vaila le for accessing models in an external organization, Directquery connection is require"
i am not sure , what it means.
can u pls help here.
@v-tangjie-msft
Hi @v-tangjie-msft ,
thanks again for taking time to respond. I asked my tenant admin to have a look at the settings.
Hi @whereismydata ,
Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @v-tangjie-msft
thanks for sharing the tenant setting screenshots. I provided them to our tenant admin and it seems that one settings in not enabled (the "Allow guest users to work with shared datasets in their own tenants" setting)
but I'm curious. The other setting is enabled and I'm able to select the external sharing in the dataset settings. Also I am able to give permissions to my test account.
So, is there a way to analysize data in excel with the given setup? Somehow I can not force excel to use the tenant url to connect to the dataset
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
13 | |
8 |
User | Count |
---|---|
50 | |
39 | |
32 | |
15 | |
13 |