Forum Discussion

PaulKeijzers's avatar
PaulKeijzers
Frequent Visitor
10 years ago

PowerBi Pro SharePoint Search autorefresh columns to rows

For a Client of mine i am trying to create a dashboard of all documents in a sitecollection. it was no problem with odata.feed. but the problem with that was that i can not schedule it to refresh. ...
Anonymous's avatar
Anonymous
Not applicable
10 years ago
PaulKeijzers wrote:

For a Client of mine i am trying to create a dashboard of all documents in a sitecollection.

it was no problem with odata.feed. but the problem with that was that i can not schedule it to refresh.

 

Hi PaulKeijzers,

What is the exact error message when you fail to schedule refresh for the dataset? Please help to post it.

Thanks,
Lydia Zhang

  • PaulKeijzers's avatar
    PaulKeijzers
    Frequent Visitor
    10 years ago

    Hi Lyda,

     

    it is not solved :-( 

    the error i get when i use odata.feed = You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

     

    that is why i tried web.contents and get stuck in the Nested tables instead of rows.

     

    Kr,

     

    Paul

    • PaulKeijzers's avatar
      PaulKeijzers
      Frequent Visitor
      10 years ago

      Still no solutions available :-(

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Paul,

       

      Sorry I cannot help you out on this issue. But I do have a question. Do you have some source for me to find a manual/example howto get data in PowerBI using SharePoint (online) search. I want to query a content type (list item) and use the result in PowerBI. It can be a lot of records and I want to use a autorefresh. Do you have some advise?

       

      I did find this: http://makingthings.work/connect-power-bi-to-sp-search/

       

      I use this query (for start): https://my tenant/_api/search/query?querytext='ContentTypeId:0x01005CF44F9730394E45A4F413209E88EE9D*'

       

      Thanks, Mike