Forum Discussion

larryortega's avatar
larryortega
Regular Visitor
8 years ago

SharePoint Online List Data Source error.

I'm using the new Power BI Report Server October 2017. Trying to use a Sharepoint Online *.xlsm data file as a data source. I can get logged in and connected but when I try to load the spreadsheet I ...
Data Source
Report Server
SharePoint
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi larryortega,

 

The SharePoint online list data source is used for retrieving SharePoint list data. Please use SharePoint Folder data source and try again: 

 

 

 

Best Regards,
Qiuyun Yu

  • larryortega's avatar
    larryortega
    Regular Visitor
    8 years ago

    Thanks for the reply. My topic is incorrect. I was using the Sharepoint Folder connection. There are multiple spreadsheets there and when I select the one I want it returns this error.

     

     

     Failed to save modifications to the server. Error returned: 'The provider 'Microsoft.PowerBI.OleDb' is not registered.....