I previously wrote a couple of blog posts (post1 and post2) suggesting two different ways to access your Dataverse metadata in Synapse. Both of these techniques are now redundant as Microsoft announced in May 2022 that the Dataverse metadata is now available directly in Synapse. Your Synapse serverless pool now contains additional external tables with the metadata. Your queries … [Read more...] about Synapse Link for Dataverse – Metadata
Azure
Microsoft Azure is a public cloud computing platform and provides a range of cloud computing services such Platform as a Service (PaaS), Infrastructure as a Service (IaaS) and Software as a Service (SaaS). There are many benefits to using Azure as it's perfect for small businesses, security and compliance and compliments your current IT structure. Check out the latest posts from Joe Gill from tutorials to the latest news.
Dataverse Metadata in Synapse
Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse data lake as CSV files. A database with external tables is created automatically in the Serverless SQL pool providing access to the data in the CSV … [Read more...] about Dataverse Metadata in Synapse
Synapse Link for Dataverse – Option Sets
Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here On November 23 Microsft announced that DES (Data Export Services) will be deprecated and will reach end of life in November 2022. Microsoft is recommending that customers use Azure Synapse Link for Dataverse instead. DES has been around for a … [Read more...] about Synapse Link for Dataverse – Option Sets
Track Issues in Logic Apps/Flow using Correlation Id
Previously I have written some blog post, like this one, showing how easy it is to create API endpoints in Flow and Logic Apps. This involves creating a workflow that gets triggered by an Http Request with a Json payload. There are asynchronous “fire and forget” API calls and the calling process receives a 202 response code to indicate the workflow has been triggered. … [Read more...] about Track Issues in Logic Apps/Flow using Correlation Id
Flow – Http Request – Split On Collection
A use case I like with to use with Flow and Logic Apps is to create a workflow triggered by a Http Request that acts as an API endpoint. In a previous post I explained how to do it and how to configure Flow to the validate the Json payload. In that post the Json request was just a simple contact object with a few data fields that we inserted into Dynamics 365. Did know … [Read more...] about Flow – Http Request – Split On Collection
Generate Dynamics 365 PDF with Power Automate
One of the never ending challenges of using Dynamics 365 was how to generate and email PDF's using data from Dynamics. While Word templates went some way towards solving the problem they have not been improved for a number of years. So generating PDF's usually requires third party tools. With the release of the new Word Online (Business) connector for Flow and Logic … [Read more...] about Generate Dynamics 365 PDF with Power Automate
How to install the Data Gateway
I wrote a post a little while ago about how to use Flow to synch Dynamics 365 record changes to an on prem database using the Data Gateway. In this post I wanted to show how easy it is to install the Data Gateway. The data gateway acts a bridge between your on-premise data sources and your cloud services such as PowerBI, PowerApps, Flow and Logic Apps. You install … [Read more...] about How to install the Data Gateway
Logic Apps 429 Failure calling Dynamics 365
While doing some testing recently with Logic Apps I had some workflows fail with a status code of 429 when calling Dynamics 365 actions. A 429 status code indicates that the number of API calls to Dynamics 365 in one minute has been exceeded. This post explains how you can configure the concurrency setting of a Logic Apps workflow to avoid this problem. … [Read more...] about Logic Apps 429 Failure calling Dynamics 365
Flow to Synch Dynamics 365 with an On Premise Database
Up until recently synchronizing data in in the cloud with an on premise database was a major challenge which typically involved writing code. With the Digital Transformation revolution and the availability of a range of integration offerings in Azure this is no longer the case. Here is a sample Microsoft Flow which demonstrate how the creation of a contact record in Dynamics … [Read more...] about Flow to Synch Dynamics 365 with an On Premise Database
External Access to Dynamics 365 Using Azure AD
An option for providing users outside your organization with access to your instance to Dynamics 365 is to use Azure AD (Active Directory) . You add them as guest users in Azure AD, assign them a Dynamics licence and give them a security role in the instance of Dynamics they need to access to. It's as easy as that just follow the steps below. For this to work you need an … [Read more...] about External Access to Dynamics 365 Using Azure AD