Connect tabular SSAS to sharepoint online

Carole Sulston 26 Reputation points
2022-05-11T15:17:57.097+00:00

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?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,622 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 32,736 Reputation points
    2022-05-12T01:59:42.28+00:00

    Hi @Carole Sulston ,

    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.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Carole Sulston 26 Reputation points
    2022-05-16T08:01:35.687+00:00

    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.

    0 comments