Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
olimilo
Continued Contributor
Continued Contributor

Data flow/source scheduled refresh timestamp question - do I schedule refresh them both?

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?

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

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!


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

1 REPLY 1
arvindsingh802
Super User
Super User

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!


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.