Forum Discussion
Auto-refresh with Static Excel Files
If you are going to use the on-premise gateway, the files need to be on a share that is accessible to the on-prem gateway.
On the gateway, you need to add a datasource point to that share where the files are. When you build it in PBD desktop, you have to use the EXACT share location that you have configured in the On-Prem gateway. They both have to point to the same UNC because that is how the Power BI Service knows that it can access the files there.
To add the datasource, you need be an an admin in the On-Prem gateway. Once you are an admin, go into Manage Gateways in the service and add your datasources that point to the files.
Anonymous
Thanks! I believe this is the answer I am looking for. I was hoping there was a way where I would not have to configure the excel files because I am NOT trying to refresh them. I only need to refresh the SQL queries within the same report. It seems as though this is not that case and I have to configure the excel files too even though I don't want them to be refreshed.
AFAIK If they show up as data sources in your PBIX file then the Power BI Service will need to know how to access them.