Posted inDynamics NAV & BC Tips & tricks

Get GDPR compliant with Dynamics NAV

On May 25, 2018, a European privacy law is due to take effect that sets a new global bar for privacy rights, security, and compliance. The General Data Protection Regulation (GDPR) is fundamentally about protecting and enabling the privacy rights of individuals. The GDPR establishes strict…
Posted inData & Analysis

An In-Depth Look At The Csv.Document M Function

CSV files are one of the most commonly used data sources in Power BI and Power Query/Get&Transform, and yet the documentation for the Csv.Document M function is very limited and in some cases incorrect. In this rather long post I’ll show you as many of the…
Posted inData & Analysis

Character Escape Sequences In M

When you’re working with M code in Power BI or Power Query/Get&Transform you may want to include special characters such as carriage returns, line feeds or tabs inside a text value. To do this you’ll need to use character escape sequences inside your text. Information on…
Posted inData & Analysis

Text Filtering in Power BI

There are lots of different ways you can filter data in Power BI including: • Slicers (with various configurations) • Cross filtering from any visual object • The filters pane on the right hand side of your report • Custom visuals designed specifically for filtering Bron…