topic Re: SharePoint Online List Data Source error. in Report Server

SharePoint Online List Data Source error.

larryortega — Wed, 29 Nov 2017 17:39:08 GMT

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

Re: SharePoint Online List Data Source error.

v-qiuyu-msft — Fri, 01 Dec 2017 07:54:56 GMT

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

Re: SharePoint Online List Data Source error.

larryortega — Fri, 01 Dec 2017 13:00:22 GMT

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