Forum Discussion
Solved
Refreshing PowerBi Online using Personal Gateway Issue
All, This is a very odd issue and I assume that I am doing something super simple wrong. I have both Desktop PowerBi and PowerBi online (service). I have a dataset that is comprised of two XSLX ex...
Yes for whatever reason, when I recreated it again and left the excel files as stand alones and just had it set to auto refresh on open. I then used a batch file to open them every hour while using the data gateway personal and it worked. Just had to delete and recreate it all.
Jeanxyz
Power Participant
Power ParticipantI notice your gateway is empty, those csv data source are not appearing in your gate. Based on your solution, I guess the csv files are saved in your local drive? You only need to add files to gateway if the files are saved on SharePoint or One Drive.
They are saved in one drive. It is working now, just had to recreate it. Still don't know why it converted my local files/one drive xls to the Jira on prem URL/web but it only happened once. It has since been working.