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-provider). 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!

Hi whereismydata , Please check that the following steps are followed: On the Power BI service, if you want to share datasets with guest users, you must enable these two settings: Then you can open the dataset, select the Share button, and enter the guest user. Within the dataset Settings, go to the External sharing section, and enable the Allows external users to discover... option (Note if the customer does not see the External sharing section, the Allow guest users to work with shared datasets in their own tenants tenant setting may not be enabled) To access the shared dataset, you must use Power BI Desktop. Turn on preview features: DirectQuery for PBI dataset and AD and Connect to external datasets shared with me Get data from Data hub and select the new tab that appears if the user is a guest in another user's tenant named External data Find the dataset and Connect to it, select item and Submit to create the connection Dataset appears and can be used. You can also add another dataset to include in report to create the composite model At this point, the dataset is the same as any other dataset that can be used to create a report in the Desktop or Service. 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.

Sharing dataset with external users | Microsoft Fabric Community

Forum Discussion

Related content

Share report with external

External Client App Share

Sharing Reports Externally

External data sharing in fabric

Request for Guidance: Sharing Power BI Report with External User