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
MattAllington's avatar
MattAllington
Community Champion
8 years ago

There is 1 gateway, but multiple configurations.  Each file needs its own configuration.  My guess is that these files are not configured in your gateway.

khappersett's avatar
khappersett
Resolver I
8 years ago

Hm not sure I know what you mean. I can take literally the exact same PBI file and remove just the excel portions and it works on my gateway just fine, so it is definitely the Excel files causing the problem. Why would I need to configure these parts if I don't want them to refresh?

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