Unable to to connect to local .duckdb file using PowerBI ODBC

[acarter24]

What happens?

When setting up an ODBC connection in PowerBI using the DuckDB Driver and a local .duckdb file, I receive a non-descriptive error message and no tables are shown for selection.

Expected outcome:

See list of tables and columns to select from in PowerBI.

Here is the duckdb file open in dbeaver for comparison:

To Reproduce

ODBC connection string:

database=C:\Users\***\meltano.duckdb

OS:

Window 11

DuckDB Version:

7.0.1

DuckDB Client:

ODBC

Full Name:

Andy Carter

Affiliation:

Powershop

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[rdataforge]

same issue here on windows 10 and latest driver. There is a workaround if you want to try:

1. export data tables to parquet file
2. connect using CTE (see link to website)

https://datamonkeysite.com/2022/04/17/using-duckdb-with-powerbi/

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.

[guenp]

I've created a DuckDB Power Query Custom Connector that let you import your data from a duckdb database directly: https://github.com/MotherDuck-Open-Source/duckdb-power-query-connector
It's still in beta so bug reports/contributions are encouraged!