Exam PL-300 Microsoft Power BI Data Analyst

Access More Questions

You have one of the three Azure SQL databases listed below: - Test - Production - Development You have a dataset that draws its data from the development database. You must set up the dataset so that you can quickly switch between the powerbi.com development, test, and production database servers as the data source. Which one is the best?

Create a parameter and update the queries to use the parameter. Create a query for each database server and hide the development tables. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function. Create a JSON file that contains the database server names. Import the JSON file to the dataset.

Correct Answer:

Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Access more questions from this quiz

Continue to Exam PL-300 Microsoft Power BI Data Analyst for more practice questions and the full quiz experience.

Access More Questions