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. ...
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

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