70-467 · Question #117
You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?
The correct answer is B. Assign the Tabular instance service account permissions to the MarketResearch.xlsx network. For a tabular model to refresh data from a file-based source, the Analysis Services service account must have read permissions on that source file.
Question
You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?
Options
- AImport MarketResearch.xlsx to a new tabular database on the Tabular instance.
- BAssign the Tabular instance service account permissions to the MarketResearch.xlsx network
- CCreate a SQL Server Integration Services (SSIS) package that imports data from
- DUpload MarketResearch.xlsx to Library1.
How the community answered
(29 responses)- A14% (4)
- B79% (23)
- C3% (1)
- D3% (1)
Why each option
For a tabular model to refresh data from a file-based source, the Analysis Services service account must have read permissions on that source file.
Importing the workbook into a new tabular database creates an entirely separate model and does not enable refresh of the existing Research model.
When Analysis Services processes a tabular model, the Windows service account running the Tabular instance is the identity used to connect to data sources. Granting that service account read access to MarketResearch.xlsx on the network share allows the engine to open the file during scheduled or on-demand refresh without authentication errors.
Creating an SSIS package adds unnecessary complexity and an extra ETL layer; the tabular engine can read Excel files directly once the service account has the required file permissions.
Uploading the file to a SharePoint library changes its location but does not grant the Tabular instance service account the permissions it needs to access the file during processing.
Concept tested: Analysis Services service account permissions for data refresh
Source: https://learn.microsoft.com/en-us/analysis-services/instances/configure-service-accounts-analysis-services
Topics
Community Discussion
No community discussion yet for this question.