Hello,
I've been trying to create a new dataflow that is combining csv files from a folder on my computer but I keep getting the below error, when I try to combine the cvs in PowerBI Service
I was able to import the folder and combine it with no issues in the PowerBI Desktop version, and I made sure my gateway and PowerBI software were up to date.
Not sure what else I can do to create this workflow, I already have 25+ workflows created with no isssues.
section Section1;
shared #"CUIC Calls" = let
Source = Folder.Files("C:\Users\..."),
#"Filtered hidden files" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true)
in
#"Filtered hidden files";
shared #"Sample file" = let
Source = Folder.Files("C:\Users\..."),
#"Filtered hidden files" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
Navigation = #"Filtered hidden files"{0}[Content]
in
Navigation;
shared Parameter = let
Parameter = #"Sample file" meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type binary, BinaryIdentifier = #"Sample file"]
in
Parameter;
shared #"Transform Sample file" = let
Source = Csv.Document(Parameter, [Delimiter = ",", Columns = 14, Encoding = 65001, QuoteStyle = QuoteStyle.None]),
#"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
#"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"AgentTeamName", type text}, {"AgentName", type text}, {"DateTime", type datetime}, {"Queue", type text}, {"HandledTime", type time}, {"RingTime", type time}, {"TalkTime", type time}, {"HoldTime", type time}, {"ConferenceTime", type time}, {"WrapUpTime", type time}, {"Direction", type text}, {"Variable2", type text}, {"DigitsDialed", Int64.Type}, {"ANI", type text}})
in
#"Changed column type";
