Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.