Power Bi dataset to dataiku

Mani1205
Mani1205 Registered Posts: 1

Hi All,

I would like to read power BI dataset Dataiku- is it possible if yes please let me know how to do it

Thanks

Mani

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,992 Neuron

    This is not a common pattern. In fact it's an anti-pattern given that Dataiku does have a plugin to export data directly into PowerBI.

    PowerBI is not a datastore. At best you could consider it as logical layer on top of other datastores. Microsoft doesn't even provide official ODBC drivers for PowerBI and of course there are no JDBC eithers which is what Dataiku will tipically use. There is however a PowerBI REST API which allows datasets to be queried using anything that can talk to a REST API. In Dataiku Python will be perfect but again Microsoft doesn't provide an official Python package to use the PowerBI REST API so you either do things manually using the Python requests package or you use a third party package like pbipy.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron

    @Mani1205

    Welcome to the Dataiku Community. We are so glad you have joined.

    Another way to think about this is to see if the power BI file is actually the source of the data. In most power BI use cases I've used with Power BI, the Data actually lived somewhere else and it was being pulling into Power BI for manipulation and presentation. Check out your data connections. See if there is actually a more direct source to the data. For example the data may be comming from a SQL database. If this is the case make that same direct connection into Dataiku and bypass Power BI completly. This is likely to produce a more robust solution.

    There is a down side to this approach depending on how much "M" you have used to transform the data inside Power BI. If you have done a lot of transformation of the original data source inside Power BI. You might have to re-do those same transformations from the original source to Dataiku. If this is a long term project. I might re-invent my Power BI inside Dataiku, and not use the Power BI at all.

    Just an additional point of view.

Setup Info
    Tags
      Help me…