Analysis Services Tabular Model excel in sharepoint

Palios, Jason 81 Reputation points
2020-09-16T11:58:48.063+00:00

I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources.

When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual studio.
I think the issue lies with the fact that the excel files are stored on my workstation. I would rather not have a scheduled task from my workstation
to keep this data up to date for our BI users.

Is it possible to ignore these files during the sync? The excel files are rather static and seldom change. I have tried storing them in sharepoint,
but I cannot select files from sharepoint in visual studio, only local.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
433 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,239 questions
0 comments No comments
{count} vote

Accepted answer
  1. David Browne - msft 3,766 Reputation points
    2020-09-17T15:20:49.407+00:00

    I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources.
    Is it possible to ignore these {excel] files during the sync?

    Yes. In AAS/SSAS "sync" or "refresh" is called Processing. And there are many different options and scopes for processing. In particular you can process only a single table, or a list of tables in the model.

    See: Process database, table, or partition

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-17T05:59:41.553+00:00

    Hi,
    May I ask if this scene is related to On-Prem Analysis Service or only Azure Analysis Service ?
    Where have you create the tabular cube ? On Azure analysie service portal?


    If the answer is helpful, please click "Accept Answer" and upvote it.

    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. HarithaMaddi-MSFT 10,126 Reputation points
    2020-09-17T08:19:01.117+00:00

    Hi @Palios, Jason ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    As per my understanding, we don't have any option to disable data source for sync when model has it. Please check below link for reading excel files in visual studio when placed in SharePoint. Please suggest if this helps or let us know for further queries and we will be glad to assist.

    create-a-sharepoint-add-in-that-contains-a-document-template-and-a-task-pane-add