Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

How to connect to .duckdb database?

Hi Guys, I installed duck db odbc driver and trying to connect it with power bi.    This is my set up ODBC: Data Source Name: Luke db Database: cost-mgmt-analytics\duckdb\cost_mgmt_analytics.d...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from elitesmitpatel, please allow me to provide another insight.
    Hi jaryszek ,

    You can use this custom connector to connect to the duckdb database (.db file)

    MotherDuck-Open-Source/duckdb-power-query-connector: DuckDB Power Query Custom Connector by MotherDuck

    In my testing, this custom connector worked well to create reports using data from the duckdb database.


    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from elitesmitpatel, please allow me to provide another insight.
Hi jaryszek ,

You can use this custom connector to connect to the duckdb database (.db file)

MotherDuck-Open-Source/duckdb-power-query-connector: DuckDB Power Query Custom Connector by MotherDuck

In my testing, this custom connector worked well to create reports using data from the duckdb database.


Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.