Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Power Bi file would not open: Unable to convert an M query in table 'XXX' into a native source query

I have a direct query report that had been working and I even have the report running in the service currently.  But yesterday when I updated the power bi desktop file to the latest version now i can't load the file in bi desktop.  I am getting the msg: Failed to save modifications to the server.  Error returned: 'Unable to convert an M query in table 'XXX' into a native source query.  I have googled around and seems like there are some people that are able to fix it by changing any transformation steps in power query.  The problem for me is that i can't even get to open the file.  I have tried installing earlier versions of this year but I can't open and getting a different msg:  one or more errors occured and can't get any further.  Or another msg: something about arrays and can't go any further.  I can't get back the same version I had working because it is from July 2020 and i cant find that version on line anymore.  


Is there a way for me to load the file and at least let me get back in to fix the transformation steps in power query?  And again, this file/report was working fine, and it is still running in service as we speak.  I really hope i don't have to redo this.  Hope someone can help. Thanks. 

Community Support
Community Support

Hi @wpf_ ,


Has the problem be solved?


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User
Super User

@wpf_ , I can see few issues reported on the new release. Check if they can help or log a new one

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!