Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Notion Dbase Connection to MS Power BI

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

1 Answer

0vote

polle Points77470

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.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect