Last month I published a new version of Enum Builder to the TechNet Gallery. The latest version only addressed a few bugs, the main bug was the accessibility property was being set to Private, this has been corrected and now sets the property to Public. In the previous release I added 2 new features:

1. Command line executable, here is an example of how to use the switches

EnumBuilderCLI.exe –MPID TestMP –MPVersion –MPName TestMP –RootEnumMPID System.WorkItem.Incident.Library –RootEnumMPVersion 7.0.5244.0 –RootEnumKey 31bf3856ad364e35 –CSVFile “C:_ITNew folderIR_Classifications – Copy.csv” –NewMPFile “C:_ITNew folderIR.xml”

2. The gui version now has an option to create negative ordinals


You can download the Data Management Gateway here or when you create your gateway in the Power BI admin center. Version 1.2.5303.1 was release in July 2014 added support for:

· scheduled data refresh for Power Query data connections with the following data sources: File (Excel, CSV, XML, Text and Access), Folder, IBM DB2, My SQL, Sybase, SQL Azure, PostgreSQL, Teradata, Sharepoint List, OData Feed, Azure Market Place, Azure HDInsight, Azure Blob Storage and Azure Table StorageContinue reading

While troubleshooting a runbook in SMA, I found a reserved word that to my knowledge is not documented anywhere currently.

You cannot use $class as a variable in PowerShell workflow or SMA unless in an inlinescript block

This was the error I ran into:

The following errors were encountered while processing the workflow tree: ‘DynamicActivity’: The private implementation of activity ‘1: DynamicActivity’ has the following validation error: Compiler error(s) encountered processing expression “class”. Expression expected.
Continue reading