Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Mario_Lehmann
New Member

Unable to open PBIP File - ConnectionString is not in the expected format

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!

1 ACCEPTED SOLUTION
v-sathmakuri
Community Support
Community Support

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!!

View solution in original post

2 REPLIES 2
Mario_Lehmann
New Member

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...

v-sathmakuri
Community Support
Community Support

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!!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.