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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi jonnychenoweth ,

 

Has the issue been solved? If not, can you share the detailed error message?

 

Best Regards,

Jay

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.