Forum Discussion
Helper IIPower BI Service connection: change from dev to production
Hello everyone,
I am creating a lot of reports for Dynamics 365, and want to deliver it to a lot of users in customer departments and different roles.
My idea was to design a data structure using Query Editor, with all entities that are required for my reports, and publish this dataset.
After that, connect to it using Power BI Service Live Connection, test and adjust it, then deploy it to users, changing data source from dev to prod.
However, it occurs to me now that I cannot change a connection here, and have to create a report with the prod connection on the first place.
Is it correct? Maybe you can advice me, what is the best way to deliver reports for dynamics 365, with dev/prod separation?
AlexeyRusinov,
In Step 2, I replace PbiServiceModelId rather than PbiServiceGroupId, then save the Connections file and rename it back to PBIX.
Regards,
Lydia
8 Replies
AlexeyRusinov Connecting to the existing dataset will return you the connections from the dataset and allow you to build on top of it. You won't be able to change the connection.
However, it occurs to me that you might be able to change the original dataset.Do a quick test. Publish Dev, create another report on the dataset using the live connection to the dataset, publish.
Change the original connection in the 1st PBIX and re-publish. I would assume the 2nd report would also update to using the new one... Or, break.
AlexeyRusinovThank you for you reply Anonymous,
>Change the original connection in the 1st PBIX and re-publish
I will need to publish first PBIX to different place, with different people and different 365 domain using them. Will it still work?
AlexeyRusinov,
Actually, the capability that change connection for Power BI Service dataset is on the team’s backlog. For more details, please take a look at Sirui’s comment in this blog.
Currently, you can try to copy PBIX file to ZIP file, edit Connections file in the ZIP file and rename zip file to PBIX file.
In addition, in Power BI, you can publish PBIX file to "My Workspace" and your App workspaces. Then in Power BI Service, you can create dashboard for your dataset and share the dashboard to other users.
Regards,
Lydia- AlexeyRusinov
Hello Anonymous, thank you for your response.
>Currently, you can try to copy PBIX file to ZIP file, edit Connections file in the ZIP file and rename zip file to PBIX file.
I tried it, changed three parts:
- ConnectionString, InitialCatalog part is replaced by id of new Dataset id
- PbiServiceGroupId, replaced by new workspace id
- PbiModelDatabaseName, replaced by new dataset id
After that I save the file, rename back to PBIX, but it cannot connect and return an error "Looks like the we're unable to access the dataset. Please contact the owner of the dataset."
Am I doing something wrong? Are there a successful examples of such method?
AlexeyRusinov,
In Step 2, I replace PbiServiceModelId rather than PbiServiceGroupId, then save the Connections file and rename it back to PBIX.
Regards,
Lydia