Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My Power BI report fetches data from a dataflow in another workspace.
I would like to show the last "date and time" the dataflow was refreshed.
I can see the "date and time" in the workspace beside the dataflow, but I would like to fetch it into the report.
Thanks,
Anna.
Solved! Go to Solution.
A slighty roundabout way is to create a Power Automate flow that triggers when a dataflow refresh is complete. For example you could write to a reference file on a sharepoint. We mostly use it to request a refresh for a downstream dataset.
Obligatory note: The refresh date of a dataflow or dataset is largely meaningless. What really counts is the data freshness inside the dataflow or dataset. Ideally that is a last modified date, or a latest order date etc. Dataflows will happily and successfully refresh stale data over and over if you ask them to.
A slighty roundabout way is to create a Power Automate flow that triggers when a dataflow refresh is complete. For example you could write to a reference file on a sharepoint. We mostly use it to request a refresh for a downstream dataset.
Obligatory note: The refresh date of a dataflow or dataset is largely meaningless. What really counts is the data freshness inside the dataflow or dataset. Ideally that is a last modified date, or a latest order date etc. Dataflows will happily and successfully refresh stale data over and over if you ask them to.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |