Question 340
A solution was implemented for this need: A sales analyst must combine a local CSV with an Azure SQL table, but SQL authentication is failing after a password rotation. The selected approach was: Update the Azure SQL data source credentials in Power BI's data source settings, then reconnect. Which result most directly proves it worked?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Connection credentials control access to the source independently of report filters. A failed implementation may show: Changing a visual filter cannot repair a failed source authentication handshake.
Incorrect Answers
The resulting model exposes only required columns and refresh payload is reduced. However, this does not establish the required outcome: a refresh succeeds with the rotated credential without exposing the password in the report.
The report uses central measures and reflects authorized shared model updates without copying all source queries. However, this does not establish the required outcome: a refresh succeeds with the rotated credential without exposing the password in the report.
The model can match expected SKU keys and the unmatched-key count is explained. However, this does not establish the required outcome: a refresh succeeds with the rotated credential without exposing the password in the report.