Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
In the power bi ecosystem you are able to connect a power bi file directly to another published dataset. But what if I want to move the dataset to
- another workspace
- another tentant
Right now I am developing a solution for a customer of mine - and I publish all datasets to my tenant. Right now I want to create a new report using an existing dataset. But when it comes to delivery to my customer I face the problem that I am not able to change connection information in the report which is using the other dataset.
What I already tried: I created a test scenario in my tenant with a dataset A and created a new file B using dataset A. I moved dataset A to another workspace, created another report C using the dataset A (in the new workspace). I unzipped report C and opened the connection-string in the "Connections" file. In file B I updated the connection information in"Connections" with the information of report C - but that did not work. Power BI is not able to open the file anymore...
Any hints?
Thanks a lot
Holger
I'm not sure about the implications of being on separate tenants, but I was able to use the "Connection Settings" under Transform data to redirect my report to a copy of my shared Power BI dataset published to another workspace in the same tenant.
Once I saved the update, I popped open the connections file in the report .pbix and confirmed that the dataset id had changed to the new one.