Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
we get an error since one of the last power bi updates. When we open any of our existing Power BI Project File (.pbip) with PBI Desktop and simply save them with or without changing content then we get the following error message when we reopen that saved file.
Error Message:
An error occurred while trying to open [OurFilePath]. ConnectionString is not in the expected format.
We connect to a power bi service semantic model which has a live connection to a OnPrem SSAS Tabular Model via Gateway.
We saved our files in Git, so we see that the definition.pbir file has been changed by saving the .pbip file with PBI Desktop. There are two suspicious changes:
1) The Connections String Syntax changed from:
"connectionString": "Data Source=[OurSSASServerName];Initial Catalog=[OurDatabaseName];Cube=Model;Integrated Security=ClaimsToken",
"pbiServiceModelId": [OurModelId],
to
"connectionString": "Data Source=powerbi://api.powerbi.com/v1.0/myorg/[OurWorkspaceName];Initial Catalog=[OurSemanticModelName´]";Cube=Model;Access Mode=readonly",
"pbiServiceModelId": null,
2) The connectionType Property changed
from: "connectionType": "pbiserviceOnPremLive"
to: "connectionType": "pbiServiceXmlaStyleLive"
If we just reset the definition file via git, we can reopen the file without any problems, so we have a workaroud for this problem. But I don't think this behavior is correct or intended.
Can anybody help us with this problem?
Thanks!
PS: Original Post here: https://community.fabric.microsoft.com/t5/Developer/Unable-to-open-PBIP-File-ConnectionString-is-not...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.