Thursday, February 03, 2022

Dataverse environmentid vs organizationid

Coming from a Dynamics CRM background, I mainly used the organizationid in the past (the organizationid is the unique identifier associated to a CRM instance). So having to use both organizationids and enviromentids isn't always easy,  and sometimes I still mix the two  - readability isn't a trait of GUIDS ... 



First some background on why we have two identifiers. With the July 2018 update of Dynamics CRM (version 9.0) Microsoft separated out the core platform features and the various business modules (Sales, Customer Service, etc...)  and this was also the point in time where CRM consultants where suddenly faced with a second identifier for a Dynamics CRM instance - the environmentid.

To find both the environmentid and organizationid of an instance, you open up the maker portal and select the developer resources link in the settings menu for an instance.


From this page you can find both the environmentid and organizationid - the Microsoft documentation still points to the legacy interface - Determine your environment's organization ID and name which starting from the maker portal requires quite a few additional steps ...

Tuesday, February 01, 2022

Quick note - refer to previous row in Power BI

 A number of good tips in this video on how to refer to a previous row in Power BI - I am not a Power BI expert but it got the job done - I just wanted to visualize Dataverse storage growth from one day to the next.


The grey area shows the forecast for the storage increase/decrease - for more info see Use the analytics pane in Power BI and  Introducing new forecasting capabilities in Power BI for Office 365 (dated but still relevant).