Forum Discussion
Error During Data Refresh
I can not provide specific comments due to lack of informarion from your side.
Maybe you can explain in more detail what you are trying to and exactly at which point you get the error?
I am simply trying to Refrsh an existing dataset with an updated file. There are a series of steps I have taken in the Query Editor as well as renaming columns - but like my other work in Power BI I move the updated file, Click Refresh and was expecting the data to update.
I am wondering if changing the column names or some of the cleanup I am performing in the Query Editor are corrupting the process.
Maybe.
Can you share your query code (copy/paste from the advanced editor)?
As an example, this is the error I get when importing files from a folder and Book3.xlsx is missing:
let
Source = Excel.Workbook(File.Contents("C:\Users\-----\OneDrive - XXXX.xlsx"), null, true),
#" Daily Report_Sheet" = Source{[Item="Daily Report",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Daily Report_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"event_date", type date}, {"publisher_id", Int64.Type}, {"publisher_name", type text}, {"advertiser_id", Int64.Type}, {"advertiser_desc", type text}, {"campaign_id", Int64.Type}, {"campaign_desc", type text}, {"line_item_id", Int64.Type}, {"line_item_desc", type text}, {"line_item_start_date", type date}, {"line_item_end_date", type date}, {"status", type text}, {"pricing_type", type text}, {"bid_amount", type number}, {"ad_slot_id", Int64.Type}, {"ad_alot_name", type text}, {"ad_slot_status", type text}, {"size", type text}, {"mail_type", type text}, {"template_id", Int64.Type}, {"template_name", type text}, {"impresions", Int64.Type}, {"clicks", Int64.Type}, {"conversions", Int64.Type}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"impresions", "Impressions"}, {"clicks", "Clicks"}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Renamed Columns", "publisher_name", "publisher_name - Copy"),
#"Replaced Value" = Table.ReplaceValue(#"Duplicated Column","ACBJ","",Replacer.ReplaceText,{"publisher_name - Copy"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","(","",Replacer.ReplaceText,{"publisher_name - Copy"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",")","",Replacer.ReplaceText,{"publisher_name - Copy"}),
#"Renamed Columns1" = Table.RenameColumns(#"Replaced Value2",{{"publisher_name - Copy", "Market"}, {"advertiser_desc", "Advertiser"}, {"template_name", "Product"}, {"size", "Size"}, {"event_date", " Date"}, {"Impressions", "Impressions2"}, {"Clicks", "Clicks2"}, {"line_item_desc", "Line Item Description"}})
in
#"Renamed Columns1"Probably the error occurs at step #" Daily Report_Sheet"?
Then there is no record in your Source with Item="Daily Report" and Kind="Sheet".
You can check if you select the Source step in the qury editor and check that table (which is a so called navigation table with accessible elements in your Excel Workbook).
In the code I see #" Daily Report_Sheet" and #"Daily Report_Sheet".
These should be the same.