The Csv.Document parameter 'Columns' is invalid.

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