Forum Discussion
Exclude from refresh certain queries from Excel files
I have report with a lot of queries from a sql server - and some queries from Excel files. I have just installed a gateway to get the data from sql served to be updated, but it is not necessary to refresh the data from the Excel files (static data) . Is it possible to configurate the schedule updates to only refresh the sql data?
It's the Enable Load option, disable that.
8 Replies
In Query Editor, right click your query and set it to not refresh.
Hi thanks - do you mean not select "Include in report refresh"?
I have tried that, but still it seems that the Excel file (Dato_Tabell.xlsx) will be refresh. In any case, I am asked to add my credentials when I tried to set up a schedule plan.
It's the Enable Load option, disable that.
Hi again, I am struggling to find a solution to my problem - and hope you (or someone) have another tip :-)
I have a report with data from a Sql server and some additional static information in Excel files. I tried to set up a schedule refresh plan for the data set, but it seems hat it is not possible to combine on-premises data (Sql) with data in Excel files. If it had been possible to exclude the Excel files from the refresh plan, my problem had been solved. I tried to untagged "Include in report refresh", but it does not help. To your information I am using a data gateway.
Thanks in advance!
Fia123 wrote:
Hi again, I am struggling to find a solution to my problem - and hope you (or someone) have another tip :-)
I have a report with data from a Sql server and some additional static information in Excel files. I tried to set up a schedule refresh plan for the data set, but it seems hat it is not possible to combine on-premises data (Sql) with data in Excel files. If it had been possible to exclude the Excel files from the refresh plan, my problem had been solved. I tried to untagged "Include in report refresh", but it does not help. To your information I am using a data gateway.
Thanks in advance!
The option "Include in report refresh" only works in Power BI desktop.
Power BI gateway(personal mode in your case) definitely support such combined data sources. You can click "edit credential" and ensure that when using a absolute path(c:\\xxxx\xxxx\xxxx.xlsx), ensure that the gateway is on the same server, otherwise you can encounter error as below.
