-
I am glad to announce that Kurt Buhler has started to work with us at SQLBI – we just published his first article and video, Improving data labels with format strings. Now that the cat is out of the bag,… Read more
-
Bubble plot, quadrant plot, volcano plot, joint plot, swarm plot: they are all types of scatterplot visuals to make more effective #powerbi reports. Learn how to use them in this video from Kurt Buhler! Watch now
-
Be the first to learn about the new #dax language extension, which will forever transform how we write #powerbi formulas for hierarchical calculations! Watch now
-
What is the right choice between Direct Lake and Import mode in Power BI? Read more
-
The last update of Power Query finally supports Analysis Services Multidimensional and Tabular. I waited this version for a very long time, but now it’s finally here! Chris Webb already wrote an interesting blog post with several useful link and informations. You… Read more
-
An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day… Read more
-
During the keynote of the PASS Business Analytics Conference, Amir Netz presented the new forecasting capabilities in Power View for Office 365. I immediately tried the new feature (which was immediately available, a welcome surprise in a Microsoft announcement for… Read more
-
The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the… Read more
-
I wrote many articles and white papers about implementing many-to-many relationships in Analysis Services – for both Multidimensional and Tabular models. For the latter, the same techniques are also useful in Power Pivot and Power BI. With the recent release of Excel… Read more
-
After the initial release of DAX Studio 2.0, in December 2014, I started working on a few features to analyze performance of DAX queries. Darren Gosbell implemented many other features, and Daniele Perilli helped us with the graphics of the… Read more