Forum Discussion
Issue 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...
Have you worked through this blog post's code? This might provide some hints. http://makingthings.work/connect-power-bi-to-sp-search/
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
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.
Hi Treb,
in PowerBi Desktop the refresh works but in PowerBi Pro Online it does not :-(
kr,
Paul
- Hi Paul,
My experience with OData - in PBI Desktop you use Windows authorization; in PBI Online have to change it on OAuth2 (and do it each time when you update the model). But that was very limited experience.
