Forum Discussion
ERROR: Invalid connection references when adding a local excel file to on-premise gateway
Hey, I created a report using a SQL-db and a local excel file. When published, I wanted to schedule daily refreshes and found that I needed to install an on-premise gateway. I chose not to instal...
AntonV - Please use the UNC / Netwrok path. Do not use 'C' drive etc. You need to use the UNC / Netwrok path of the folder ('E' will be something like '\\server2\Corporate\'). Go to ''This PC' > on the 'E' drive right-click > go to DFS tab. There you will find the UNC path.
Change the Data Source path in Power BI desktop and re-publish to Power BI Service. And, now you can set up the gateway.
Hope this helps !