Forum Discussion
Csv.Document(), error on earch row.
Hi
Apology, I found this artcile "https://community.powerbi.com/t5/Desktop/The-Csv-Document-parameter-Columns-is-invalid/td-p/28742", but afterwards I now realsie what needed to be changed.
"Csv.Document([Content],[Delimiter=",", Columns=9, Encoding=1252, QuoteStyle=QuoteStyle.None])"
So in my version I added a custom column, and i orginally used '=Csv.Document([Content])'. Aftre reading the article above I changed this to read 'Csv.Document([Content],[Delimiter=",", Columns=9, Encoding=1252, QuoteStyle=QuoteStyle.None])' and it now can see the rows or actual data. What I noticed was, when I looked at the actual excel files on there own, ie a did a separte test or import Excel added an extra column at the end. So intead of 9 columns powerquery throught there were 10. I will close this Message off sorry, hopefullt this will help some one with the same issues.
Many thanks
Chris
Hi
Apology, I found this artcile "https://community.powerbi.com/t5/Desktop/The-Csv-Document-parameter-Columns-is-invalid/td-p/28742", but afterwards I now realsie what needed to be changed.
"Csv.Document([Content],[Delimiter=",", Columns=9, Encoding=1252, QuoteStyle=QuoteStyle.None])"
So in my version I added a custom column, and i orginally used '=Csv.Document([Content])'. Aftre reading the article above I changed this to read 'Csv.Document([Content],[Delimiter=",", Columns=9, Encoding=1252, QuoteStyle=QuoteStyle.None])' and it now can see the rows or actual data. What I noticed was, when I looked at the actual excel files on there own, ie a did a separte test or import Excel added an extra column at the end. So intead of 9 columns powerquery throught there were 10. I will close this Message off sorry, hopefullt this will help some one with the same issues.
Many thanks
Chris