The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code. I asked a few people if this was new because I was sure I hadn’t seen it before, even though I always put line breaks in my code; of course Marco had and said he thought it had been around for a while
Author: admin
NAV Integration with Trello
Here is an idea I developed to send Microsoft Dynamics NAV Jobs to Trello. It creates a board for a selected NAV Job and it will created cards for the posting type Job Tasks.
You can find the code on GitHub. Previously I blogged about Microsoft Flow, a great tool from Microsoft. You can do something similar with it but I wanted a few more options. If you would like to read the article about my first flow click here.
User bulk import with PowerShell
The ps command to add single users in nav is new-navserveruser, detailed info can be found here:
How to Set Custom Color Themes in Microsoft Power BI
When publishing internal and external reports for your business it is important to be consistent with your branding standards by using the same color schemes and logos. Microsoft Power BI it a great tool for creating and publishing dynamic and interactive reports and it allows for the customization of colors to match your brand standards. This blog will provide instructions on how to use Microsoft Power BI to create reports you are proud to share.
Change multiple Application Area tags with PowerShell
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:
Time Intelligence Using DAX
Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below).
Using Email Attachments As A Data Source In Power BI
Many of my customers get the source data for their Power BI reports – usually Excel or csv files – sent to them as an email attachment on a regular basis. When they get one of these emails what usually happens next is that they save the attachment to a folder so Power BI can connect to it. This a tedious manual process and of course one that breaks down if they’re off sick or away on holiday. However if you are using Exchange or Exchange Online it is possible to eliminate this step and have Power BI connect directly to the attachment without downloading it. In this post I’ll show you how, using Exchange Online as an example.