Good morning.
I have a problem with the reports (.RDLC) of my project (ASP.Net MVC), it turns out that I just uploaded it to Azure (App Service).
I was working with a local database, which did not have credentials (username, password), with Windows authentication.
Now I am using a remote database, the reports (.RDLC) do not work, with the application that I use to design the reports, I update the datasource, but I guess that the credentials are not being saved, this is the chain of connection.
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=miservidor;Initial Catalog=DataBase</ConnectString>
</ConnectionProperties>
In the preview that the design application gives me (already updated with the remote bd), if it works, but when I run the application, no data is output.