Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
presto
Frequent Visitor

Enterprise gateway file data source

Hi

 

I have installed the Enterprise Gateway and successfully created a "File" data source to connect to an on-premise file.  Unfortunately, when I publish a PBIX file that sources data from the on-premise file I am unable to configure it to perform a refresh via the Enterprise Gateway (the choice is greyed out).

 

I am using the same path and file name in the PBIX file that I used in the Enterprise Gateway data source.   I have also ensured that the the Power BI account to which the PBIX file was published has access to the Enterprise Gateway data source.   Can someone please advise what else I may need to do to get this working?

 

Note, I have been able to get the Enterpise Gateway working properly with a "Web" data source that points to an on-premise URL.  I just don't seem to be able to get it working with "File" or "Folder" data sources

 

Any help is much appreciated.

 

Thanks

 

 

1 ACCEPTED SOLUTION
presto
Frequent Visitor

I recreated the PBIX file and this fixed the problem.   The queries and file paths within the PBIX file were exactly the same as before but when I published the new PBIX file to Power BI Server I was able to connect it to the Enterprise Gateway.   Not sure why that worked but happy it's fixed Smiley Happy

 

As an aside, I was also able use a UNC path to connect to the file on a file server.  I had read previously that the gateway did not support this so I was pleasantly surprised to see this functionality was now available.

 

View solution in original post

1 REPLY 1
presto
Frequent Visitor

I recreated the PBIX file and this fixed the problem.   The queries and file paths within the PBIX file were exactly the same as before but when I published the new PBIX file to Power BI Server I was able to connect it to the Enterprise Gateway.   Not sure why that worked but happy it's fixed Smiley Happy

 

As an aside, I was also able use a UNC path to connect to the file on a file server.  I had read previously that the gateway did not support this so I was pleasantly surprised to see this functionality was now available.

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.