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
Heinet's avatar
Heinet
Frequent Visitor
2 years ago

Hi JoeBarry

 

This is activated and I tried to share it right now by mail, but getting the error "Sorry, we can't find the specified dataset

The object may have been deleted, or you lack access to see it"

(Translated by me, so the text might differ from the english error)

 

when accessing the link with the user I shared it to

  • 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