cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bblais
Resolver III
Resolver III

Potential Issue with spaces in Query Names in Power BI Desktop when refreshing

I can create a dataset from a PBIX file that connects to SQL Server and pulls a measly five rows from a single small table called MatterType in my database.  I can successfully publish this file to Power BI and refresh it manually and/or on a schedule with no problem.

 

HOWEVER, if I simply change the Query Name only for the query to be "Matter Type" instead of "MatterType", and then upload the new PBIX file to Power BI, I get the following error when I attempt to refresh the dataset:

 

Untitled2.jpg

I'm not sure if it's the space that is the issue or just simply renaming the query to anything other than the orginal table name.  This initially occurred on a larger PBIX file I had created where I renamed pretty much every table name to something with spaces in it.  I just went back to basics and created this sample one to test it out and sure enough it seems to always create an issue with refreshes...

 

Thoughts?

 

Thanks

1 ACCEPTED SOLUTION

Okay, so after playing around with it a little more, it seems the fix that works is to use the "Refresh" button from within report section of Power BI Desktop.  The other means of refresh preview/load didn't seem to fix this issue for me, but if I do a refresh from within the report itself then upload the modified PBIX to Power BI and refresh there, the refresh is now working.

 

I'll use this method while awaiting the bug fix...


Thanks

View solution in original post

5 REPLIES 5
curth
Power BI Team
Power BI Team

This is a recently-discovered bug in PBI Desktop. After you rename a query, you'll need to refresh it at least once before saving the PBIX file, otherwise it will produce this inconsistent state.

You mean reload the data inside Power BI Desktop?

Yes. This will force the correct value to be generating for writing to the PBIX file.

Hmmm, I did a "Refresh Preview" from within the query editor, and then I did a "Load" before doing a "Close and Load" just to be sure it reloaded everything.  Then I uploaded/overwrote the PBIX into Power BI and tried to refresh and I'm still getting the same error.

Okay, so after playing around with it a little more, it seems the fix that works is to use the "Refresh" button from within report section of Power BI Desktop.  The other means of refresh preview/load didn't seem to fix this issue for me, but if I do a refresh from within the report itself then upload the modified PBIX to Power BI and refresh there, the refresh is now working.

 

I'll use this method while awaiting the bug fix...


Thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors