Power BI datasets vs. Power BI dataflows - What gets refreshes?

Adam looks at what actually happens when you refresh a Power BI dataset and it is referencing a Power BI dataflows.

********
LET'S CONNECT!
********

***Gear***

#PowerBI #PowerBIdataflows #refresh

[esetiawan]

3 years later this is still relevant, ty sir! I only refreshed my Data Flow thinking that it would refreshed my report visuals, didn't realize I needed to set refresh schedule for the Dataset as well. Thank you sir, you are a gentleman and a scholar!

[AbouAli]

What I love most about "Guy in a cube" videos is: They're answering the exact point I am looking at!!.
Very nice one guys really .. keep it up and keep us inspired :)

[JackOfTrades]

Thanks Adam! This is definitely helpful as not many people mention this, and I've had to do testing to figure it out. I'd like to see a video that covers the current benefits/shortcomings/roadmap of using a dataflow, and also what it would look like to deploy multiple datasets that use a single dataflow. Two issues I've seen are: AAD might not be supported for Azure SQL when creating a dataflow, and a full download of the dataflow data is needed before a local pbi power query is executed (no query folding for data lake). I really want to use dataflows for our team so we can have centralized management of refreshes from sql (including incremental refresh), and reduce burden on sql servers.

[DrunkSailor-op]

Hello Adam, What about the other way around. I have a workspace where when the root dataflow is triggered, it seems to want to trigger all the dataflows that are dependent on it. I get a lot of refresh errors as the APIs those other flows refer to get overwhelmed or rejected due to many requests at once. Is there a way to stop that?

[NP-zghq]

That's what I was confused, a power automate refresh on dataset not giving the updates based on the latest changes in excel source file

[lauravasani]

Should the dataflow live in the same workspace as the dataset?

[NikhilKhairnar-ec]

hey so does this means we can set up different refresh timings for underlying datasets in data flow? or if one data source fails to refresh it still refreshes other datasources in dataflow without failing report?

[robdumont]

Can we access and display the last refresh date of a dataflow(s) used in a dataset? The PBI portal now shows the last refresh date of the dataset but that is misleading if the dataset references out of date dataflows...

[antonischrysovergis]

Hi and thanks for the explanation! I have the case where although dataset seems to be updated according to schedule the data inside are updated...and therefore the changes are not reflected in the report..On the other hand in the dataflow everything looks ok...any ideas ?

[samuelmanseau]

Hello Adams, thanks for your great work ; could you explain where the App Navigation comes from ?

[diegool]

Thanks Adam, one question, how does it work with DirectQuery and the Enhanced Computed Engine Settings?. I have a Power BI Embedded Capacity A1 and I'm using these dataflow feature but only the Dataset itself is refreshing with a 15 minute basis and not the dataflow.

[anchalawasthi]

Q. Hey, i am trying to hit the dataflow transactions power bi rest api in power automate using service principal. But it is giving an unauthorised as error ..detailed error is - service principal is not allower by tenant qdmin switch ... Can you plz help what access permission does the service prinicipal need to hit the api ?

[anderpaim]

What is the possibility of integration between DATAFLOW into the database (SQL for example) ???

[NicolasPappasA]

Thanks Adam, this is great. Is there a way to update the data flows via API like you would a dataset?

[rajasekharreddy]

Can you provide dynamic parameters stored procedure in power bi

[theg]

Has anyone tried a "Scheduled" data refresh on a share point online picture library? If so what function did you use?

[Eddyyc]

How can you refresh a dataflow from flow?