cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atisenbe Frequent Visitor
Frequent 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

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Refreshing Certain Data Sets

@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
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Refreshing Certain Data Sets

@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

atisenbe Frequent Visitor
Frequent Visitor

Re: Refreshing Certain Data Sets

Thanks

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors