Forum Discussion
Helper IIPower BI Service connection: change from dev to production
AlexeyRusinov,
In Step 2, I replace PbiServiceModelId rather than PbiServiceGroupId, then save the Connections file and rename it back to PBIX.
Regards,
Lydia
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
Helper IIHello 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,
LydiaAnonymous :
Hi Lydia. In previous comment you wrote "In Step 2, I replace PbiServiceModelId rather than PbiServiceGroupId. . .". I see this comment was made in Aug-2017, and I'm writing this in Feb-2019.
I wonder if the PBIX zip file structure/content has changed since then.
Here is abbreviated/edited content of a current "Connections" file:
Initial Catalog=Some-GUID-For-Dataset-Goes-Here;
"PbiServiceModelId":Some7DigitNumber,
"PbiServiceGroupId":"Different-GUID-For-Workspace-Goes-Here",
"PbiModelDatabaseName":"Some-GUID-For-Dataset-Goes-Here"It seems I have all the pieces (in red) I need to manually update this to point it do a different dataset in a different workspace (i.e. belonging to a different customer) - all EXCEPT FOR the "PbiServiceModelId". How/Where can I get this value?
Even though MS is promoting and encouraging the usage of Shared Datasets, they have not provided support for this in automated deployments (i.e. PBI REST API). Which means we're stuck - we can't deploy to all our customers unless we manually do the steps within Power BI Desktop, which isn't practical for many, many customers.
Can you please tell me how/where to get the "PbiServiceModelId" value?
Thanks,
Greg
Hi,
Had the same issue. If it can help, the PbiServiceModelId property is the Dataset's "id" property.
You can get it using a variety of ways:
a. Create another PowerBI report referencing the dataset you want the ID of, save it, extract it, and look in the Connections file
b. Use the PowerBI REST API (eg. Get Dataset By ID in Group in my case) - note that this requires authentication, as your browser isn't authenticated on api.powerbi.com
c. Using Chrome or any other developer-friendly browser, open the report list, the Developer Tools, and look in the network responses (in particular, a response from https://*.analysis.windows.net/powerbi/metadata/app), and check the models property for a list of your available datasets in your current workspace.
