Forum Discussion

AlexaderMilland's avatar
AlexaderMilland
Icon for Helper III rankHelper III
1 year ago

PowerBI data in excel not working on a specific PC

So my PC is "owned" by corperation A, which I have my main email/microsoft account in.

I'm a consultant, currently working on corperation B, which has given me a new email/microsoft account on their tenant. 

 

My problem is that, whenever i want to explore/query PowerBI data from company B while logged into excel on my company B account i keep getting errors such as "do not have access". However this account surely has access,  it's the same account I'm using to upload the data, and if I'm logged into the account on my non-company PC i can easily query the data in excel from company B.

 

Does anyone have  an idea of what sort of security settings could be enabled?

 

1) If I'm on my company A account i can query company A data - regardless of PC

2) If i'm on my company B account i cannot query company B data - when im on company A pc

3) If I'm on company B account i can query company B data from another PC. 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi AlexaderMilland ,

    Try clearing the cache first

    Are all computers in company A unable to access company B's Power BI Service by logging into company B's account? I think I need to ask IT if it is because of the use of an internal private network.

    Check whether the device has joined the organization's network

     

    Best Regards,
    Wenbin Zhou

    • AlexaderMilland's avatar
      AlexaderMilland
      Icon for Helper III rankHelper III

      Other computers in company A can access company B data while logged into my company B account.

      I just tried on a loaner PC which could easily fetch the data. 

       

      Clearing cache in excel did not resolve the issue.  

       The computer is only inside organizations A network - and so is the other computers I've tried on that are working. 

    • AlexaderMilland's avatar
      AlexaderMilland
      Icon for Helper III rankHelper III

      Just tried and I can fetch data from DATAFLOWS that are available in the exact same workspace. 
      So it's only PowerBI Semantic models that my excel apparently can't fetch from.