Recreating an Azure Synapse Link for Dataverse connection

If you encounter an exception during the initial setup of Azure Synapse Link for Dataverse, it is best that you check in Azure Synapse workspace whether the lake database was only partially created. When you want to retry the configuration, you will first need to remove the lake database. 

Previously you had to manually write a script but Microsoft has now added a handy delete button which will generate an Azure Synapse Analytics notebook for you. To be able to run the script you will however need to setup a serverless Apache Spark pool. 

The smallest default configuration (4vCores/32GB) is sufficient to run this notebook - double check the pause settings of the Spark pool after the initial setup or just delete the pool if you don't to expect to need it anymore afterwards to save costs. 

Other blog posts on Azure Synapse and Dataverse:

• Getting started with Azure Synapse Analytics on demand webinars

Storage capacity management for Dynamics 365/Dataverse - how to track storage evolution with Power BI

After the introduction of the new storage management model in Dataverse in April 2019, both Dataverse and Dynamics CRM Online are using a tiered storage model (separation between database capacity, file capacity and log capacity). 

Based on the number of licenses acquired, every customer has a specific storage capacity entitlement - you can find an overview of storage consumption within the Power Platform Admin Center - section 1 shows an overview of all storage types consumed across all environments (support and trial instances are excluded), section 2 shows the allocated capacity based on number of licenses or purchased additional capacity and section 3 shows the biggest environments. 

To see where Dataverse storage is being used across your environments, you need to click on the second tab. From this page you are also able to download a CSV file with storage allocations for all environments to which you have access. The information on this page is updated every 24 hours and unfortunately no historical data is available so it is quite hard to track storage evolution.

I currently track the evolution of storage by downloading this CSV file and storing the exported file on SharePoint - then it is quite easy to use Power BI to combine the CSV files and create your own Power BI report and dashboard based on the storage details. I added a screenshot of one of the report pages below, for those of you interested in this Power BI report send me a DM on @jopxtwits 

References:

• Storage capacity enforcement for CDS instances (June 2020)
• Microsoft Dataverse data archival (2021 Wave2) - public preview initially expected in March 2022 but postponed to a later date.
• Dynamics CRM Data Cleaning
• Administer Power Platform - Free up storage space [Microsoft docs]
• Administer Power Platform - New Microsoft Dataverse storage capacity [Microsoft docs]
• Dynamics 365 Storage Utilization | Dataverse storage | Power Platform Admin Center

Dynamics 365 and Power Platform monthly reading list February 2022

2022 Release Wave 1

• 2022 release wave 1 plans for Dynamics 365 and Power Platform now available
• 2022 Release Wave 1 - First impressions by @CarinaMClaesson
• 2022 Release Wave 1 - Top 10 in 10 minutes (Youtube) by @LisaCrosbie
• Co-presence notification now in Preview for Dataverse and Dynamics CRM
• Release 2022 Wave 1 Summary by @BergmannBene
• Modern advanced find with enhanced view management in model-driven apps
• Modern advanced find test drive by @jukkan

Technical topics (Configuration, customization and extensibility)

• Use of new configuration page UI in Power Apps solution
• Using Entity Extraction AI model with Dynamics 365 CRM/Power Apps - Part 2
• Using PCF Gallery Code components in your environment by @CRMHeidi
• Service tags now available for Power Platform
• Dynamics 365 FastTrack Architecture Insights : Power Platform & Dataverse security strategy best practices by @HenryJammes
• Dynamics 365 FastTrack Architecture Insights: Create real-time and contextualized Power BI reports in your apps by @HenryJammes
• How to free up file usage - Dataverse Storage Capacity (Dynamics 365/CRM)
• Connections and connection references explained

Topics for Dynamics 365 Business Applications Platform consultants, project managers and power users

• Building big apps in small steps with low-code
• Premium auto capture in Dynamics 365 CRM
• Zero-party data is more valuable than ever for customer experiences
• Dynamics 365 composable approach enables rapid deployment of a supply chain control tower
• 5 ways CRM can help you succeed in a customer experience economy
• Dynamics 365 drives improvement in manufacturing supply chains
• 3 characteristics to look for in a Dynamics 365 migration partner
• Use a performance dashboard to optimize seller activities
• Achieving on-going leadership buy-in for Dynamics 365 projects
• 10 benefits of using Sales Accelerator in Dynamics 365 Sales
• Achieving successful B2B selling in the digital era
  
• Customer case: Rabobank selects Power Platform as its default development platform for internal process automation
• Improve seller productivity with a sales cadence