cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes"

Prewiew in Power Query works fine, but when when I try to update it fail with this error message:


Apply query changes"

Queries Metadata:

 

Failed to save modifications to the server. Error returned: 'An unexpected error occurred (file 'tmsavepointvalidation.cpp', line 458, function 'TMSavePoint::VerifyProxyCreationAllowed').

 

I have never seen this error before... May be it has to do with the new feature enhanced metadata format?

 

Reagards!

 

34 REPLIES 34
Highlighted
Super User IV
Super User IV

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Check and log a ticket on https://powerbi.microsoft.com/en-us/support/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Running into the same issue, PBI is my full-time job and I've also never seen this error. 

Highlighted
Community Support
Community Support

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Hi @AslakJonh , @jadagostino1993 ,

 

Sorry for that we cannot reproduce this issue here and we also did not seen this kind of error before, Does it only happened in the March 2020 version of Power BI Desktop? Are there any change applied to power query editor before orrur this error? Does this error only happen in spetical report or all  reports? Have you tried to re-install the Power BI Desktop or use the MS Store version?


Best regards,

 

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Yep, just started getting the same issue as well. Happened after I added a column to a query. Worked fine in Query window; error appeared when attempting to apply to PowerBI Desktop report.

Highlighted
Advocate III
Advocate III

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Hi,

"Does it only happened in the March 2020 version of Power BI Desktop?" Yes, as I said, when I downgraded to the feb-version it works fine. (I had to build the report from scratch, because of the changed format. The feb-version could not read the PBIX-file from the mach-version. And yes, I also tried to rebuild from scratch in the march-version and the error accoured again.

 

"Are there any change applied to power query editor before orrur this error?" Yes, the report worked in the beginning of developing the report. It's a report against a Postgres-database with hundres of schemas. The query uses a M-function and loops through the same table in differnt schemas to to build one big common table. Then I think the error accoured. Her is the code:

let
Source = (pSchema2 as text) => let
Source = PostgreSQL.Database("XXXXXXX", "insight"),
rm1000_f_application = Source{[Schema=pSchema2,Item="f_application"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(rm1000_f_application,{"id", "date_applied", "date_deleted", "commission", "candidate", "gender", "source", "publishing_place_id", "age", "orgunit", "workarea", "workspecialization_id", "date_last_apply", "application_ref", "specific_ref"})
in
#"Removed Other Columns"
in
Source

 

And the calling code:

 

let
Source = #"Tenant filter Server2",
#"Invoked Custom Function" = Table.AddColumn(Source, "f_application2_", each fnc_application2([Schema])),
#"Removed Columns" = Table.RemoveColumns(#"Invoked Custom Function",{"id", "name", "Server", "Schema"}),
#"Expanded f_application2_" = Table.ExpandTableColumn(#"Removed Columns", "f_application2_", {"id", "date_applied", "date_deleted", "commission", "candidate", "gender", "source", "publishing_place_id", "age", "orgunit", "workarea", "workspecialization_id", "date_last_apply", "application_ref", "specific_ref"}, {"id", "date_applied", "date_deleted", "commission", "candidate", "gender", "source", "publishing_place_id", "age", "orgunit", "workarea", "workspecialization_id", "date_last_apply", "application_ref", "specific_ref"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded f_application2_",{{"KeyConstant", Int64.Type}, {"id", Int64.Type}, {"date_applied", type text}, {"date_deleted", type text}, {"commission", Int64.Type}, {"candidate", Int64.Type}, {"gender", Int64.Type}, {"source", Int64.Type}, {"publishing_place_id", Int64.Type}, {"age", Int64.Type}, {"orgunit", Int64.Type}, {"workarea", Int64.Type}, {"workspecialization_id", Int64.Type}, {"date_last_apply", type text}, {"application_ref", Int64.Type}, {"specific_ref", Int64.Type}}),
#"Split Column by Positions" = Table.SplitColumn(#"Changed Type", "date_applied", Splitter.SplitTextByPositions({0, 4, 6}), {"date_applied.1", "date_applied.2", "date_applied.3"}),
#"Split Column by Positions1" = Table.SplitColumn(#"Split Column by Positions", "date_deleted", Splitter.SplitTextByPositions({0, 4, 6}), {"date_deleted.1", "date_deleted.2", "date_deleted.3"}),
#"Split Column by Positions2" = Table.SplitColumn(#"Split Column by Positions1", "date_last_apply", Splitter.SplitTextByPositions({0, 4, 6}), {"date_last_apply.1", "date_last_apply.2", "date_last_apply.3"}),
#"Merged Columns" = Table.CombineColumns(#"Split Column by Positions2",{"date_applied.1", "date_applied.2", "date_applied.3"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Date Applied"),
#"Merged Columns1" = Table.CombineColumns(#"Merged Columns",{"date_deleted.1", "date_deleted.2", "date_deleted.3"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Date Deleted"),
#"Merged Columns2" = Table.CombineColumns(#"Merged Columns1",{"date_last_apply.1", "date_last_apply.2", "date_last_apply.3"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Date Last Apply"),
#"Changed Type1" = Table.TransformColumnTypes(#"Merged Columns2",{{"Date Applied", type date}, {"Date Deleted", type date}, {"Date Last Apply", type date}}),
#"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type1", {{"Date Deleted", null}}),
#"Replaced Errors1" = Table.ReplaceErrorValues(#"Replaced Errors", {{"Date Last Apply", null}}),
#"Replaced Errors2" = Table.ReplaceErrorValues(#"Replaced Errors1", {{"Date Applied", null}})
in
#"Replaced Errors2"

 

 

"Does this error only happen in spetical report or all  reports? " I have seen the error only in this report.

 

"Have you tried to re-install the Power BI Desktop or use the MS Store version? " Yes, many times! (Switch between feb. and marcg-version.

 

 

Regards

Aslak

Highlighted
Community Support
Community Support

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

Hi @AslakJonh ,

 

Thanks for your additional details, your queries seems very fine, could you please try to verify whichi step will cause this error by creating a backup first, then delete last one step in the steps panel and save each time? Ineed, there is  a new feature about metadata included in march 2020, but it did not enable defaultly, so we do not think it will be the reason of this issue.

 

Hi @Axe , @jadagostino1993 ,


Do you connect a postgresql data source too?


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Impactful Individual
Impactful Individual

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

I am getting the same error connecting to a public website.

 

let
    Source = Json.Document(Web.Contents("https://opendata.ecdc.europa.eu/covid19/casedistribution/json/")),
    #"Converted to Table" = Record.ToTable(Source),
    #"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value"),
    #"Expanded Value1" = Table.ExpandRecordColumn(#"Expanded Value", "Value", {"dateRep", "day", "month", "year", "cases", "deaths", "countriesAndTerritories", "geoId", "countryCode", "popData2018"}, {"Value.dateRep", "Value.day", "Value.month", "Value.year", "Value.cases", "Value.deaths", "Value.countriesAndTerritories", "Value.geoId", "Value.countryCode", "Value.popData2018"})
in
    #"Expanded Value1"

 Works ok in Power Query but errors when I Apply.

Highlighted
Frequent Visitor

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

I have similiar issues. I thought that something with the report is wrong, but I haven't change nothing. Some errors occur when I refresh the report (pbix) and in case of succesfull refresh some tables are not refreshed completely (missing records). Two days ago Power Query says error in column type and failed to refresh. Next time refreshed, that's was very wierd. Now I tried to Refresh All in Power Query and refresh again the report.

Highlighted
Frequent Visitor

Re: Bug in Desktop, Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes

I'm connecting to a redshift DB + a onedrive file that I merge to one of the redshift pulls for some hierarchy mapping.

 

Potential Issues:
1.) The only change I made on the query side was merging two tables from the same DB together. 

 

2.) I read elsewhere people were running into this issue when they delete query folders, which is something that I did do yesterday so I'm looking into that.

 

3.) I always enable all preview features, while reading up on the enhanced metadata refresh I learned that once converted you can no longer use SSO data sources. Would connecting to my onedrive file using my organizational account count as SSO?

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors