Unanswered

Unable to add on-premise SQL Server table to Dataverse (external data source)

(0) Share

Report

Posted on by wtave

Hello, I hope you are fine.

I'm trying to add a new table from an external data source, using a on-premise gateway connection to our SQL Server DB but I get the error shown in the attached image.

The connection works fine for Power Apps applications and Power Automate Flows. Permissions are ok, I also tried giving db_owner role, but it's not working. Can you help me please?

Thanks in advance.

Dataverse error.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @wtave, this is a connection issue. try to connect the connection first and see if you can:

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

wtave 16 on at

Like (1)

Report

Good morning, I hope you are fine @AhmedSalih

When I add the connection it works fine and says “Connected”. That connection is working when using the Import function in Dataverse.

I use the same DB and connection (on-premise) with Flow, PowerApps and it works fine.

Only getting an error when using it as external data source in dataverse, as mentioned before and can’t find any information on the error.

Thanks for your reply 🙏🏽

Was this reply helpful? Yes No
mbatutie 14 on at

Like (0)

Report

I had issues with my SQL connection for virtual tables as I was using a windows authentication account for my connection (windows auth worked well for all other purposes). Then changed to a different user with server authentication and that worked. However, my issue was the connection not showing up at all, without any errors, so might not be it, but worth a try!

Was this reply helpful? Yes No
wtave 16 on at

Like (0)

Report

Thanks for your reply @mbatutie

I always use SQL Server Authentication as we create users for every app. The thing is that as I mentioned it works fine for everything except when usen to create and external data source 😞

Thanks again.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@wtave, I tried from my end and I am also getting the same error. I would suggest that you open a Microsoft support ticket. Do you know how you can do that?

Was this reply helpful? Yes No
wtave 16 on at

Like (0)

Report

Thank you for the response @AhmedSalih.
I don't know how to create the support ticket, please help me out.

Thanks.

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@wtave, sure: go to https://admin.powerplatform.microsoft.com/ and do the following:

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

wtave 16 on at

Like (1)

Report

Thank you again @AhmedSalih .
I created the support ticket, and I will post the solution here if I get any.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (1)

Report

@wtave, that will be very useful as this is a new feature and more makers will start to use it.

Was this reply helpful? Yes No
jbiddle 6 on at

Like (0)

Report

Marking this as 'solved' is not right. The 'solution' was to contact support. How exactly does that count as solved?

Was this reply helpful? Yes No