Microsoft Power BI Data Analyst — Question 118
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the tabular model?
Answer options
- A. a scheduled refresh of the semantic model
- B. an OData feed
- C. an On-premises data gateway
- D. a subscription
Correct answer: C
Explanation
The correct answer is C, an On-premises data gateway, as it allows secure data transfer from the on-premises SSAS to the Power BI Service for real-time updates. Option A, a scheduled refresh, is not sufficient by itself without the gateway to facilitate data access. Options B and D do not provide the necessary connection to the on-premises data source.