DuckDB file connection

Hello alibega !

Follow this steps and you'll solve this problem:

1. Download and install the ODBC driver: https://github.com/MotherDuck-Open-Source/duckdb-power-query-connector/releases/latest/download/duckdb_odbc-windows-amd64.zip
2. Go to powerbi desktop -> File -> Options and settings -> Options -> Security -> Data Extensions, Enable "Allow any extensions to load without validadtion or warning"

3. Download the custom connector: https://github.com/MotherDuck-Open-Source/duckdb-power-query-connector/releases/latest/download/duckdb-power-query-connector.mez
4. Put this .mez file in the custom connector directory (e.g.: C:\Users\Documents\Power BI Desktop\Custom Connectors)
5. Open your PowerBI Desktop, click on get data and search for Duckdb, set the database and other configs.

To working in Power Bi service follow this steps:

1. Install a gateway

2. Open services and find the On-premisses data gateway and open this (double-click).

3. Go to "log on" tab and click on "Local System Account" and check the "Allow service to intera...." flag.

4. Restart the service.

5. Open the gateway, do your login and in the connectors tab put your custom connectors path (as the step 4 above).

6. Go to your browser, login in your Power Bi service account, click on settings -> Manage connections and gateways -> On-premisses data gateways

7. Click on the three points in the gateway -> settings -> check "Allow user's cloud data source to refresh through..." and "Allow user's custom data connectors..." -> Save

8. Create a new connection -> select the gateway -> select duckdb -> put you database path -> Anonymous auth -> check skip test connection -> create.

Now you'll be able to refresh the data.

for more information see:motherduckdb/duckdb-power-query-connector: DuckDB Power Query Custom Connector by MotherDuck

best regards!