Skip to main content

Power BI

Needs Votes

Connect to Dataflows from Excel's Power Query

Vote (683) Share
Michael Shparber's profile image

Michael Shparber on 26 Apr 2019 19:12:38

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

Comments (53)
Michael Shparber's profile image Profile Picture

fd51505c 4751-4d8b-8f30-197625a8a565 on 05 Jul 2020 23:57:52

RE: Connect to Dataflows from Excel's Power Query

Very 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!

Michael Shparber's profile image Profile Picture

10e3927f bc62-4b6d-9524-c01dcecd1830 on 05 Jul 2020 23:54:01

RE: Connect to Dataflows from Excel's Power Query

Will be great to have it. Speed of Power Query in Excel to process data is so slow when you need to shape the data.

Michael Shparber's profile image Profile Picture

1da5c41d 25e1-4ba9-b4bf-3912853bd0e4 on 05 Jul 2020 23:51:54

RE: Connect to Dataflows from Excel's Power Query

It would also be useful to Power BI users too.