SharePoint search usage reports in Power BI

[mackar]

Is there any way to display the SharePoint Serach usage reports in Power BI and update them automatically?

I can download the .xlsx files manually and use in PowerBI but I would want Power BI to collect and update the reports automatically.

[v-yuta-msft · Accepted solution]

@mackar,

I'm afraid currently there's no built-in Sharepoint search connector in power bi. As a workaround, you can try Odata.feed instead. You may refer to the steps in this blog. Also similar cases below for your reference:

https://social.technet.microsoft.com/Forums/en-US/f43087da-2144-4cc7-98f8-3bee9c0d1c63/sharepoint-on...

https://techcommunity.microsoft.com/t5/SharePoint-BI/Issue-powerbi-getting-data-from-SharePoint-Sear...

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.