Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are developing a Power BI report that imports data from two distinct locations: an on-premises Microsoft SQL Server database and an Excel file stored in a SharePoint Online document library. After publishing the report to the Power BI service, you need to configure a scheduled refresh. Which data source requires an on-premises data gateway to be configured for the scheduled refresh to operate successfully?

  • The on-premises Microsoft SQL Server database only.

  • Neither data source requires a gateway because the credentials can be stored in the Power BI service.

  • The SharePoint Online Excel file only.

  • Both the on-premises Microsoft SQL Server database and the SharePoint Online Excel file.

Microsoft Power BI Data Analyst
Manage and secure Power BI
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot