Showing results for 
Search instead for 
Did you mean: 
New Member

Connect to SQL Server Error

Hello there, 


I'm trying to use Powerapps "SQL Server" connect using an on-premises gateway (which is working fine with Power BI) but I'm facing an error while connecting to SQL Server, error message: 'The tables didn't load correctly. I'm sure about the SQL Server Name but not sure about the SQL database name. I have checked the SQL Server Management Studio and I'm not able to find the Database name.


Could it be an issue with the Authentication Type? If not, how can I get the correct SQL Database name?

My database is Microsoft Dynamics on prem.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,233)