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 files are static and do NOT need to be refreshed with the rest of my report. I have unchecked this option in the query options...
I have successfully setup my gateway and have no problem scheduling refreshes on reports without these excel files, but when I try to schedule my refreshes on these reports, I get this error....
Not sure what to do since I already unchecked the box to not include these in my refreshes. Also don't want to remake my date tables in PBI since I have many reports that would need changing. The area to edit my data source credentials on the browser is also greyed out.
16 Replies
Looks like you need to upgrade your gateway? From what I am seeing, it looks like your gateway isn't online.
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.
