July 17, 2018
A new error from Power query seems to have added something to the url after ?cid=
the file is there and I can access it open it etc there are actually two queries using 2 different files that return the same error.
DataSource.Error: Web.Contents failed to get contents from 'https://xxx.sharepoint.com/sites/FoodIndustryUK/Shared%20Documents/Pipeline%20Launch%20Tracker/Launch%20Tacker%20Sales%202024.xlsx?cid=6e64abf0-dac7-4300-9763-f33e491a1476' (404): NOT FOUND
Details:
DataSourceKind=Web
DataSourcePath=https://xxx.sharepoint.com/:x:/r/sites/FoodIndustryUK/Shared%20Documents/Pipeline%20Launch%20Tracker/Launch%20Tacker%20Sales%202024.xlsx
Url=https://xxx.sharepoint.com/sites/FoodIndustryUK/Shared%20Documents/Pipeline%20Launch%20Tracker/Launch%20Tacker%20Sales%202024.xlsx?cid=6e64abf0-dac7-4300-9763-f33e491a1476
let
Source = Excel.Workbook(Web.Contents("https://xxx.sharepoint.com/:x:/r/sites/FoodIndustryUK/Shared%20Documents/Pipeline%20Launch%20Tracker/Launch%20Tacker%20Sales%202024.xlsx"), null, true),
#"2022 Launches _Sheet" = Source{[Item="2024 Launches",Kind="Sheet"]}[Data],
#"Removed Top Rows" = Table.Skip(#"2022 Launches _Sheet",6),
#"Promoted Headers1" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Removed Other Columns" = Table.SelectColumns(#"Promoted Headers1",{"Index", "Pipeline Launch", "Status", "New / Replace", "Customer", "Product Code", "Product Title", "Wet/Dry", "Pack Size kgs", "Pack Format", "Moguntia Developer", "Launch Date", "Comments", "Retailer", "Account Manager Full"}),
#"Split Column by Character Transition" = Table.SplitColumn(Table.TransformColumnTypes(#"Removed Other Columns", {{"Pack Size kgs", type text}}, "en-GB"), "Pack Size kgs", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9","."}, c)), {"Pack Size kgs", "Unit"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Character Transition",{{"Pack Size kgs", type number}, {"Launch Date", type date}, {"Pack Format", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Launch Year", each [Launch Date]),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Launch Month", each Date.ToText([Launch Date],"MMM")),
#"Extracted Year" = Table.TransformColumns(#"Added Custom1",{{"Launch Year", Date.Year, Int64.Type}}),
#"Replaced Errors" = Table.ReplaceErrorValues(#"Extracted Year", {{"Launch Date", null}}),
#"Replaced Errors1" = Table.ReplaceErrorValues(#"Replaced Errors", {{"Launch Year", null}}),
#"Replaced Errors2" = Table.ReplaceErrorValues(#"Replaced Errors1", {{"Launch Month", null}}),
#"Removed Blank Rows" = Table.SelectRows(#"Replaced Errors2", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
#"Removed Blank Rows"
1 Guest(s)