Error 401 connecting external Power BI dataset

Hi, wrigh2uk 

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,

Community Support Team _Charlotte

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