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
DenHaa's avatar
DenHaa
Frequent Visitor
4 years ago

I have tested this again today and the issue still remains.

 

When I try to load the CSV-file into PowerBI it shows the last 10 columns to be empty, and therefor they are not included by default.

If I try to load the CSV-file into Excel, it works without any issues and includes all 26 columns.

 

I have compared both of the queries and they seem identical to me:

 

PowerBI Query:

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

 

Excel Query:

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"

 

I have even tried copying the query from Excel into PowerBI, but it still fails in the same way, the last 10 columns are registered as empty and therefor not included.