Please allow the connection to Dataflows' entities from Excel's Power Query. There are many cases when customers use Excel and not Power BI. But Dataflows can make the refresh process much faster for them. Thanks
110 Comments
- doy_nNew MemberIt would also be useful to Power BI users too.
- nilPower2018New MemberWill be great to have it. Speed of Power Query in Excel to process data is so slow when you need to shape the data.
- mgrosseNew MemberVery important to data model prototyping together with Excel users - they are used to seeing data in a certain way. This is a half-way house for them to help with validation of data before they get Power BI reports which look and feel very different to what an Excel user is used to. Further, it might even enable historical Excel type use-cases on larger datasets. Please, Redmond. Listen up!
- joe_leeNew Memberconnect to dataflows from both Excel and Excel Power Query would be ideal.
- mboachieNew MemberThis please
- AlisherNew MemberMust to be available
- CEZHNew Memberwe try to use dataflow as our data lake, data depository, and can be used by either Power BI reports or Excel users.
- simon_vanrijnswNew MemberNeed this to be available
- james_kaelinNew MemberThis would be good idea and it would help complete the whole vision/functionality of Dataflows and drive adoption.
- STargayNew MemberThis connector should have been available as soon as MS launched dataflows. It's only half-implemented with access to the dataflow not available in Excel.
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande6 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes15 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v15 hours agoCommunity ChampionNeeds Votes37Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_15 hours agoNew MemberAbandoned27Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer17 hours agoAdvocate INew1.2KViews26likes2Comments