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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.