Get Data from Twitter API with Power Query
2015-07-16
Use Microsoft’s Power Query tool to retrieve data from the Twitter APIRead More →
Find Duplicate Key Values in Tabular Data Models
2015-02-14
Identify duplicate key values in Power Pivot and Tabular modelsRead More →
Extracting Friendly Labels from MDX in Reporting Services
2014-08-13
In Reporting Services (SSRS), I found myself in a situation where I needed to extract friendly labels from MDX member keys. I had a fiscal year parameter being passed to another report via a drill through action, and I needed to display the selected fiscal years on the drill through report. So I had to convert something like [Fiscal Period].[Fiscal Year].&[2014], [Fiscal Period].[Fiscal Year].&[2013] to “Fiscal Year: 2014, 2013”. There are a couple of ways of doing this. If your labels always contain the same number of characters, you can use the MID function as shown later. I have multiple multi-value parameters being passed, however, so I wanted to be able toRead More →