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
atisenbe
Regular Visitor

Refreshing Certain Data Sets

I have about 25 excel spread sheets at about 1.2 MB each loaded into my power bi file. A new one is created just about every week. The tables in excel have different values every 15 seconds for about 3 days (10 to 20,000 rows). Each of these spread sheets are appended to one query in order to compare batches on the same line graph. Everytime I refresh my data sets it takes 30-45 minutes. Generally when I refresh I only change or add a few things to 1 of these 25 spread sheets and the rest stay constant.  Is there any way to refresh certain datasets? 

Or is the only fix to reduce the amount of rows in each of these tables in the excel tables before adding them to power bi?

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@atisenbe,

Based on your description, you refresh the data in Power BI Desktop, right? If so, set the tables that contain old data not to be included in refresh, use UNOIN function in DAX instead of “Append Queries” option to combine data in tables, this way, the refresh time will be reduced. For more details, please review this blog: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ .

However, in Power BI Service, the refresh is a full refresh and not incremental, it is not possible to refresh specific tables in a single dataset. To reduce refresh time in Power BI Service, import required columns and rows to Power BI and optimize data model.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@atisenbe,

Based on your description, you refresh the data in Power BI Desktop, right? If so, set the tables that contain old data not to be included in refresh, use UNOIN function in DAX instead of “Append Queries” option to combine data in tables, this way, the refresh time will be reduced. For more details, please review this blog: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ .

However, in Power BI Service, the refresh is a full refresh and not incremental, it is not possible to refresh specific tables in a single dataset. To reduce refresh time in Power BI Service, import required columns and rows to Power BI and optimize data model.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks

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