I needed to setup different build versions of the WebClient on the same box. A customer was testing a higher build to move to and wanted the new build of the web client in place to match.
Since my post last week on using the Google Image Charts API to create sparklines and small multiples in Power BI has proved very popular, I thought I would do a follow-up showing how to use the Azure Maps API to create map small multiples. Here’s an example of what’s possible, a table from a sample report I built that displays crimes committed in London (sourced from here) in June 2018 with one row for each crime and a map column displaying the location of the crime:
The excellent work that David Eldersveld has been doing recently on using SVG images in Power BI has generated a lot of interest; now that the August 2018 release of Power BI Desktop allows you to set data categories on measures – and specifically the Image URL data category – David has been able to apply his work to the creation of sparklines and small multiples in Power BI.
It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve found on the internet work in more complex scenarios when the data on each sheet needs some kind of transformation before it can be combined.
Before you convert an existing Dynamics NAV solution to an extension written in AL, the ApplicationArea property must be set on all your custom controls. Otherwise, they will not be visible.
Setting the ApplicationArea property one by one is a tedious task that can be partially automated with the following PowerShell scripts:
In the Stock Exchange Bookkeeping App I wanted to be able to attach multiple files (ex: PDFs) to BVB Entries.
The attachments are files received from the brokerage firm and they refer to a transaction. For example, if I buy 1 stock, I will have 3 BVB Entries with the same Transaction Number. If I attach files, they will be linked to the Transaction Number and visible as below, in a Factbox, for all BVB Entries with the same Transaction Number:
Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always turns out to be a difficult task than I first assumed. On top of that, with this particular data source; data was coming as semicolon delimited text. Basically, there were many columns like Mile Stones and Sub Milestones, their related data and so on.