An on-premises data gateway keeps SSAS tabular data live in the Power BI service

Get or connect to data
Answer Correct answer: C — the on-premises data gateway carries the live SSAS queries so service consumers always see current data.

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?

  1. a scheduled refresh of the semantic model
  2. an OData feed
  3. an On-premises data gateway Correct Answer
  4. a subscription

Community Votes

C
100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Live connections to SSAS tabular models query the on-premises server in real time — from the cloud that traffic flows through an on-premises data gateway, keeping service consumers on the freshest data with no import lag.

A Desktop report reads from an SSAS tabular model on the company's internal network, and service consumers must see the most up-to-date data after the report is published to the Power BI service.

Scheduling refreshes — a live connection never imports data, so there is nothing to schedule; the gateway is what makes the real-time query path reachable from the service.

Community Discussion (3 comments)

rcaliandro 👍 8 Selected: C
Similar to a previous question. C is the correct answer
desibaby09 👍 2 Selected: C
C final and ONLY answer
jaume 👍 1 Selected: C
This is the same as Question 22 also in topic 4, glad to see it's the same proposed solution

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

The report uses a live connection to the internal SSAS tabular model, so all queries execute against that server at view time — data is as current as the model itself. The Power BI service reaches on-premises servers through the on-premises data gateway (C), which Microsoft requires for any cloud-to-internal-network connection; with the gateway in place, service consumers always read the model's latest data.

Why the Other Options Are Wrong

A scheduled refresh (A) applies to import-mode models that copy data into Power BI — the live connection has no imported data to refresh, and scheduling would still not achieve continuous up-to-dateness. An OData feed (B) is a different connectivity mechanism to expose data as an endpoint, unrelated to reaching an internal SSAS server. A subscription (D) emails report snapshots on a schedule — a distribution feature that actually guarantees stale content rather than freshness.

Community Comment Notes

Commenters answer C uniformly, with one noting this matches the standard pattern for internal-network Analysis Services sources. The gateway is the only listed component that bridges the Power BI service to the company network.

Official Reference

Related Analysis

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide