Forum Discussion

DenHaa's avatar
DenHaa
Frequent Visitor
4 years ago

Issue when importing CSV file

Hello.   I am having an issue when I am importing a CSV-file through the Web query as it limits the amount of columns for some reason. The first time I imported the CSV it had 16 columns, I have s...
Need Help
negi007's avatar
negi007
Community Champion
4 years ago

DenHaa try to remove the changed type step. in this step some column names are passed for processing. 

DenHaa's avatar
DenHaa
Frequent Visitor
4 years ago

I have tried removing that as well so my query is simply:

let
    Source = Csv.Document(Web.Contents("$url"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

When I use this, the following error is shown:

 

As I mentioned in my original post, it works if I do the same process in Excel and the query looks like this:

let
    Source = Csv.Document(Web.Contents("@url"),[Delimiter=",", Columns=26, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
in
    #"Promoted Headers"