Question

You inherited a Power BI Desktop report that connects to an on-premises SQL Server. After the previous analyst left, the report fails to refresh with an authentication error because it still uses their stored Windows credentials. You need to update the connection to use a service account without rebuilding any queries. In Power BI Desktop, which action should you take?

Accepted Answer

Open File > Options and settings > Data source settings, select the SQL Server source, choose Edit Permissions, and update the credentials.

Answer

Delete all queries in Power Query Editor and re-create them so the new credentials are prompted.

Answer

Create a new parameter for the username and password and reference it in each query's connection string.

Answer

Change the storage mode of every table from Import to DirectQuery to force a credential prompt.