Forum Discussion

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled 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

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

Caitlin_Knox

 

In your line of code:

 

#"Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter="#(tab)", Columns=10 , Encoding=1200, QuoteStyle=QuoteStyle.None]),

 

The items to delete are Columns=10 and QuoteStyle=QuoteStyle.None

 

The text below is what mine looks like and it appears as though you need to also delete "#(tab) and insert a " where the columns was.

 

Try and insert the text below to see if that works.

 

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

 

Thanks

 

Giles

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
10 years ago

When I applied those changes in the Advanced Editor I get a new error

'Expression.Error: The column 'User(Login Name' of the table wasn't found.'

 

This is a column that was removed when I was 'grooming' the data after the binaries were combined. I have opened a ticket with Microsoft, but they don't really know what is going on either.