Forum Discussion

khappersett's avatar
khappersett
Resolver I
8 years ago

Auto-refresh with Static Excel Files

I am trying to setup auto-refresh on my reports, but seem to have problems with the reports including excel files. I created my date tables in Excel and brought those into my PBI reports. These Excel...
Need Help
khappersett's avatar
khappersett
Resolver I
8 years ago

I still have not found a solution to this problem. I had to take all my excel files out of the reports to get the refreshes through the browser to work. This can't possibly be the only solution as I have other reports that still have excel files that need to be auto-refreshed...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Where are your Excel files being stored?  Is that data source included in your gateway configuration?

  • khappersett's avatar
    khappersett
    Resolver I
    8 years ago

    Anonymous

     

    They are stored locally on my computer. I do NOT need these files to be refreshed, as they are static. I do not have any gateways setup for the excel files. If I try to "Add Data Source" under manage gateways, I do not see an option for an excel file. If I choose "file", it asks for windows credentials and my login info is not working.

    • khappersett's avatar
      khappersett
      Resolver I
      8 years ago

      Do I need to setup a Personal Gateway? I am hoping this is not the case because I want the reports to refresh even when my computer is not turned on.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I would set up the personal gateway so that the Power BI Service can load them the first time.  Verify that it works then test without the gateway.