Using gateways

[linda2001]

Hello - I am publishing Power BI reports to our SharePoint Online site. I have an on premise gateway set up that connects to my SQL server and it's working fine. However, I also need to publish some reports that are retrieving data from Excel files stored on a local file server. How do I do that? I tried setting up another gateway, but I can't get it ot work. I'd like to combine some of the data from the sql server files and the excel files into a dashboard. Thanks!

[Anonymous · Accepted solution]

You should only need 1 gateway.  The gateway is just a trusted computer/server that sits inside your network and acts as a bridge between your network and the office 365 cloud.

Your excel files should be placed on a shared network folder that the gateway computer/server has access to.  In your "Manage Gateways" make sure you have an entry for the network folder.  In your Power BI project, make sure you access any files on that network folder using the same network address that the gateway will also use.