Forum Discussion
Auto-refresh with Static Excel Files
I would set up the personal gateway so that the Power BI Service can load them the first time. Verify that it works then test without the gateway.
Anonymous
It works when I setup the personal gateway, but now the option to switch to the gateway I want to use is greyed out. We have our gateway installed on a virtual machine in IT so the "computer" is always turned on and able to be accessed for the refreshes. I do not want to use a personal gateway setup on my computer.
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.
Not sure, but usually that means that your data sources in your PBI file dont match your data sources in the configuration for the On Premise Gateway. In order to schedule a refresh from the PBI Service, it has to know how to get to your data files.
Anonymous
I'm not sure how to configure these excel files with the on premise gateway. I don't see a way to do this anywhere.
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.
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.