Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.