I am trying to refresh data through a power bi enterprise gateway that is shared by several users.
My Home Office: Windows 10 machine with connectivity to 4 different MySQL databases and one SQL database. The different databases reside at various company locations in the U.S.
Power BI Gateway - Enterprise gateway is setup and functioning properly through my Power BI web App. I am using it to perform scheduled refreshes on the datasets that I published from my Windows 10 Machine through the Power BI Desktop and it is using my same Windows 10 machine as the Gateway.
2nd User: Located at his home office - Power BI Desktop App and Web App. Basically the same SQL and MySQL connections as data sources - He also has some Excel files that he is using as datasource for a few of his Power BI desktop apps.
I have given the second user access and administrator rights to the Power BI Gateway I originally created. When he publishes his Desktop data to the Web app, which includes data sources from the same MySQL and SQL databases that I use, plus a few additional excel files that are resident on his local machine. He gets a failure when trying to connect to the Gateway.
The failure is definitely showing up for the files that are local to his machine. How do I map them and add them to the gateway? I assume I need to use a UNC path but I am not sure what that path would look like. So, I need help with that.
Then, once I am able to get the gateway configured for his files, would the MySQL and SQL databases that he is using (that are the exact same locations that I am using - currently successfully for my data through the Gateway) - will they automatically map? All of the naming and credentials are the same as what I am using.
Are there some videos that might cover this?