question

CaroleSulston-6361 avatar image
0 Votes"
CaroleSulston-6361 asked CaroleSulston-6361 answered

Connect tabular SSAS to sharepoint online

I am trying to connect to a Sharepoint online list from a SSAS tabular cube using Microsoft credentials which definitely have access to the Sharepoint list. The problem I have is that once the credential token expires my tabular cube will not update that data source. Is this something I can solve within the cube credential settings or is this something that must be sorted at the Sharepoint end?

office-sharepoint-onlinesql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered CaroleSulston-6361 commented

Hi @CaroleSulston-6361,

The article has a Powershell script to refresh these.

You may take a carefully reference to.

using-sharepoint-lists-in-ssas.html

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you I will give this a try.

1 Vote 1 ·

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·
CaroleSulston-6361 avatar image
0 Votes"
CaroleSulston-6361 answered

I have had to put this on the back-burner for a bit, but will come back to the issue - thank you for the information to go on with.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.