Forum Discussion
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 finally used web.contents. to refresh the data this works but now i have the XML data as it does not want to read the Json of SharePoint i am in a nested table issue.
I worked a lot out and came down to this and here is my problem:
Table.FromRows(List.Transform(element1, each List.Transform(_, each Record.FieldValues(_{1}){0} ))),
the problem is that record.field values only returns 1 column instead of all my columns. does anybody have a solution so it shows all columns?
I am new to the Powerbi stuff so have tried a lot but syntax incorrect or did not work :-(
hope for some answers.
Kr,
Paul
12 Replies
- Sorry TrebGatte it is still not working just tested it a moment a go..
Seems you found the solution for the refresh issue in PowerBI online yourself :-) Thanks for the good blog post: https://sharepoint-specialist.nu/connect-power-bi-online-to-sharepoint-search-using-rest-ca6e681233b8
That could be due to this
This morning i also have an issue with OData refresh as well as with some other cloud services.
Have you worked through this blog post's code? This might provide some hints. http://makingthings.work/connect-power-bi-to-sp-search/
I'm not sure why you can't refresh Odata as I use OData all of the time with Project Online OData feeds. with no issues refreshing. You have to reset the credentials in Powerbi.com after publishing as they get wiped on first publish.
