nerdexam
Microsoft

DP-500 · Question #17

You have live Power BI reports that contain R script data sources and R visuals. You need to publish the reports to the Power BI service and configure a daily refresh of datasets. What should you…

The correct answer is D. an on-premises data gateway (personal mode). To publish Power BI reports with R script data sources and R visuals to the Power BI service and configure daily refreshes, an on-premises data gateway in personal mode is required.

Implement and manage a data analytics environment

Question

You have live Power BI reports that contain R script data sources and R visuals. You need to publish the reports to the Power BI service and configure a daily refresh of datasets. What should you include in the solution?

Options

  • Aa Power BI Embedded capacity
  • Ban on-premises data gateway (standard mode)
  • Ca workspace that connects to an Azure Data Lake Storage Gen2 account
  • Dan on-premises data gateway (personal mode)

How the community answered

(33 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    3% (1)
  • D
    85% (28)

Why each option

To publish Power BI reports with R script data sources and R visuals to the Power BI service and configure daily refreshes, an on-premises data gateway in personal mode is required.

Aa Power BI Embedded capacity

Power BI Embedded capacity is for embedding Power BI content into applications and doesn't directly address the requirement for refreshing R script data sources.

Ban on-premises data gateway (standard mode)

An on-premises data gateway (standard mode) is typically used for multiple users and shared data sources, but it does not support R script data source refreshes as it doesn't execute the R runtime.

Ca workspace that connects to an Azure Data Lake Storage Gen2 account

A workspace connected to an Azure Data Lake Storage Gen2 account is relevant for dataflows or storing data, but it doesn't provide the runtime environment needed to refresh R script data sources.

Dan on-premises data gateway (personal mode)Correct

An on-premises data gateway (personal mode) is necessary for refreshing datasets that use R script data sources in the Power BI service, as it runs locally and accesses the R runtime environment to execute scripts. The personal mode is sufficient for individual users and their specific datasets, making it suitable for this scenario.

Concept tested: Power BI dataset refresh for R script data sources

Source: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

Topics

#Power BI Service#Data Refresh#R Script Data Source#On-premises Data Gateway

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice