Updating .mez Query for Power BI

Hi seanpratt ,

Sorry for our delay in response, if you mean the fix is changing the query in advanced editor, we need to republish to the service. First of all, we suggest to download pbix from service, so that it will as the same as the report from service, then we apply change in the pbix file, publish and replace the origin one, 

This process is straightforward, but there are a few things you should know:

• Two or more datasets in Power BI with the same name as the Power BI Desktop file could cause publishing to fail. Make sure you have only one dataset in Power BI with the same name. You can also rename the file and publish, creating a new dataset with same name as the file.
• If you rename or delete a column or measure, any visualizations you already have in Power BI with that field could be broken.
• Power BI ignores some format changes of existing columns. For example, if you change a column’s format from 0.25% to 25%.
• Say you have a refresh schedule that is configured for your existing dataset in Power BI. When you add new data sources to your file and then republish, you’ll have to sign into them before the next scheduled refresh.
• When you republish a dataset published from Power BI Desktop and have a refresh schedule defined, a dataset refresh is started as soon as you republish.

Please refer to this document about how to Republish or replace a dataset published from Power BI Desktop:https://docs.microsoft.com/en-us/power-bi/desktop-upload-desktop-files#republish-or-replace-a-dataset-published-from-power-bi-desktop

Then we may need to execute a on-demand or scheduled refresh to make the data changed with the new query. We strongly recommend test the "republish to replace" feature with a sample pbix file first.

Best regards,