Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Creating a Dataflow GEN2 for a Azure blob storage leads to a dataflow that can't be refreshed.
Everything seems to be fine when creating the Dataflow, but it's not possible to refresh. Should I use another connector?
let
Source = AzureStorage.Blobs("stfusxxxxxxsteu002"),
Navigation = Source{[Name = "file-upload"]}[Data],
#"Filtered rows" = Table.SelectRows(Navigation, each Text.Contains([Name], "rtc") and Text.Contains([Name], "m1")),
#"Filtered rows 1" = Table.SelectRows(#"Filtered rows", each ([Extension] = ".csv")),
#"Split column by delimiter" = Table.SplitColumn(Table.TransformColumnTypes(#"Filtered rows 1", {{"Date modified", type text}}), "Date modified", Splitter.SplitTextByDelimiter(" "), {"Date modified.1", "Date modified.2", "Date modified.3"}),
#"Filtered rows 2" = Table.SelectRows(#"Split column by delimiter", each ([Date modified.1] = "5/31/2023")),
#"Changed column type with locale" = Table.TransformColumnTypes(#"Filtered rows 2", {{"Date modified.1", type date}}, "en-US-POSIX"),
#"Filtered hidden files" = Table.SelectRows(#"Changed column type with locale", each [Attributes]?[Hidden]? <> true),
#"Invoke custom function" = Table.AddColumn(#"Filtered hidden files", "Transform file", each #"Transform file"([Content])),
#"Renamed columns" = Table.RenameColumns(#"Invoke custom function", {{"Name", "Source.Name"}}),
#"Removed other columns" = Table.SelectColumns(#"Renamed columns", {"Source.Name", "Transform file"}),
#"Expanded table column" = Table.ExpandTableColumn(#"Removed other columns", "Transform file", Table.ColumnNames(#"Transform file"(#"Sample file"))),
#"Changed column type" = Table.TransformColumnTypes(#"Expanded table column", {{"Source.Name", type text}, {"sensorCode", type text}, {"information", type text}, {"lane", Int64.Type}, {"row", Int64.Type}, {"globalX", type number}, {"productType", type text}, {"base", type number}, {"length", type number}, {"rotation", type number}, {"width", type text}, {"thickness", type number}, {"volume", type number}, {"area", type number}, {"tipPosition", type number}, {"timestamp", type datetime}, {"type", type text}, {"version", Int64.Type}, {"deviceId", type text}})
in
#"Changed column type"
What's the error message that you're receiving when drilling down into any of the failed attempts?