Posted inData & Analysis
Microsoft Data Insights Summit Videos Published
The Microsoft Data Insights Summit finished today, and the videos of the sessions have already (!!) been published online here: Bron : Chris Webb's BI Blog Lees meer...
Posted inDynamics NAV & BC Tips & tricks
How to Assign Dimensions to Master Data & GL Accounts in Dynamics NAV
This article and video continues the series of articles dedicated to Dimensions and explains how to assign Dimensions and Dimension Values to master data and G/L Accounts. In this article, the term “master data” is used to refer to such data as Customers, Vendors, and Items.…
Posted inData & Analysis
Data Privacy Settings In Power BI/Power Query, Part 2: Preventing Query Execution
In part 1 of this series I showed how the data privacy settings in Excel Power Query/Get & Transform and Power BI could impact the performance of your queries. In this post I’m going to show you how they can stop a query from running at…
Posted inData & Analysis
Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications
One of the most confusing, under-documented and widely-misunderstood features of Power BI and Power Query (or Excel “Get & Transform” or whatever you want to call it) are the data privacy settings. I get caught out by them all the time, so I thought it would…
Posted inDynamics NAV & BC Tips & tricks
Dynamics NAV Data Randomizing Tool
There are a lot of cases when Dynamics NAV clients during their solution upgrade do not want or just cannot give their confidential business information for third part companies which will upgrade their solutions. Data is very important to ensure high quality in upgrades and new…
Posted inOff-topic
Implementing incremental data load using Azure Data Factory
Azure Data Factory is a fully managed data processing solution offered in Azure. It connects to many sources, both in the cloud as well as on-premises. One of the basic tasks it can do is copying data over from one source to another – for example…
Posted inData & Analysis
Power Query/Get & Transform: The Future Of Data Loading In Excel
Last week, Dominic Petri shared a link on Twitter that contained some important news from Microsoft: as of the March release of the Office 365 click-to-run version of Excel 2016, the old methods of loading data into Excel will be replaced by the newer “Get &…