Forum Discussion
Setting up on-premisis gateway
I ended up re-creating the report after the gatewaye was created and published...then it connected. I still don't understand but it is working now. Thanks everyone
I experience the same issue. The Data Gateway has been configured and is connecting okay. Verified ports in the firewall, that is okay. The Gateway option is grey, and I'm told to install the personal gateway when trying to schedule the connection. The reports are done by Import, as there are alot of formating in Power BI Desktop before the end result is presentable. Would this cause any limitations to the use of an Data Gateway?
We have two types of datasources that we need to access from on-premise, MSSQL and Excel (xlsx) files.
If I understand it correctly the only thing that needs to match are;
- For the SQL the database and server needs to match (Case-sensitive?)
- For the Excel files the path including filename must match.
For Excel we use unc-path on both Desktop data source and in Power BI data source \\servername\folder\folder2\filename.xlsx Should this work?
This would mean that the Data source name in Power BI Web could be anything? Am I correct?
So one Excel data source can be named Company, another Income, another Exprenditure etc?