Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I`ve got a big table with no date column in it, refreshing every day, but the new row or two is added only once or twice a week.
I would like to get the dates of new entries, but do not want to meddle with incremental refresh.
Any ideas?
Thanks in advance
@victoriavd , You need to have some kind key to do that, this talks about date key, but should work with other key column
Or refer
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
@victoriavd if your source doesn't have a date stamp and you are doing the import, no way you can tag the new records with the date, because every time you refresh, it pulls the whole dataset. Not sure what you are trying to achieve with this date, there might be other solutions to handle the problem if you provide some more context on what you are trying to achieve.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks ,
Yes, it seems like you are right, as it imports the whole dataset each time - no chance to track changes....
But that is exactly what I want....
My table has the following structure:
product_ID | Rate |
21212121 | 100 |
What I would like PBI to do is in some way to compare the old table (before todays refresh) and the new one and in case the new one has more rows - create a column named date putting today`s date into it. Then I would get the date into the report, so that the user could see the last date on which refreshing has resulted into an additional new row.
I actually do not see a way to do it in PBI…..
I thought of processing the datasource through SQL database, writing a procedure which will perform the daily refresh of the table in question in 3 steps:
Combined with a job to execute it daily that might get me what I want, but it will take some server capacities and it seems to be quite a tricky workaround. I just thought somebody, might have had a similar issue already and has figured out a more elegant solution….
@victoriavd yes in this case you have to have to heavy lifting done at the backend, PBI is not going that for you, if you have some audit log, can be used but seems like that is not the case All it points to do the work in backend and just visualize in Power BI. I know it is not the answer you expected but that's what it is.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |