What should you do from Query Editor before you publish the model?

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.
You create a new Power BI Desktop model that uses 120 tables from SQLDev.
You plan to publish the Power BI file to the Power BI service.
You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.
What should you do from Query Editor before you publish the model?
A. Create a new connection to SQLProd, and then import the tables from SQLProd.
B. Delete the existing queries, and then add new data sources.
C. Configure the Data source settings.
D. Edit the source of each table query.

microsoft-exams

3 thoughts on “What should you do from Query Editor before you publish the model?

  1. From data source settings option also we can change source then why not answer is option C? it even reduces effort of going to each table and change data source. If any one have explanation to answer above please help me.

    1. You are correct Pradeep Answer should be D. Most of the answers are wrong in this site. Users verify before you opt for an answer.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.