Line Breaks And Auto-Indent In The Power BI DAX Formula Bar

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

Bron : Chris Webb’s BI Blog
Lees meer…

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.

Bron : Marcellus Nav Blog
Lees meer…

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.

Bron : ArcherPoint
Lees meer…

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:

Bron : Dynamics NAV Team Blog
Lees meer…

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.

Bron : Chris Webb’s BI Blog
Lees meer…