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?

A. From Power Query Editor, create new queries.

B. From Power Query Editor, modify the source of each query.

C. Create a PBIT file, open the file, and change the data sources when prompted.

D. Modify the Data source settings.








 

Suggested Answer: D

Open the PBIX file with Microsoft Power BI Desktop.
Then choose File -> Options and settings -> Data source settings >Right click data sources and change source.
Note:
Incorrect:
Not C: PBIT is a template file.
The PBIT file keeps your report structure and contains 'DataModelSchema File' instead of ''DataModel File''. However, If you choose import mode, the PBIX file stores all imported data from data sources and the report structure.
Reference:
https://windowsreport.com/open-pbix-file/

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.