Forum Discussion
Advocate IIImporting Sharepoint Online Lists in SSAS Tabular
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?
2 Replies
SteffenHi,
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-msftMicrosoft Employee
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