Prevent part of dataset refreshing during scheduled refresh

[tim_goodsell]

Hi

I am uploading data from a number of excel files into the dataset but alot of the data is static and does not need to be refreshed once it has been uploaded.

When i schedule a data refresh (import) in the report server can i switch off which data sources i don't need anymore, the schedule refresh seems all or nothing 

Tim

[josef78]

In PBI RS you cannot selective refresh tables.

But in design time in power bi desktop you can turn off refresh on selected tables (uncheck Include in report refresh), and this setting should be reflected on report server during scheduled refresh.

But be sure, this source must not be referenced in any other table in power query. If you use this table as reference (e.g. in merge) in power query, this table will be refreshed, independent on this settings (this mean, it is unusable for some increment load workaround if merging old and new data. If you need increment load, you need Power BI Premium in cloud, or SSAS Tabular in on-prem)

[v-xiaoyan-msft]

Hi @tim_goodsell ,

Would you like to try using incremental refreshes?But it needs to be operated on Power BI Desktop and Power BI Service. As d_gosbell  mentioned, Report Server does not support partial refresh

It's quicker to refresh, just refresh the most recently changed data.

When published to the service, with the first refresh operation, the service creates incremental refreshes and historical partitions based on the incremental refresh policy settings, then overrides the parameter values to filter and query the data for each partition based on the date/time value of each row.

In each subsequent refresh, the query will filter and return only those rows within the refresh period dynamically defined by the parameters. Refreshes are those rows whose date/time is within the refresh cycle. Rows whose dates/times are no longer within the refresh cycle will become part of the history cycle and will not be refreshed.

Incremental refresh is best suited for structured relational data sources, which in any case must support the following.

1.Date column - the table must contain a date/time or integer data type date column
2.Query Folding - Incremental refresh is available for data sources that support "query folding", which is the ability in Power Query to generate a single query expression to retrieve and transform source data.
3. Additional custom query functions and query logic can be used for other types of data sources
Use incremental refreshes, provided that RangeStart and RangeEnd based filters can be passed in a single query. For example, an Excel workbook file saved in a folder, a file in SharePoint, or an RSS feed.
4.You need to have the appropriate license. Power BI Premium, Premium Per User, Power BI Pro and Power BI Embedded datasets all support incremental refresh.

For more information，you can refer to Incremental refresh and real-time data for datasets 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[d_gosbell]

No you can't Report Server only does a full refresh of all data sources.