Forum Discussion

Alexander24's avatar
Alexander24
Helper II
9 years ago
Solved

Connect to SharePoint 2007 List

Hi     - I have a sharepoint list (2007) that my division uses to input data into - Currently i have an excel file with the data in that i can refresh (via export to spreadsheet option (ODC file) ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Alexander24,

    I am afraid that you are not able to directly connect to SharePoint 2007 list from Power BI. Power BI uses OData to connect to SharePoint, but SharePoint 2007 doesn’t support OData.

    Besides the excel method you have described,  you can consider to import data from SharePoint list to SQL Server database with SSIS following the instructions in this blog, then  connect to SQL Server database from Power BI Desktop and schedule refresh for the dataset in Power BI Service.

    Thanks,
    Lydia Zhang

  • Alexander24's avatar
    Alexander24
    9 years ago

     

    Where there is a will there is a way!!!

     

    I inspected the element in Google Chrome + looked through the HTML to pull the web query string and then put it into Power BI as a Web Source and it worked!

     

Alexander24's avatar
Alexander24
Helper II
9 years ago

 

Where there is a will there is a way!!!

 

I inspected the element in Google Chrome + looked through the HTML to pull the web query string and then put it into Power BI as a Web Source and it worked!

 

FredMc's avatar
FredMc
Frequent Visitor
8 years ago

Could you share how it looks the web query string?