Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
22 | |
17 | |
10 | |
8 | |
8 |
User | Count |
---|---|
37 | |
28 | |
18 | |
17 | |
14 |