Unanswered

How to share common SQL data with users (DV tables, or share a connector, etc?)

(0) Share

Report

Posted on by NewPAUser2

What is the best way to share common data in SQL server with our PowerApps developers?

Things like a list of all our products, list of our employees, list of our offices addresses, basically views we have in SQL Server that I want to share/publish so that other Power Apps uses can access it and use it in their applications.

I don't want to grant them direct access to the SQL Server, I'd prefer to create a handful of views and then "publish" them.

Does this have to be done by populating a new Dataverse table?

Are there other ways I can share this?

I was looking at making an new connector but that seems to be specifically about setting up a connection to our SQL server. I don't want them to write their own SQL, I want to share a handful of useful views that they can consume for their various Power Apps.

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @NewPAUser2 ,

Have you looked at the Virtual Connector for SQL Server? This allows you to quickly build views into your SQL tables and even allow your developers to create relationships to these tables in their applications. There is a good step by step video here as well. https://docs.microsoft.com/en-us/power-apps/maker/data-platform/create-virtual-tables-using-connectors?tabs=sql

Was this reply helpful? Yes No
NewPAUser2 11 on at

Like (0)

Report

That is extremely helpful, thank you!

Other than using the virtual table connector, how would this sort of thing normally be addressed?

Is populating a Dataverse table the only way to do that?

Can a connection to the SQL Server and view be setup and shared out to other PowerApps authors?

It has to be an object that is fixed and unchangeable (not allowing Power Apps authors to modify the SQL or change the table it is pointed to, etc)

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (1)

Report

@NewPAUser2, You can use DataFlows to setup a connection from SQL to Dataverse and load the data from SQL into a dataverse table. You can schedule the refresh of the flows or use incremental refresh.

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

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @NewPAUser2 ,

You can utilize a user when setting up the virtual connector that only has read access to the database to restrict any type of updates. Another option is if you need updates for some users and not others, you can utilize a user with full rights and then control the security in Dataverse through standard security roles where you can setup the users to only have Read access for some and full Create, Read, Update, Delete for others...

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @NewPAUser2 ,

Did @AhmedSalih or I answer your question here? Please accept one or the other or both 🙂 if they did or let us know if any other questions / concerns / issues.

Was this reply helpful? Yes No