cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Detecting data changes

Hello 

 

We are currently new to Power BI in our organization and we are shiffting the existing reports in our system to Power BI using App Owns Data approche.

 

I faced an situtation that is a little complicated for my current level in BI, I searched in many places but couldn't find the right answer.

 

We have a table in the database for the inventory, the table has around 2M record and I want to refresh the data on daily basis, the problem I face is that fetching about 700MB of data everyday looks unsuitable especially that the data is increasing very quickly, I wanted to have a historical table in Power BI that contains all the data to date and another one that contains the daily data and using append quries to have them, but I there any way to detect the old changes for the historical table for example an Item in the stock has been deleted or updated is there any mechanism in the Power BI so it updates the records in the historical table or I have to fetch refresh the full table when any change happens in the old data.

 

Thank you in advance

1 REPLY 1

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors