Forum Discussion
Can't refresh data. Error message "The Csv.Document parameter 'Columns' is invalid."
Fixed it.
This may not be the solution for everyone with this error message, but what worked for me was upgading to the Power BI Entrerprise Gateway and configuring the data refresh through that.
I had eliminated all other potential causes, so deleting the Personal Gateway and installing/configuring Enterprise was my last troubleshoot.
Fixed it.
This may not be the solution for everyone with this error message, but what worked for me was upgading to the Power BI Entrerprise Gateway and configuring the data refresh through that.
I had eliminated all other potential causes, so deleting the Personal Gateway and installing/configuring Enterprise was my last troubleshoot.
I also had this issue come up on a new report pulling multiple csvs..it worked for the first couple refreshes then popped this error....(other reports work fine)....I am using personal gateway...what I did was in query editor.....under applied steps....go to source and click the gear icon to the right....then "Open File as" select "text file"...hit ok....you will get errors cause you just messed up all your steps.....but not to worry....click "Split Column" in the ribbon above...and delimit by comma...insert this step...and you should be good to go...
Why this worked I have no idea...but it fixed my issue...i also deleted the dataset from the cloud and re uploaded once i finished doing the above in desktop. So far it is working again