Forum Discussion
On Premise Data Gateway Excel and Web Files
I installed the on premise data gateway and the connection is running just fine. I also added data sources (local excel files and web), and it tells me "Connection successful". When I go to "sche...
All 6 data sources were included in the gateway.
The only data sources that were not included in the data gateway were the tables created directly on Power BI Desktop (Enter Data - Create Table).
It should be able to work fine then. My advice is to check all six and make sure every single file path is identical. A common mistake will be to have linked to your file through your desktop via a mapped drive like "H:\Folder\File.xlsx" but have it on a shared server that the gateway sees as "\\ServerName\Folder\File.xlsx"