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…

Optimise Business Processes with Machine Learning and Dynamics NAV 2017

The unstoppable progress of digital transformation not only changes the way of living and working of private individuals, but also presents big challenges to companies on a regular base. An efficient way of dealing with the increasingly rapid transformation are modern technologies and approaches such as machine learning.

Bron : ERP & BI Newsroom
Lees meer…

Using Text.BetweenDelimiters() To Extract URLs From A Web Page In Power BI/Power Query M

The Add Column By Example functionality that appeared in the April 2017 release of Power BI Desktop is, I have to say, very cool: I’ve used it quite a bit in the last few weeks and it really does work well. One thing I noticed while using it is that three new functions have been added to the M language to support this feature:

Bron : Chris Webb’s BI Blog
Lees meer…

Power BI, SSAS Multidimensional And Dynamic Format Strings

If you’re building reports in Power BI against SSAS Multidimensional cubes then you may have encountered situations where the formatting on your measures disappears. For example, take a very simple SSAS Multidimensional cube with a single measure called Sales Amount whose FormatString property is set in SSDT to display values with a £ sign:

Bron : Chris Webb’s BI Blog
Lees meer…