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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bokkiem
Frequent Visitor

Unexpected Error: store must be open for this operation

Hello,

I have changed some of my data fields from being True / False to 1/0 so I can count and sum them for visualiszations.

Now that I come to save te PBIX file I am getting this error message : 

 

"Unexpected Error

Store must be open for this operation"

 

I cant seem to find a solution to this.

I have checked and I can access the server and database no problem

Any assistance would be gratefully received.

 

Thanks

 

3 REPLIES 3
v-sihou-msft
Employee
Employee

@Bokkiem

 

I haven't reproduced this issue. What's your data source? And what are those measures with this column involved?

 

Regards,

Hi, Thanks for teh reply Simon.

The data source is a SQL server database.

The columns are in the database as a true / false and are things like whether a project has been approved or not.

 

Thanks

@Bokkiem

 

I still can't reproduce this issue.

 

14.PNG

 

3.PNG

 

4.PNG

 

Did you upgrade your Power BI Desktop into latest version?

 

If this issue still persists, I suggest you open a support ticket.

 

Regards,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.