How do I set up MotherDuck to work with PowerBI?

To set up MotherDuck with Power BI, install the DuckDB ODBC driver and the DuckDB Power Query Connector, then place the .mez connector file in your Power BI Custom Connectors folder. In Power BI Desktop, select "Get Data" → "More...", search for "DuckDB", and choose the connector. For MotherDuck, use md:your_database as the database location and provide your MotherDuck token, which you can obtain from the MotherDuck UI. After connecting, you can select tables, transform data, and build visualizations as usual. For troubleshooting, ensure the Microsoft Visual C++ Redistributable is installed and that your token is valid. DirectQuery and scheduled refresh via Power BI Service are not fully supported yet—refreshes work in Power BI Desktop only at this time.For step-by-step instructions and troubleshooting, see the official MotherDuck Power BI integration guide, and for connector downloads, visit the DuckDB Power Query Connector GitHub. Would you like more detail on any specific step?Sources: - Power BI with DuckDB and MotherDuck | MotherDuck Docs - Troubleshooting Power BI integration