Question

Hi,
I'm trying to find a REST API solution to connect Notion database to MS Power BI via Power Query.

So far, I'm only able to generate JSON file from a Notion dbase that I import in MS Power BI via Power Query for ETL. I'd like to have direct connection to Notion dbase via Web Get Data function in MS Power BI / Power Query where I am still not successful.

Many thanks in advance.
Kind regards, -Nik

Answer 1

Not even Zapier or Make support MS Power BI, but they support tons of file formats and also Notion.

I believe that your best option here is to try them to extract the data as you need it from Notion, send it to "somewhere else" where you are able to use from MS Power BI.

That is the best and easier approach, otherwise you will have to write your own Script using the Notion API.