Forum Discussion

v-sttaub's avatar
v-sttaub
Frequent Visitor
8 years ago
Solved

Can PowerBi be directly linked to OneNote for reporting?

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?

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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's avatar
      v-sttaub
      Frequent Visitor
      8 years ago

      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?:manhappy:

  • Mooihoek's avatar
    Mooihoek
    Icon for Helper II rankHelper II
    8 years ago

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

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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.