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.
