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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pkoel-asb
Helper V
Helper V

Data refresh how to exclude a table with static data

Hello All,

 

  I have a report that will display tranactional date from 2019 to current. All of this data is in a table called ShoppingCart. The historical data from 2019 to 2021 will never change.  Currently, when I run my report refresh, it appears to pull all of the daa from the table; during each refresh. So when I refresh the data four times a day, it pulls in all the data from ShoppingCart back to 2019.  I want to improve my report performance by pulling in the data from 2019 to 2021 once, and then have it refresh the data from 2022. How do I accomplish this goal? Is there a way to pull in just the changed records?

 

Cheers,

 

Peter

1 ACCEPTED SOLUTION

Hi @pkoel-asb ,

 

vchenwuzmsft_0-1656578012498.png

In power query editor, you need have two queries to the specifical table.

1 Uncheck the include in report refresh and Enable load of the first part.

2 Append the first part to the second part.

 

So, the table will only refresh the second part in power bi model.

vchenwuzmsft_0-1656578442700.png

Best Regards

Community Support Team _ chenwu zhu

 

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

3 REPLIES 3
speedramps
Super User
Super User

Create 2 tables

 

Static =  ( date <= 31Dec2021)  with refresh turned off 

 

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !

 

YTD = ( date >= 01Jan2022) with refresh turned on

 

The append the tables in Power Query 

Hello,

 

   Thank you for your reply. Regarding the statement below:

Static =  ( date <= 31Dec2021)  with refresh turned off

 

1. Is this a Dax or Power Query command?

2. How do I appy it to a table?

3. "with refresh turned off" - How do I turn refresh off for a single table?

 

Thanks!

 

Peter

Hi @pkoel-asb ,

 

vchenwuzmsft_0-1656578012498.png

In power query editor, you need have two queries to the specifical table.

1 Uncheck the include in report refresh and Enable load of the first part.

2 Append the first part to the second part.

 

So, the table will only refresh the second part in power bi model.

vchenwuzmsft_0-1656578442700.png

Best Regards

Community Support Team _ chenwu zhu

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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