Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.