On-premises gateway for OneNote file

[Anonymous]

Hello,

One of the users is having OneNote file connected to her dashboard. She wants to get it published and requested a gateway connection to the OneNote location. We are using on-premises gateway and struggling with setting up the connection to OneNote. Do you know which connection type should we use for OneNote file?

Thanks,
M

[foodd]

I realize that this post has a solution attached, however a couple of options may be of 

interest to you in accessing OneNote.  

• Use the OneNote REST API
• Rust OneNote® File Parser

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to connect to oneNone in power BI.

According to my search, there is no default connector for OneNote in Power BI. I found a connector for OneNote called CData CLoud.

For this you can refer to if it can help you in some place:
OneNote Power BI Connector - CData Software

Import OneNote Data into the Power BI Service for Visualizations (cdata.com)

And it contains documents on how to configure the local data gateway, you can refer to it:

Publish Real-Time OneNote Data to PowerBI.com (cdata.com)

Create OneNote Dataflows on PowerBI.com (cdata.com)

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly