cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SANGST
Helper I
Helper I

Append new table row and graph point after each schedule refresh

Similar questions have been raised in the past, but i couldn't find a satisfactory answer -
 
I have a report with a scheduled refresh every 24 hours, currently that overwrites the previous table data each time to give the latest view, so it's impossible to track trends in the data over time.
 
I'm trying to find a way for each refresh to append a new row to the bottom of the table and add a new data point to a graph so i can build out the dataset overtime tracking trends automatically. This will need to contine ad finitum similar to the below:
 
 
Movement over time.JPG
1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @SANGST ,

 

You could consider using incremental refresh.

Or, you could refer to this post:  Storing and using information from a dynamic data source using PBI desktop.

 

 

Best Regards,

Icey

 

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

6 REPLIES 6
Icey
Community Support
Community Support

Hi @SANGST ,

 

You could consider using incremental refresh.

Or, you could refer to this post:  Storing and using information from a dynamic data source using PBI desktop.

 

 

Best Regards,

Icey

 

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

Thanks Icey - the "Storing and using information from a dynamic data source using PBI desktop" is exactly what i'm looking for. I will accept as the solution.

Hopefully this is something microsoft can look to implement natively in powerbi in future, without the need for complex workarounds given then obvious demand within the community?

 

amitchandak
Super User IV
Super User IV

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi Amitchandak, my powerbi dataset comes from a SQL query. When i refresh my dataset from with PowerBi, it replaces the existing data. The table will have one row which is the results from the latest query. When i refresh the report, it overwrites to the data, so i have the latest data, but still only one row.

 

My intention is instead, for the updated results to append to the table below the results from the previous query. I hope that's clearer

Pragati11
Super User III
Super User III

Hi @SANGST ,

 

How you are getting this data in power BI? Is it importing through an excel or some live connection?

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




The data is from a SQL query. Each powerbi refresh the SQL query executes again, then the latest live data is imported to powerbi. It then replaces the previous results. The aim is to have it append to the bottom of the previous results, if possible instead

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors