• 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 » Power Platform » Dataverse

Dataverse

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 Anonymization

25th April 2022 by Joe Gill

Many organizations require that personal data in non-production Dataverse environments is anonymized. This may be company policy or a legal requirement such as GDPR which governs the collection and processing of personal information in the European Union. Here is a quick tip on how to use the Bulk Data Updater for XrmToolBox to anonymize Dataverse data. In case you are not … [Read more...] about Dataverse Anonymization

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

How to handle Nulls in Dataverse Calculated Fields

1st August 2016 by Joe Gill Leave a Comment

One of the little wrinkles with Dataverse calculated fields is that they cannot handle nulls and so if one of the values in the calculation is null then the calculated field value is null.  In this example, I have four custom fields on the opportunity entity to track the customer's estimated sales by quarter. The calculated field that totals the four custom … [Read more...] about How to handle Nulls in Dataverse Calculated Fields

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

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

Dataverse Anonymization

25th April 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

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill