Connect Power BI Desktop to External Dataset

[Itzarthi]

Hi,

A dataset was shared with me from another organization. The checkmarks in this organization have been turned on to share the dataset with me.

But now in Power BI Desktop I do not see the button for External Data. Do I need an additional license for this? Or do I need to turn on something in my organization to connect to the external dataset?

Thanks in advance!!

[v-yangliu-msft · Accepted solution]

Hi  @Itzarthi ,

If you connect to an external data source, you need permission to edit this dataset, and as long as this dataset is not in a Premium capacity, you need to have Pro permissions.

Because they are different organizations, You can also use planned invitations to turn accounts of different organizations into guest users.

Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Learn

Go to the Microsoft 365 admin center and ask your organization's admin to give you Power BI Pro permissions (provided you have more pro accounts in that organization).

Understanding Power BI administrator roles - Power BI | Microsoft Learn

Assign licenses to users in the Microsoft 365 admin center - Microsoft 365 admin | Microsoft Learn

Give this guest member permission, this user can enter tenant, access the reports and data sets inside

Roles in workspaces in Power BI - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Itzarthi , check the service setting (tenant settings) are done

https://powerbi.microsoft.com/en-us/blog/introducing-cross-tenant-power-bi-dataset-sharing/

[Itzarthi]

Yes, the service settings are done. I don't have a specific Power BI license, can that be the problem?