Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
So I set up a report that exclusively uses a dataflow as it's data source. This data flow has 5 tables is scheduled to refresh every 3 hours daily.
When I published said report, it created it's own dataset. Upon checking it's lineage, I didn't find any issues as it's still using the dataflow as the source.
The dataflow's scheduled refresh goes off without problems however the report does not show the correct refresh timestamp via the query below:
let
Source = PowerBI.Dataflows(null),
#"workspaceID" = Source{[workspaceId="workspaceID"]}[Data],
#"dataflowID" = #"workspaceID"{[dataflowId="dataflowID"]}[Data],
LastRefresh1 = #"dataflowID"{[entity="LastRefresh"]}[Data]
in
LastRefresh1
That said, do I need to schedule the refresh of the report's dataset as well even though I already have its source dataflow refresh scheduled in order for me to properly display the refresh timestamp?
Solved! Go to Solution.
Yes, you have to schedule refresh of your dataset as well.
Do schedule it once your dataflow refresh completes and add some buffer to that
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Yes, you have to schedule refresh of your dataset as well.
Do schedule it once your dataflow refresh completes and add some buffer to that
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
User | Count |
---|---|
35 | |
22 | |
21 | |
14 | |
13 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
16 |