Announcements
I'd like to run some TSQL to pull data from FS365 and into an on-premise SQL Server and prefer to run some joint queries to get ID fields correct.
I don't see any tutorials though on how you can create a Linked Server pointing to a Dynamics 365 dataverse.
Hi
Bestbway is tonuse synapse link for the data you need to a gen2 storage datalake and from this one query your data.
Mox
Thanks. Will look into understanding Synapse.
Initial searches on how to connect Synapse to FS365 has turned up nothing.
Please let me know of any resources you know of.
You connect with dataverse. Where field service holds its data.
I'm guessing you meant to write that you connect TO Dataverse because "with" Dataverse would mean it's a tool to use.
The challenge is that I don't find any good tutorials on how to get access to the entities like Products, Qutes, etc. with Synapse.
I meant that with a synapse link to dataverse you can export required tables to a sql like datalake where you can execute the linked queries or query complex and composite datasets based on multiple resources.
docs.microsoft.com/.../azure-synapse-link-synapse
After looking into Synapse it seems pretty overkill.
I'm currently looking to see if Power Automate Flows will fit the bill.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 27
KristineRisberg 19
Manoj - ManoVerse 17 Super User 2026 Season 1
