Can PowerBi be directly linked to OneNote for reporting?

[v-sttaub]

Hi , I see many examples of suggestions of embedding powerbi in OneNotes, but what I would be looking to do is to connect powerbi to show data from OneNote.

We have a number of OneNotes that have 100 checkboxes or more.  We are looking to take the results of those checkboxes and include the counts in our PowerBI report.

Is this possible?

I guess the real question is, can PowerBi be directly linked to OneNote for reporting?

[foodd]

The OneNote API/Graph API can get sections and pages

GET https://graph.microsoft.com/v1.0/me/onenote/notebooks/{id}/sections

GET https://graph.microsoft.com/v1.0/me/onenote/sections/{id}/pages$count=true&$top=100

There may be a limitation to the number of pages that can be accessed by the API (recently introduced?). Then a further call to get individual page content:

GET https://graph.microsoft.com/v1.0/me/onenote/pages/{id}/content[?includeIDs=true]

An alternative may be to use this rust OneNote notebook parser - creates html files.

[v-piga-msft · Accepted solution]

Hi @v-sttaub,

It seems that you want to get data from Onenote in Power BI. However, we may not have the option to achieve it in Power BI currently. 

Please review and vote this feature request. If Power BI add it, the idea status will be changed completed. And please look you eye on the blog.

Best Regards,

Cherry

[v-sttaub]

Thanks for the response!

[v-sttaub]

Thanks for the response. Though it's currently not integrated, I'm glad others have expressed interest in it.

Some of the reality shows on TV allow you to vote over and over again.  Can I do that here?

[Mooihoek]

I'm also investigating but don't believe that intergration is available right now.