Forum Discussion
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...
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?
I already have my gateway setup and everything works fine when I don't have the excel files in the report.
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.
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?
