Dataflow under Power BI vs Dataflow under PowerApps

[richard-powerbi]

So I've created Dataflows before under Power BI.

Right now I'm discovering the world of Dataflows under PowerApps.

I'm wondering what the difference in usecase is.

I'm getting the idea that the Dataflow functionallity under PowerApps is the same but more advanced. You can create extra fields and read/write. Also it seems like you have unlimited refreshes without premium (but with PowerApps license).

So I'm thinking of replacing the Power BI dataflows by PowerApps dataflows.

I tried using a Power BI as a source in a PowerApps dataflow, but I believe that's not allowed. And it might be stupid.

Also I had lots of trouble getting data from SharePoint Folders and SQL through the interface of PowerApps dataflow. All kinds of errors about permissions etc. I discovered that just starting a blank query and coding the source data in M allowed me to access any source.

[edhans]

My understanding is Data Flows in Power Apps are entities (tables) loaded to the Common Data Service (CDS) whereas data flows in Power BI are just for use with Power BI and are read only (until refreshed of course). Those in CDS can be used by Apps and Flows and can be manipulated, and Power BI can use them as well for reporting.

I am thinking I'll use those in the Power Apps side for increased functionality overall, but in use cases where I never want an app to modify the data for any reason, I'll use the data flow on the Power BI side.