Forum Discussion
Helper IIEnterprise 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 can't select the enterprise gateway on the scheduled refresh page.
To investigate the problem I also created two test files, one with 1 excel file and another with data from an sql source. The gateway can be selected on the sql source but not the excel source. The weird thing is that I have another older dataset, very similar to the one I'm now having problems with, which includes the same excel from the testfile, where I can still select the enterprise gateway.
Any ideas on what is causing this problem?
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.
5 Replies
- ankitpatira
Community Champion
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.
joerykeizerThank 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
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.
