Forum Discussion

arthurnotaro's avatar
arthurnotaro
Frequent Visitor
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I notice in your Data Source screenshot for your file you have exactly 6 data sources.  Have you included all 6 in your data gateway either by directly linking them individually, or linking the gateway to the folder.

 

The reason i ask is that if you wish to use a data gateway, it must connect to either 0% or 100% of your data sources, nothing inbetween.

arthurnotaro's avatar
arthurnotaro
Frequent Visitor
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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"