try this

Open the report inside Visual Studio

On the Data tab click on the three dots next to the "Dataset" dropdown list. This will open the Dataset dialog box.

Click the button with the three dots next to the "Data Source" dropdown list. This will display the Data Source dialog box.

Click on the "Credentials" tab and select either the "Use Windows Authentication" or the "Use a specific name..." radio button. If the latter is slelected, enter a username and a password

I usually use a SQL user (not a windows user) specifically for running reports - but I would expect that using Windows Authentication would be equally successful, and wouldn't prompt for a password...

🙂