Forum Discussion

joerykeizer's avatar
joerykeizer
Icon for Helper II rankHelper II
10 years ago
Solved

Enterprise gateway & scheduled refresh

Hi guys,   I had the enterprise gateway setup and it was working well. Yesterday I republished a pbix file because I added an Excel source (also to the gateway configuration of course) and now I c...
Need Help
  • joerykeizer's avatar
    joerykeizer
    10 years ago

    Fixed it.

     

    When setting up the gateway; the file path for the Excel needs to start with a "server prefix". When I imported the new file into PowerBI desktop the location just started with S:\. It didn't match the path I set up in the gateway even though it was the same file. 

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

joerykeizer How have you connected to your excel file in the problem report? If it was using DirectQuery from power bi desktop then enterprise gateway don't support that. If you have done import and are doing schedule / manual refresh there shouldn't be an issue.

  • joerykeizer's avatar
    joerykeizer
    Icon for Helper II rankHelper II
    10 years ago

    Thank you for your reply. I have just done 'import' so I agree, there shouldn't be an issue. I'll try reinstalling the gateway because this just doesn't make any sense.

    • joerykeizer's avatar
      joerykeizer
      Icon for Helper II rankHelper II
      10 years ago

      Fixed it.

       

      When setting up the gateway; the file path for the Excel needs to start with a "server prefix". When I imported the new file into PowerBI desktop the location just started with S:\. It didn't match the path I set up in the gateway even though it was the same file. 

      • nathanh's avatar
        nathanh
        Regular Visitor
        9 years ago

        joerykeizer I'm having the same problem with an excel file. I have set the path on my local machine and on the gatway server to be the same i.e. C:\Folder\File.xlsx but after I publish to Power BI web I can't run a refresh from that gateway. What is a server prefix and how did you use it to solve your problem? I'd really appreciate your help!