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.duckdb --> here is a path where duckdb database is located

 

and now i went to power bi desktop, use get odbc data. Choose the username as odbc name (i do not have any username there). 

And in power query i have:

 

What I am doing wrongly ?
Please help
Best,
Jacek

 

Need Help

3 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

    1) Please Authenticate .duckdb database while connecting.

     

    2) Check DSN Configuration:

    If the connection fails, ensure that the file path to the DuckDB database in the ODBC settings is accurate.

     

    3)Permissions:

    Verify that Power BI has access to the location where the DuckDB file is stored.

     

    4)Firewall/Drivers:

    Ensure there are no firewall restrictions or driver issues affecting the connection.

    If it helps Kudos to work and Accept it as Solution.

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

      Thank you elitesmitpatel 

      1) How to do this? database is on my local disc

       

      2) How to check this? In windows there is the option to configure it, not check it. 

       

      3) If ineed to trust specific location like in Excel?

      4) There is no firewall

       

      Thank you once again for help,
      Best,
      Jacek

  • 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.