
Announcements
Hello all,
I want to use the SQL Server Premium Connector please but I have an error ( the tables are not loaded) or Credentials are missing or not valid.
I used XrmToolBox to make SQL queries on my Dataverse tables and I want to display the results on Power Apps but I don't understand how can I use the SQL Server Premium Connector. I don't have a data gateway.
On Power Apps, I went to Connections -> SQL Server.
Many greetings.
Samuel.
Is your database on your local network? then you need a gateway, if your DB is stored in the cloud you can connect directly with the SQL connector, if you are not sure what login method to use open your sql server and check wich login method you use and use that: windows auth or sql server auth.