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 |
---|---|
106 | |
82 | |
72 | |
48 | |
48 |
User | Count |
---|---|
155 | |
91 | |
82 | |
69 | |
67 |