Forum Discussion
Solved
Automatic refresh not updating
I am using excel and sql for my power bi report. I Added all local path to the gateway for the individual EXCEL FILES i.e company name, employee, etc. That change or i am adding content/data once a we...
- Hi there
What you would need to do, is to have a UNC File share (EG:\\myservername\sharename) to where the files are stored.
Make sure that your Gateway server can access this UNC File Share.
Configure your Power BI Desktop to also connect via the same UNC.
Once the above is done, you should then be able to configure the Data Gateway with this new data source.
Then finally go into the dataset properties and set the Gateway to use the Gateway Server and it should then refresh.
Hi there
What you would need to do, is to have a UNC File share (EG:\\myservername\sharename) to where the files are stored.
Make sure that your Gateway server can access this UNC File Share.
Configure your Power BI Desktop to also connect via the same UNC.
Once the above is done, you should then be able to configure the Data Gateway with this new data source.
Then finally go into the dataset properties and set the Gateway to use the Gateway Server and it should then refresh.
What you would need to do, is to have a UNC File share (EG:\\myservername\sharename) to where the files are stored.
Make sure that your Gateway server can access this UNC File Share.
Configure your Power BI Desktop to also connect via the same UNC.
Once the above is done, you should then be able to configure the Data Gateway with this new data source.
Then finally go into the dataset properties and set the Gateway to use the Gateway Server and it should then refresh.