Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago
Solved

The Csv.Document parameter 'Columns' is invalid.

Hi everyone,   I am having the following issue on a couple reports I have built. So far the only options on the community forums is to either change from a personal gateway to an enterprise one (Th...
Need Help
  • GilesWalker's avatar
    GilesWalker
    10 years ago

    My IT department managed to fix the issue. We went through the advanced editor in query mode and manually changed the coding to get it to work.

     

    This is how we did it:

     

    This line of text is incorrect:

     

    Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter=","columns=10, Encoding=1252]),

     

    The columns=10 was counting the columns in the document (10 is correct) but something was going wrong. We deleted this text but lef tin the commas and republished the file. It then failed again due to this error:

     

    The Csv.Document parameter 'QuoteStyle' is invalid. From memory the advanced editor text looked like this:

     

    Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter=","columns=10, Encoding=1252]), QuoteStyle=QuoteStyle""

     

    We deleted the QuoteStyle text and republished. The dashboard now refreshes using the automated refresh feature in Pro.

     

    Thanks,

     

    Giles

Anonymous's avatar
Anonymous
Not applicable
4 years ago

For anyone else who might come across this, I suspect that at least I ran into this issue because I created my query in a newer version of Power Query (Excel M365) and tried to run it in an older version of Power Query (Excel 2016). There was also at least one other function I had to remove parameters from, including Promote Headers.