cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

We weren't able to add this connection. Please try again when create a connection with "on-primises gateway" to Sql Server

When I created a connection to Sql Server(local) by on-primises gateway. 
I got an error message: 
We weren't able to add this connection. Please try again
More:

PowerBIEntityNotFound

Session ID: 8d77c0df-ae94-41e7-8a80-afa22ee7ab22

I tried to reinstall, make sure they are the same religion is southwest asia but could not resolve it.

Who can help me to fix it.

Thank you in advance 

 

issue.PNG

4 REPLIES 4
Community Support
Community Support

Hi @chithanh1012 ,

Have you installed the On-premises Data Gateway on your PC properly?

Have you enabled the On-premises Data Gateway for PowerApps and MS Flow?

Further, have you installed the On-premises Data gateway in same region as your current PowerApps Environment?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please check if you have enabled the On-premises Data Gateway for PowerApps.

 

Also please check if you have installed the On-premises Data gateway in same region as your current PowerApps Environment. If the issue still exists, please consider submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xida-msft 

I think everything ready and right. Because It has worked before.

 

 

issue2.PNG

 

I also created an ticket at https://powerapps.microsoft.com/en-us/support/

And waiting for your supports.

Thanks!

Hi @v-xida-msft
I am using Trial plan. Does it have any effect ?

 PowerApps for Office 365
 PowerApps Trial
Thanks!
Anonymous
Not applicable

hello did you find any solution regarding the same?

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (59,860)