Notifications
Announcements
No record found.
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 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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 81 Super User 2025 Season 2
Gerardo RenterÃa Ga... 49 Most Valuable Professional
#ManoVerse 40
