Connect Power BI directly to Metabase

Recently I've made a custom connector to connect Metabase to Power BI, you can try to use it or just copy the M code. It's not official and lacking some features but might work for you.
https://github.com/vmisq/PowerQuery-Metabase-Connector

Hi AndrewPF 

Currently there is not a simple direct connector for Metabase in Power BI. I saw Metabase provides a list of APIs for querying data, so it seems to be possible to fetch data from the databases you have. You can use its API to export data into a CSV. Or you can write some scripts to fetch data automatically. Then connect your Power BI report to the exported CSV file.

At present the first step is to figure out how to query data from a specific table in Metabase. I found some resources as below. Hope they would be helpful. 

Api Documentation (metabase.com)

Query Metabase data in Python. Metabase rest API and Python API | by Sophia Yang | Towards Data Science

Metabase Tutorial [PART #8] - Using the Metabase API - to fetch JSON, or Download a CSV - YouTube

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi Team, 

Can you please add a feature request for a direct connector to Metabase? Zapier does not directly connect with MB either, so this would be a great differentiator. 

Thanks, 

Sera

Hi, just bumping this up to see if there is a connector available today between Power BI and metabase. 

Hi PowerBI team - is there any news on this feature request? Please let me know if there is an easier way to connect Metabase to PowerBI. Thank you!