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