Connect Power BI directly to Metabase

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.