Forum Discussion
Dinamyc parameter send to filter data
Hi mcantos ,
Thanks for your clarification! You're absolutely right since Power BI doesn’t provide the report execution timestamp dynamically, the best workaround is to simulate that run date using a table like LastRefreshTable.
I created a column in my main table that compares the ModifiedDate (like your lastUpdateDate) with the latest run date from LastRefreshTable. Based on this, I calculated a "Status" column that flags whether the data is "New" (updated after the last run) or "Old".
I tested this setup, and the results correctly reflect what you described: records updated after the last simulated run date show as "New", and others as "Old".
This solution works perfectly for the need you explained. Let me know if you want to automate the refresh date or integrate this with Power Automate too.
Please find the attached pbix file for your reference.
If the response has addressed your query, please "Accept it as a solution" and give a 'Kudos' so other members can easily find it.
Hey v-tejrama , thank you for your reply and following up.
I think I didn't explain myself correctly. I don't need the latest date from the data refresh. I need to save the date when the report runs in the Power BI service to use that date to compare it in the next run.
I have a lastUpdateDate field in my tables that I wanted to compare with the latest run date.
For instance, if the user runs (executes) the report today, the latestRunDate is 06/23/25, and if I run it again next Monday, the data to be displayed would be those where the latestRunDate > lastUpdateDate.
I don't even know if that makes sense. So I think I'll work with some variables to try to mimic the behavior
Thank you again!
Hi mcantos ,
Thanks for your clarification! You're absolutely right since Power BI doesn’t provide the report execution timestamp dynamically, the best workaround is to simulate that run date using a table like LastRefreshTable.
I created a column in my main table that compares the ModifiedDate (like your lastUpdateDate) with the latest run date from LastRefreshTable. Based on this, I calculated a "Status" column that flags whether the data is "New" (updated after the last run) or "Old".
I tested this setup, and the results correctly reflect what you described: records updated after the last simulated run date show as "New", and others as "Old".
This solution works perfectly for the need you explained. Let me know if you want to automate the refresh date or integrate this with Power Automate too.
Please find the attached pbix file for your reference.
If the response has addressed your query, please "Accept it as a solution" and give a 'Kudos' so other members can easily find it.
Thank you so much for this!