How to connect to .duckdb database?

[jaryszek]

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

[Anonymous · Accepted solution]

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

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.

[elitesmitpatel]

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]

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