ERROR APPLY QUERY CHANGES SQL DATABASE: An unexpected error occurred (file 'tmsavepointvalidation

[kevinkangdinata]

Hi,

Please I need help.

With the latest version 2.81.5854 , an error occur during refresh Apply Query Changes in my report and CMD command SQL DUMPER.EXE suddenly opened and then my refresh stopped then an error message appear as follow:

An unexpected error occurred (file 'tmsavepointvalidation.cpp', line 408, function 'TMSavePoint::VerifyProxyCreationAllowed')

What I did is only additional Appending tables. 

this is my query editor in case if you need (I only add Append Query in the last two rows).

let
Source = Table.NestedJoin(#"Full Entry", {"category_id"}, #"Ticket Account", {"id"}, "Ticket Account", JoinKind.LeftOuter),
#"Expanded Ticket Account" = Table.ExpandTableColumn(Source, "Ticket Account", {"category_group", "name", "header", "Channel", "status"}, {"Ticket Account.category_group", "Ticket Account.name", "Ticket Account.header", "Ticket Account.Channel", "Ticket Account.status"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Ticket Account", each [Ticket Account.category_group] = 1 or [Ticket Account.category_group] = 12),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"id", "create_date", "last_update", "parent_id", "sale_id", "client_id", "inventory_id", "category_id", "payment_id", "vendor_id", "account_id", "qty", "void_qty", "rebate_qty", "price_per_qty", "basic_price_per_qty", "discount_amount", "discount_id", "redeem_qty", "loket_pos sale.sale_date", "loket_pos sale.total_qty", "loket_pos sale.subtotal", "loket_pos sale.basic_subtotal", "loket_pos sale.payment_status", "loket_pos sale.grand_total", "loket_pos sale.deposit_grand_total", "loket_pos account.status", "loket_pos account.name", "loket_pos account.email", "loket_pos account.id_no", "loket_pos account.dob", "loket_pos account.gender", "loket_pos account.nationality_id", "loket_pos vendor.code", "loket_pos vendor.name", "loket_pos vendor.email", "Nationality.nationality_country", "Nationality.nationality_region", "loket_pos inventory.name", "loket_pos inventory.parent_id", "loket_pos inventory.status", "Ticket Account.category_group", "Ticket Account.name", "Ticket Account.header", "Ticket Account.Channel", "Ticket Account.status"}),
#"Inserted Date" = Table.AddColumn(#"Removed Other Columns", "Date", each DateTime.Date([loket_pos sale.sale_date]), type date),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Date",{{"Date", "sale.date - copy"}}),
#"Appended Query" = Table.Combine({#"Renamed Columns", #"Pre-2020 Attendance"}),
#"Filtered Rows1" = Table.SelectRows(#"Appended Query", each [loket_pos sale.sale_date] >= RangeStart and [loket_pos sale.sale_date] < RangeEnd)
in
#"Filtered Rows1"

Im using Import Mode my database is MySQL.

This never occur before.

Please help

[v-chuncz-msft]

@kevinkangdinata 

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/TMSavepoint-VerifyProxyCreationAllowed-error/m-p/1000369#M4...

[JWedge]

Same error has been happening for me.  I think it may have to do with incremental refresh as I have that in common with your query and the issue reoccurs eventually but consistently after fixing and renabling incremental refresh (so far no problems online just in desktop trying to develop)

I found the temporary fix on another post but cannot find it again...

Save problem report as template(.pbit),

Change .pbit to .pbix,

Open as zip archive,

Delete "Security Bindings" file,

No idea what this does but works for me every time and seems to solve some other refresh problems as well (refresh takes forever, gets stuck, do the above, refreshes no problem...)

[HouseOfMax]

@JWedge Thank you so much, this worked for me too. You saved my behind!