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 get an error as follows:

 

Failed to save modifications to the server. Error returned: 'The provider Microsoft.PowerBI.OleDb' is not registered. The following system error occurred: Class not registered A connection could not be made to the data source with the Name of......

 

 

Data Source
Report Server
SharePoint

2 Replies

  • 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.....