Trutz-Sebastian Stephani on 10 Jul 2017 14:21:10
It would be beneficial if one could connect directly to the SharePoint search and have the data also refresh in the Online service. Most of the data we use is spread in lists over a high number of sites. And while there is a possibility to just call the odata feed of every site, it takes time and won't refresh in the Online service.
There is a way of doing it shown here: https://sharepoint-specialist.nu/connect-power-bi-online-to-sharepoint-search-using-rest-ca6e681233b8
Wrapping it into a simple connector would reduce this rather complex M code.
- Comments (1)
RE: Allow to connect to SharePoint Search directly
The key thing is to support > 500 rows, with some kind of built-in paging, so you don't keep getting throttled by the SP Online Search API.