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

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.

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