Allow Excel to Pull in PowerBI Dataflows in its Power Query
It hasn't been properly rolled out yet, but I've figured out how it can be done (and it's really easy!). Not sure if this has 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
Centralized retention policies for imported data in Power BI semantic models
Summary Please provide a tenant-level retention policy that allows administrators to centrally enforce automatic deletion of expired data from Power BI Import semantic models, independently of data ...JINHOYOO2 hours agoMicrosoft EmployeeNew44Views17likes0CommentsResizable Personalize visual pane or wrapped field names
Problem: The Personalize Visual pane width is fixed and long measure/column names are cropped making it difficult for users to identify which item to add to their visual. Idea: Allo...Simon_AUS4 hours agoRegular VisitorNew37Views8likes0CommentsRestore PNG Attachments or Enable Full-Size Viewing of Power BI Subscription Images
The recent migration of Power BI email subscriptions to the new platform removed the PNG image attachment that subscribers have relied upon for years. Although the report snapshot is still embedded ...Marsha_Brooks5 hours agoNew MemberNew7Views0likes0CommentsRestore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch6 hours agoNew MemberNew62Views6likes1Comment