Web App & Database Access

Question

What special access does my database content needs to have for a Web Application in .NET Core accessing the data?

The issue that I have is that when I run the application in .NET I can see all the data from my tables, but when I deploy the application to Azure (web deploy) the application run successfully but all my data is not visible.

When I change the connection string to an invalid user/pwd pair it fails, so it means that it is authenticating correctly. I have tried also hardcoding the connection string in the DB Context (desperate measure). But nothing works. Any user I can think of (owner,DBO, etc.)

What is weird is that my app shows some details that come from a view which data comes from dates calculations and not from the database tables, and this content is visible.

There must be something at the database/user level that I am missing, so the data is available from the web app.

An additional note, the firewall settings are configured to allow Azure to access the DB.

Can somebody give me an idea on what to look?

Thanks,

AM