You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The…

The correct answer is D. Modify the Data source settings. Modifying the Data Source Settings (Home > Transform Data > Data Source Settings in Power BI Desktop) allows you to update the server and/or database name for all queries that share the same source in a single operation. This is the most efficient approach because all queries…

Submitted by fernanda_arg· Apr 18, 2026Prepare the data

Question

You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

Options

AFrom Power Query Editor, modify the source of each query.
BCreate a PBiT file, open the file, and change the data sources when prompted
CFrom Power Query Editor, create new queries.
DModify the Data source settings.

How the community answered

(58 responses)

A
3% (2)
B
10% (6)
C
2% (1)
D
84% (49)

Explanation

Modifying the Data Source Settings (Home > Transform Data > Data Source Settings in Power BI Desktop) allows you to update the server and/or database name for all queries that share the same source in a single operation. This is the most efficient approach because all queries pointing to the old Azure SQL database are updated at once. Option A requires manually editing the source step in every individual query, which is time-consuming and error-prone when there are multiple tables. Options B and C introduce unnecessary extra steps or work.

Topics

#Data Source Settings#Power Query#Connection Management#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice