Forum Discussion

jonnychenoweth's avatar
jonnychenoweth
Regular Visitor
4 years ago
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...
Dataflow
General Comment
Need Help
  • jonnychenoweth's avatar
    jonnychenoweth
    4 years ago

    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.

jonnychenoweth's avatar
jonnychenoweth
Regular Visitor
4 years ago

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's avatar
Jeanxyz
Power Participant
4 years ago

I 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. 

  • jonnychenoweth's avatar
    jonnychenoweth
    Regular Visitor
    4 years ago

    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.