Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Dataflow under Power BI vs Dataflow under PowerApps

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.



Super User III
Super User III

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.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors