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 be a good idea to write a series of blog posts demonstrating how they work and what effect they have in different scenarios using example M queries.

Bron : Chris Webb’s BI Blog
Lees meer…

How to Tweak RDLC Reports to Increase Performance in Dynamics NAV 2013R2 or Higher

RDLC reports can have performance issues occassionally. Microsoft is aware, and has been enhancing report performance in every release since this became an issue. In this blog, I will explain how you can use a small feature in RDLC reports called “labels” to optimize performance.

Bron : ArcherPoint
Lees meer…