Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • Tools
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

Data Platform

  • Home
  • Azure
  • Data Platform
Category: Data Platform/MSDyn365/T-SQL

Accessing Dataverse with Entity Framework

Posted On 21st September 202421st September 2024 By Mark Carrington2 Comments

Back when I originally looked at Dataverse’s TDS endpoint, one of the things I noticed was that you couldn’t use the Entity Framework reverse engineering tools to access the data. Thankfully, things have changed!

Category: Data Platform/MSDyn365/Power BI/T-SQL

OptionSet Labels in Power BI Reports

Posted On 9th March 20219th March 2021 By Mark Carrington12 Comments

If you’ve tried reporting on your Dataverse / Dynamics 365 data using Power BI, you’ll probably have noticed you don’t get the labels associated with any optionset (now “Choice”) fields in your data. There are ways around this such as using the PowerBI OptionSet Assistant solution. In this post I’ll Continue Reading

Category: Data Platform/MSDyn365/T-SQL

Using Dates from TDS Endpoint in Power BI Charts

Posted On 19th January 202119th January 2021 By Mark Carringtoncomment

As part of migrating some dashboards to Power BI using the TDS Endpoint I hit a problem getting a chart to show correctly. I needed to show invoices with the values grouped by month. This is simple in a standard Dynamics chart, and when importing the data into Power BI. Continue Reading

Category: Azure/Data Platform

Combining data with Azure Data Factory

Posted On 27th November 202027th November 2020 By Mark Carrington3 Comments

You can often add more value to your data by combining it with other sources to produce an enriched data set. By keeping large reference datasets out of the main Dataverse database you can dramatically reduce storage costs. You can then combine them as needed using Azure Data Factory.

Category: Azure/Data Platform

Visualising CDM Data with Power BI

Posted On 20th November 202020th November 2020 By Mark Carringtoncomment

In my last post I loaded some data from Excel into Azure Data Lake and stored it in the Common Data Model format. Now I want to present that data using Power BI.

Category: Azure/Data Platform

Loading Data into Azure Data Lake

Posted On 13th November 202013th November 2020 By Mark Carringtoncomment

Last time I showed how to create a data lake, but how do you get data into it? What format should you store it in?

Category: Azure/Data Platform

Exploring the Data Lake

Posted On 6th November 20206th November 2020 By Mark Carringtoncomment

In the world of data technologies, you’ll probably see data lakes appearing more and more often. I’d like to take a closer look at the Azure Data Lake and how it works with the wider Azure data ecosystem.

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp