Question 110
A Power BI team has this requirement: A sales analyst must combine a local CSV with an Azure SQL table, but SQL authentication is failing after a password rotation. Which approach should it implement?
Explanation
Correct Answer
This directly addresses the stated constraint. Connection credentials control access to the source independently of report filters. Confirmation: A refresh succeeds with the rotated credential without exposing the password in the report.
Incorrect Answers
Pivoting the three month fields again preserves the unsuitable wide layout. The specific problem here is that changing a visual filter cannot repair a failed source authentication handshake.
A local C:\Users\ path refers to one desktop and breaks unattended service refresh. The specific problem here is that changing a visual filter cannot repair a failed source authentication handshake.
Removing all rows containing any blank cell discards legitimate partially populated descriptions. The specific problem here is that changing a visual filter cannot repair a failed source authentication handshake.