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

Well it seems the report wants the gateway needs to be set up regardless. So why don't you try that. If it solves the problem the. All good, right?

khappersett's avatar
khappersett
Resolver I
8 years ago

I already have my gateway setup and everything works fine when I don't have the excel files in the report.

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