Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are building a Power BI Desktop report that merges data from an Azure SQL Database and a CSV file stored on a network share. When you refresh, Power BI shows "Information is required to combine data", and you must also swap the database login to a read-only account. Where in Power BI Desktop can you change both the stored credentials and downgrade both sources from Private to Organizational so that the merge succeeds?

  • Publish the report, then in the Power BI service go to the dataset's Settings page and change Data source credentials and privacy levels.

  • In Query Options under Global > Security, clear Require user approval for native queries and enable Ignore Privacy Levels.

  • Select File > Options and settings > Data source settings, highlight each source, choose Edit Permissions, then edit Credentials and set Privacy Level to Organizational.

  • Open Transform data, choose Advanced Editor, and manually add PrivacyLevel=Organizational and Credential fields in the M connection strings.

Microsoft Power BI Data Analyst
Prepare the data
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