When we try to modify the T-SQL query, Excel will use your SQL Login credential reconnect SQL database to refresh data. If we don't save my SQL Login password in the data source connection string, the connection failed.
To solve this issue, please refer to the following steps:
Open the Excel workbook, and then lanuch PowerPivot window.
Click the "Home" tab -> Existing Connection
Please select corresponding data connection in your scenario, and then select "Edit".
Select "Save my password" checkbox.
After that, we can directly update T-SQL queries to refresh data for the PowerPivot model.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.