Get data from SharePoint (online) search

[sp_mike]

I want to use data from SharePoint lists in powerbi.

I set up an Odata Feed using this query:

"https://my-tenant/_api/search/query?querytext='ContentTypeId:0x01005CF44F9730394E45A4F413209E88EE9D*'"

This gives me al listitems from a certain content-type. In the browser I get two records (which is correct). In PowerBI I get a lot of data and a lot of clicking to get to the the final records. Then it looks like this:

Not the way I can use the data.

What I need would be something like "Fieldname" > "value"

How can I clean up my query so that I have a table in PowerBI I can work with?

Thanks, Mike

[Seth_C_Bauer · Accepted solution]

@sp_mike Here is a quick blog that should help. Essentially any field that comes in with the highlight yellow can be expanded to retrieve the fields within it.

[v-haibl-msft · Accepted solution]

@sp_mike

You can expand the record and delete the unwanted columns based on your requirement. Check this link if the blog path provided by Eno1978 cannot be opened, it should be a useful article.

Best Regards,

Herbert

[Seth_C_Bauer · Accepted solution]

@sp_mike Here is a quick blog that should help. Essentially any field that comes in with the highlight yellow can be expanded to retrieve the fields within it.