How to refresh only certain tables in power bi service ?

[Kevin_Conseil]

Hi everyone,

I have a big power BI files with some tables that query:

- complex/heavy views in azure sql database (cost for each refresh)

- dynamic tables from Business Central (no cost associated when refreshing)

- static tables without any cost when refreshing as well

Here I d like to implement the increment refresh on my "view tables" in order to make it cheaper and more performant when refreshing them.

However I do changes quite often on the BC and static tables. Therefore i d like to know if we can remove some tables when using the "refresh now" button in power BI services. 

If not I would also be happy to hear about expert experiences on how to deal with such situation

Thanks,

Kevin

[Greg_Deckler]

@Kevin_Conseil - In Power Query Editor, you can right click a table and disable refresh.

[avatorl]

@Kevin_Conseil 

option 1: incremental refresh https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

option 2: create multiple dataflows  https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use#:~:text=A%20d...
(e.g. one connected to azure sql database, and one connected to all other data source) with different refreshing schedules
then connect you dataset to these dataflows (instead of connecting it directly to the data sources)
Dataset refreshing won't trigger data flows refreshing: https://www.youtube.com/watch?v=xA6YouSI6kY

So, you can refresh for example:
data flow 1 - each Monday 1am (this will grab data from azure sql database)
data flow 2 - daily 2 am (this will grab data from other sources)
report data set - daily 4 am