cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bkoenen
Regular Visitor

Power BI Desktop, import data from SQL Database and build a history

Hello,

 

I have a connection from Power BI Desktop to an SQL database. I only import one table, this table has only one row with columns: Number, date/time, user.

 

Sometimes a user changes the Number via a module in an ERP program.

The row in the Database table will be overwritten with a new Number, date/time and user.

 

In Power BI, the row will also be overwritten, bud I want to build a history in Power BI, so that it will create a new row every time I do a refresh and a value has changed. I want this history so I can see what date which user has changed the value.

 

Is this possible in Power BI Desktop?

 

 

Kind regards,

Björn

1 ACCEPTED SOLUTION
edhans
Super User III
Super User III

No. Power BI is a read only tool, it cannot change data in the source nor add an archive. Each refresh is a "wipe everything and reload from the source."

To create an archive of what was done, you would need to either use a Stored Procedure to append data to a history table you create when that table changes, or use Power Automate to do this via a flow. It can detect when records change and add data to a new SQL table or an Excel spreadsheet if that is easier.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
edhans
Super User III
Super User III

No. Power BI is a read only tool, it cannot change data in the source nor add an archive. Each refresh is a "wipe everything and reload from the source."

To create an archive of what was done, you would need to either use a Stored Procedure to append data to a history table you create when that table changes, or use Power Automate to do this via a flow. It can detect when records change and add data to a new SQL table or an Excel spreadsheet if that is easier.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

bkoenen
Regular Visitor

Thank you Ed Hans,

 

I will study the Power Automate and Flow possibilities to create a new table or spreadsheet.

 

Kind Regards,

 

Björn

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 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