Save query changes ignoring data errors

[Kazu]

I am working with a datamart and creating many different queries.

When saving the changes I make, Power BI services not only saves the changes to the queries, but also loads data. In case there are any errors due to data, it does not allow me to save the changes to the query. What is worse, the error messages are often too high level and do not provide necceary details to identify where the error occured like this. They don't even tell which query or table has errors, much less which row or columns. Are there any way to ignore those errors and force save the query changes, and then work on the error later??? It makes no sense to me.

[christinepayton]

This may not be ideal, but what I have done to "save" dataflow queries temporarily in the past is to just copy the code for the table I'm editing from the advanced editor into a text file. That way I can just go back and paste it back in later. Not sure if datamarts allow this or not, and someone else likely has a better solution, but just offering since no one else responded yet. 🙂

[Kazu]

Thanks for the suggestion. After all I had to "save" queries to a text file as you suggested, deleted all queries and saved it, and now am in the middle of adding back queries one by one to see which query was causing the issue. Since it is a datamart, I also had many configurations outside queries and they are lost - relationships, sort by columns, folders and so on. I need to redo whole things again 😞

This is really ridiculous. Why doesnt Microsoft decouple data load from saving queries? It is like source code cannot be compliled because of runtime errors. 

Anyway, thank you very much for responding!