Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tim_goodsell
Regular Visitor

Prevent part of dataset refreshing during scheduled refresh

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

3 REPLIES 3
josef78
Memorable Member
Memorable Member

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
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors