Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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!
Solved! Go to Solution.
Hi @Mario_Lehmann ,
Thank you for reaching out to the Microsoft Fabric Community and for bringing this issue to our attention.
To help ensure this is addressed in a future release, we recommend reporting it in the Issues forum ( https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues).
In the meantime, you may consider reverting to an earlier version of Power BI Desktop as a temporary workaround.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi dear @v-sathmakuri,
thanks for the quick reply. I posted this in the isue forum as you recommended: https://community.fabric.microsoft.com/t5/Issues/Unable-to-open-PBIP-File-ConnectionString-is-not-in...
Hi @Mario_Lehmann ,
Thank you for reaching out to the Microsoft Fabric Community and for bringing this issue to our attention.
To help ensure this is addressed in a future release, we recommend reporting it in the Issues forum ( https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues).
In the meantime, you may consider reverting to an earlier version of Power BI Desktop as a temporary workaround.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |