• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Blog » Azure

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.

Synapse Link for Dataverse – Metadata

5th July 2022 by Joe Gill

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

Dataverse Metadata in Synapse

17th January 2022 by Joe Gill

Datavseres Metadata - Azure 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

22nd December 2021 by Joe Gill

Azure Synapse Link for Dataverse Tables

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

16th July 2019 by Joe Gill

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

12th June 2019 by Joe Gill

Microsft Flow - Http Request - Split On

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

3rd February 2019 by Joe Gill

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

25th January 2019 by Joe Gill

PowerPlatform DataGateway - Joe Gill MVP

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

12th December 2018 by Joe Gill

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

19th November 2018 by Joe Gill

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

30th October 2018 by Joe Gill

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

Next Page »

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

Synapse Link for Dataverse – Metadata

5th July 2022 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Power Fx Formula Columns in Dataverse

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

© 2022 · Joe Gill