Importing Sharepoint Online Lists in SSAS Tabular

[Steffen]

Hi,

I'm using SSAS Tabular in Visual Studio and are trying to connect to a Sharepoint Online List, however I get an forbidden error. I'm trying to connect through Other data feeds which works fine with our on premises Sharepoint Lists.  The URL I use to connect is http://<my_sharepoint_server>/_vti_bin/ListData.svc which works fine with the Sharepoint Online Lists in Excel, which means that I am obviously authorized to read the list, however the same URL does not work in SSAS Tabular.

Is there anyone who have a fix to my problem?

[Steffen]

Hi,

I'm using SSAS Tabular in Visual Studio and are trying to connect to a Sharepoint Online List, however I get an forbidden error. I'm trying to connect through Other data feeds which works fine with our on premises Sharepoint Lists.  The URL I use to connect is http://<my_sharepoint_server>/_vti_bin/ListData.svc which works fine with the Sharepoint Online Lists in Excel, which means that I am obviously authorized to read the list, however the same URL does not work in SSAS Tabular.

Is there anyone who have a fix to my problem?

[v-sihou-msft]

@Steffen

Your question is related to SQL Server Analysis Services, please ask it on SSAS forum: 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices

For your issue, we have reported it to SQL Product Team internally.

Regards,

Simon Hou