Forum Discussion
Deleted
Aug 20, 2016Issue powerbi getting data from SharePoint Search
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 problem with that was that i can not schedule it to refresh. i...
TrebGatte
Aug 22, 2016MVP
Have you worked through this blog post's code? This might provide some hints. http://makingthings.work/connect-power-bi-to-sp-search/
- DeletedAug 22, 2016
Yes did use this post as well but problem in this solution is that it uses Source = OData.Feed(
which you can not refresh in powerBi Pro or schedule.
So needed to use web.contents to schedule refresh.
Hope there is a different solution.
thanks
kr,
Paul
- TrebGatteAug 22, 2016MVP
I'm not sure why you can't refresh Odata as I use OData all of the time with Project Online OData feeds. with no issues refreshing. You have to reset the credentials in Powerbi.com after publishing as they get wiped on first publish.
- DeletedAug 23, 2016
Hi Treb,
in PowerBi Desktop the refresh works but in PowerBi Pro Online it does not :-(
kr,
Paul