cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markse
Level: Powered On

creating connection to SQL server

hi.

am at the initial  / just starting stage with PowerApps.
have done a couple of "HelloWorld" apps using Excel and now want to connect to SQL database.

 

have created a gateway and am now trying to use the gateway to connect to the SQL 2019 instance on my PC

Get an error

we weren't able to add this connection. 

 

PowerBIEntityNotFound
Session ID: 6e06af55-c935-4239-85bb-aa0c9e70f8fd
 
what is this missing PowerBIEntity and where can I find it / get it ??
 
n.b. I do also have PowerBI Desktop application on my PC
 
thx
 
mark
1 REPLY 1
Microsoft v-siky-msft
Microsoft

Re: creating connection to SQL server

Hi @markse ,

 

It's hard to tell which steps is wrong. Could you share the steps with screenshots in detail? It will be helpful for us to provide further assistant.

In addition, please share the logs from the on-premises data gateway app. In the on-premises data gateway app, select Diagnostics and then select the Export logs link, as shown in the following image. This file is saved to the ODGLogs folder on your Windows desktop in .zip format.

Snipaste_2019-12-30_15-45-18.png

If you have installed Power BI gateway, please uninstall all, and re-install the latest version. And the followings are some tips:

  • From the computer where you installed the on-premises gateway, install Management Studio and try connecting to your SQL Server. The point of this exercise is to establish whether your internal gateway can connect to SQL Server, and that there aren't any firewall rules that are blocking the connection.
  • Is your SQL Server name setting correct? For example, if you're using a named instance, you would enter the value sqlsvr1\sqlexpress (or whatever instance name is correct in your setup)
  • If Windows authentication fails, try using SQL Authentication instead, if your SQL Server is set up for mixed mode authentication.
  • If you need to use Windows authentication and it still fails, try entering your username in the format YOURDOMAIN\Username.
  • If you still can't connect, try connecting by IP address rather than servername. Eg instead of entering sqlsvr1 as the servername, try using 192.168.0.10 (ie, the IP address that corresponds to your SQL Server).

If it still doesn't work, please share more details.

Sik

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,621)