10
Hello community hope you are having a splendid day.
We are working with D365 trying to create an user for read-only purposes to help us visualize information in SQL Server.
What would be the best way to query information from the Dataverse and at the same time been constantly refreshing the info. Thanks.
Hey!
MikeC282 response is probably one of the best you can have. You can also use PowerBI with dataverse connector, and this would use the user's credential, therefore limiting access to data.
The other approach would be to create an application with its own service principal (and not a password but a Client+Secret), and add this to the Dynamics environment. After this, you can use this application account to impersonate your connection to data.
Regards
Hey bud,
You can use SQL to query data from Dynamics already using the TDS endpoint.
docs.microsoft.com/.../dataverse-sql-query
Access to the tables conform to security role access and because TDS is read only. You don't have to worry about a user accidently running a SQL script that could insert or change something in the database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (