Forum Discussion
Helper IAccess Data from another account
Is it possible to connect to a Power BI Dataset that is on a seperate tenant to the one that I want to host the report?
ie. I have two logins for PBI ([email protected] and [email protected]) and am creating dashboardsand reports for the Workspace [email protected]
The dataset I want to use is hosted on [email protected] workspace.
Currently I am pulling data from the dataset uing Analyse in Excel and can easily connect to that to get the data, however I need to manually refresh the Excel table each time I want to update the data.
I am looking for a solution whereby I can automate the data refresh. Any solutions would be greatly appreciated.
Daz4 unfortunately that is not possible. Thru the Power BI desktop, you have no way to log in to a different tenant, it logs into the tenant based on your user account. I don't see it is possible at this point.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
- parry2k
Super User
Daz4 unfortunately that is not possible. Thru the Power BI desktop, you have no way to log in to a different tenant, it logs into the tenant based on your user account. I don't see it is possible at this point.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡