Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hey Power BI Community,
is it possible to grab data from a Sharepoint 2007 (On Premises) List? I haven't found any way to establish a connection to it and get the data out of a list.
If there is no "standard" way to get the data - do we have some other opportunities to get the data on a other way / other tool, which could be a "stopover" to get the data into Power BI?
Best regards,
Thomas
SharePoint 2007 does not support OData so the standard way won't work. As I recall, there is a listdata.svc page that would return data in XML, you could try that.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 6 | |
| 5 |