Scheduled refresh - excluding some tables on SQL

Question

Hello guys,&nbsp;I am building a dashboard right now and have some data sources on a SQL server. One table contains more than 6 million rows, so I thought that I split this table in two different tables for a faster updating in the night.&nbsp;&nbsp;I have the data from 2013 till 2018 which I want to load one time in Desktop. This table shouldn´t be updated in Service then anymore.The second table contains the YTD sales data, which should be updated every night.&nbsp;&nbsp;So in Desktop&nbsp;I saw the function "Include in report refresh" which I want to disable for the first table. Is that possible to do that in Power BI Service as well?&nbsp;&nbsp;Thanks and greetings,Christopher

adambhappy · Answer

I haven't seen anything on the roadmap but if you feel it's a necessary feature, go vote for the idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20579641-exclude-a-table-from-refresh-in-power-bi-service

adambhappy · Answer

Hi Christopher,I would suggest you take a look at the incremental refresh capabilities of Power BI as to my knowledge the "Include in report refresh" only applies to Power BI desktop.&nbsp;https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

anonymous · Answer

Are they going to get the power bi web service to acknowledge the desktop request to not refresh in future. It’s a good feature in the desktop but means I can’t use the web scheduler. You should be able to separately schedule each data source :)

Forum Discussion

Scheduled refresh - excluding some tables on SQL

3 Replies

Related content

Schedule refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Scheduled Refresh Failure

PBI Report Server Schedule refresh