Forum Discussion
Get data from SharePoint (online) search
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
Anonymous 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.
Anonymous
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
2 Replies
Anonymous 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.
Anonymous
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