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
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
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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)