Just been playing around with this. It looks like the functionality hasn't been properly rolled out and announced yet, but it can be done (and it's really easy!). Also, not sure if this has even been fully rolled out inside excel yet, I'm using excel 365 and it's working for me.
In excel, do Get Data -> Other Sources -> Blank Query.
The first line of your query needs to be:
=PowerPlatform.Dataflows(null)
If you've ingested a dataflow into Power BI before, this navigation will start to look very familiar. You'll need to sign in with your organisational account, and then you should see a table in the previous window show the records "Workspaces" and "Environments". Click "Workspaces", then under the "Data" field select "Folder" and it will drill down to the next level.
You can keep navigating down in the same way, but I find the easiest way to continue is to then click the Navigation Cog in the "Applied Steps" box and navigate exactly the same way that you would do in Power BI.
Congratulations! You've just connected Excel Power Query to your Power BI Dataflow! You can now interact with the dataflow in PQ exactly as you would any other source, and once you're done you can Load your data directly into your data model or a tab as usual.
Recent ideas
Org apps - Cannot be arranged in folders and do not stay hidden
Currently, Organizational Apps (Org Apps) are displayed in the standard Apps section of the Get Apps experience, alongside regular workspace apps. For organizations managing large-scale Power BI depl...akonda9 hours agoNew MemberNew5Views0likes0CommentsIncrease or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)
Power BI users frequently work across multiple reports, dashboards, semantic models, notebooks, and Fabric artifacts simultaneously. The current browser limitation of 20 open Power BI/Fabric items re...sharadmahajan11 hours agoRegular VisitorNew339Views21likes3CommentsAdd "NO SELECTION" default selected option to slicers
Scenario Currently, slicers have two states: No value selected (bogs report down) BI dev preselects one or more data values (problematic when reports are consumed by other clients/users) Option...arpost13 hours agoPost ProdigyNew8Views0likes0Comments