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

    fa63f9fa 7e5f-479b-a3dc-a59dda94cd59 on 06 Jul 2020 00:12:24

    RE: Connect to Dataflows from Excel's Power Query

    I'm very surprised to find out that this functionality doesn't already exist

    Michael Shparber's profile image Profile Picture

    dae805d6 338f-40ae-af3f-972bd1ccab47 on 06 Jul 2020 00:12:15

    RE: Connect to Dataflows from Excel's Power Query

    is there someone working on this improvement?

    Michael Shparber's profile image Profile Picture

    b2b838ce 05c6-48db-a010-f5ce91578da1 on 06 Jul 2020 00:11:23

    RE: Connect to Dataflows from Excel's Power Query

    Please add

    Michael Shparber's profile image Profile Picture

    cb16285d b69b-4d54-a606-f83313a77f15 on 06 Jul 2020 00:11:11

    RE: Connect to Dataflows from Excel's Power Query

    Definitively required to enable validating user input from an excel sheet.
    (The dataflow contains the consolidated "Reference data" from all Markets)

    Michael Shparber's profile image Profile Picture

    a575fe02 69b8-e911-a96b-000d3a4f33c1 on 06 Jul 2020 00:10:39

    RE: Connect to Dataflows from Excel's Power Query

    Yes Please this would be the best feature ever!!!

    Michael Shparber's profile image Profile Picture

    75f62aa7 eacd-4df9-bd15-2ccea54120b1 on 06 Jul 2020 00:09:50

    RE: Connect to Dataflows from Excel's Power Query

    Would be a very usefull feature.

    Michael Shparber's profile image Profile Picture

    c4aede8c ac7e-e611-80f0-5065f38a7b91 on 06 Jul 2020 00:08:47

    RE: Connect to Dataflows from Excel's Power Query

    Please implement this as we are looking to use Dataflows as a light data warehouse. Not being able to pull this into Excel cripples Dataflows in filling this function.

    Michael Shparber's profile image Profile Picture

    d6a48f2f 9a7a-46e3-89ca-a3c017acd4b1 on 06 Jul 2020 00:08:31

    RE: Connect to Dataflows from Excel's Power Query

    Definitely have a need for this. There are a number of instances where what I need to produce is achievable in Excel but not PBI. PBI needs to be properly integrated into the Office suite so we can pull data into all applications as appropriate.

    Michael Shparber's profile image Profile Picture

    a6966d00 35c5-4f4f-b011-1f73ec2a9792 on 06 Jul 2020 00:08:09

    RE: Connect to Dataflows from Excel's Power Query

    With the pace of both Microsoft Office and IT release cycles, I wonder if the existing ODBC connector and the following idea could help provide a quicker time-to-market to serve this need:

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39704425-ODBC-driver-to-connect-to-a-Dataflow

    Even with the potential for a more generic ODBC Dataflows driver, a native connector makes a lot of sense to help keep feature parity in the Power Query codebase in PowerBI Desktop and Excel.

    Michael Shparber's profile image Profile Picture

    b0ce732c bcb6-4684-afc5-f46b40b235ab on 06 Jul 2020 00:07:10

    RE: Connect to Dataflows from Excel's Power Query

    We shouldn't need to ask. ;) Go!