Forum Discussion

Heinet's avatar
Heinet
Frequent Visitor
2 years ago

Update data from power bi dataset in Excel - Different domains

Hi   We have a couple of excel workbooks used by the financial department where they get data from a power bi dataset. We are split into 2 companies, and 2 domains (@aaa and bbb) and some users who...
Need Help
JoeBarry's avatar
JoeBarry
Icon for Solution Sage rankSolution Sage
2 years ago

What is your status? Do you have normal access (meaning you're not a guest) to both Tenants or are you a guest in one of them?

 

If you are a guest, then someone needs to invite from within Azure AD as a guest.

 

When they have done this, either someone shares the dataset with you, there will be a "ext" within your email when they are typing. Something like this

test_test.com#EXT#@myyourcompany.onmicrosoft.com

Follow that link after you receive it and follow the instructions. The same would need to be done for any other user

Heinet's avatar
Heinet
Frequent Visitor
2 years ago

Hi again JoeBarry

 

I have both a guest account (like you shown in the spoiler tag) and an admin account in the tenant. So I testing with my guest account. I still get the same error when trying to get the data from the dataset with the guest account, no matter which type of access I have set. Also tested with a colleague now, same effect.

He can see the report and dataset while logged into powerbi with the user in the other tenant, but can't access the dataset from excel