Skip to main content

Power BI

Completed

Connect to Dataflows from Excel's Power Query

Vote (1040) 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

Administrator on 12 Sep 2022 07:23:49

Released.

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

CELINE Celine on 06 Jul 2020 00:00:41

RE: Connect to Dataflows from Excel's Power Query

we try to use dataflow as our data lake, data depository, and can be used by either Power BI reports or Excel users.

Michael Shparber's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:12

RE: Connect to Dataflows from Excel's Power Query

Need this to be available

Michael Shparber's profile image Profile Picture

mboachie on 05 Jul 2020 23:59:22

RE: Connect to Dataflows from Excel's Power Query

This please

Michael Shparber's profile image Profile Picture

Alisher on 05 Jul 2020 23:59:00

RE: Connect to Dataflows from Excel's Power Query

Must to be available

Michael Shparber's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:09

RE: Connect to Dataflows from Excel's Power Query

connect to dataflows from both Excel and Excel Power Query would be ideal.

Michael Shparber's profile image Profile Picture

Martin G 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

Swapnil 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

Nick Doy 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.