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
aashton
Helper V
Helper V

Track Data Changes

Hello,

My PowerBI report is pulling from a database that has a table with two numerical values, # of Docs and # of Nurses.  This value is updated from a front-end software, it would just be overwritten when updated.  I need to track when either of these numbers changes drastically.  If my powerBI report refreshes every day, is there any kind of tool in PowerBI I could use to keep prior days values, or even weekly or monthly, so I can be alerted when these numbers change?

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @aashton 

 

Power BI is not able to store previous data or historical data for you. When Power BI refreshes data, it imports all existing data from data sources into your model again. Since the data in your database is overwritten when updated, historical data is removed so Power BI couldn't get them. 

 

I recommend that you store historical data in your database. Instead of overwrite a table, you can append new rows to an existing table in your database. Or if you don't want to modify the current table, you can create a new table which appends new data from the updated table every time.

 

You can then connect your Power BI report to this new table to get both historical data and updated data. Build some measures and use some visuals to get the number change difference. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

ALLUREAN
Solution Sage
Solution Sage

Hi, @aashton 

Maybe you can check this:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

This is valid only if you have a dashboard

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




ALLUREAN
Solution Sage
Solution Sage

Hi, @aashton 

Maybe you can check this:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




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.