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.
Hi mcantos
Power BI does not store a historical copy of the data. What gets loaded into the model upon refresh is based on the latest available data. That is true even if you don't enable the load for a query. The historical data, thus, must exist somewhere. You can run a query against a dataset using Power Automate that generates a summary of the data or whatever kpis you want to track and automatically save that as a csv file in sharepoint folder and then use that folder as a data source. Please refer to this https://www.matthewdevaney.com/power-automate-run-a-query-against-a-power-bi-dataset/