Microsoft
70-778 · Question #83
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…
The correct answer is C. Configure the Data source settings. ttps://workingondata.wordpress.com/2016/07/05/power-bi-change-of-data-source-settings-got-
Consume and Transform Data by Using Power BI Desktop
Question
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?
Options
- ACreate a new connection to SQLProd, and then import the tables from SQLProd.
- BDelete the existing queries, and then add new data sources.
- CConfigure the Data source settings.
- DEdit the source of each table query.
How the community answered
(57 responses)- A7% (4)
- B18% (10)
- C72% (41)
- D4% (2)
Explanation
ttps://workingondata.wordpress.com/2016/07/05/power-bi-change-of-data-source-settings-got-
Topics
#data source settings#query editor#server migration#connection management
Community Discussion
No community discussion yet for this question.