Desktop - Cant Load Model "Something Went Wrong"

[Horizon44]

Hi all,

First time poster, long time reader!

I have an issue which has arisen with one of my major pbix files.

I am unable to load the file using the desktop program. I get an error stating:

"Something went wrong. Failed to save modifications to the server."

It then proceeds to reference a query error along the lines of "no column named" ... and "cannot determine a value" etc.

If the query is broken etc i would love to be able to delete it but my issue is that i cant even open the file to edit/delete the query!

I can only assume that as part of the load process these queries are run and if an error is thrown the program exits before loading!

I have tried almost everything posted from:

1. setting a "false" flag on the "PBI_fastLoadSave " environment variable.
2. Clearing the cache
3. Enabling/disabling parallel loading
4. Downloading another copy of the *.pbix file from the server (which also throws the same error) - Despite the server dashboard dataset is working....
5. Changed the file extension to *.pbit to try and force a load.

The last thing that is completely weird with this error is that it is affecting all my previous backups going back weeks. Which makes me wonder if the query error was present in all these files, then a recent update or external environment change must be now triggering the error. Was there a windows update (such as has previously happened with windows defender) or something that could have caused this?

Any help would be greatly appreciated! Thanks.

[v-chuncz-msft]

@Horizon44,

Try deselecting other options in Data Load as well. If necessary, you may also create a support ticket.

[Horizon44]

Bump

Does anyone or an Mod know how to fix this?

Thanks