Forum Discussion
enterprise gateway refresh error
Hello - Trying to set up an enterprise gateway to connect to a server hosted folder of .csv files. With the new enterprise gateway, it isn't clear how to set up that connectionm. What I found to...
Hello -
I was tinkering around and remembered that Power BI sometimes has problems with .csv files. The formatting gets all messed up and it works better designating your .csv file as a text file and letting the query dilimit the columns at each occurence of the comma.
I changed the query to handle the files in the designated folder as text files and the error dropped. Data is successfully refreshing with manual triggers. Have a scheduled trigger in 5 minutes to see if that works, can't see why it wouldn't.
thanks for reading.
Switching to .xlsx did work. Switching to .txt didn't work.
I had this same issue, not sure cause or why or if its a bug..i got it working as per this thread (hopefully the fix keeps working)
