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. 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

A little late to the party here, but how did you change the query to handle the files in the designated folder as text files? I'm not seeing how to do that.

 

I've been stuck on this one for a while, so I'm hoping you can help me out...

 

Thanks!