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?
Suggested Answer: B
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
18 comments · newest first
CH
Charlette
12 days ago
I just want to get it done quickly.
AM
Amina
17 days ago
Exactly! Less admin work is key here.
BA
Barney
22 days ago
True, but it’s not as efficient as D.
CH
Charlette
27 days ago
I feel like B could work too, but it might be overkill.
AM
Amina
1 month ago
Plus, it keeps everything organized.
BA
Barney
1 month ago
Right? D minimizes effort. Just one place to update.
CH
Charlette
1 month ago
Option A seems too tedious. Changing each query is a hassle.
AM
Amina
2 months ago
I agree, modifying data source settings is straightforward.
BA
Barney
2 months ago
I think option D is the best choice.
KA
Kathryn
2 months ago
Wait, can you really just create a PBiT and change sources? Sounds too good to be true!
SH
Shelia
2 months ago
Definitely D, it’s the most efficient way!
TR
Trinidad
2 months ago
B sounds interesting, but is it really that simple?
JA
Jaclyn
2 months ago
I think modifying each query would take way too long.
HE
Hester
3 months ago
Just change the data source settings, super easy!
TO
Tonette
3 months ago
I’m leaning towards option D too, but I wonder if modifying each query in option A would be more thorough. It just seems like more work.
YE
Yen
3 months ago
I practiced a similar question where we had to change data sources, and I feel like creating a PBiT file could be a good approach, so maybe option B?
LA
Lauran
3 months ago
I'm not entirely sure, but I remember something about using Power Query Editor to change connections. Was that option A or C?
MA
Malcolm
3 months ago
I think option D might be the best choice since it directly mentions modifying the data source settings, which sounds like it would minimize effort.