NEW WHITEPAPER

DirectQuery in Analysis Services 2016

DirectQuery transforms the Microsoft SQL Server Analysis Services Tabular model into a metadata layer on top of an external database.

This whitepaper gives you all the relevant information needed to understand and use DirectQuery in your environment.

» READ MORE



 


NEW ARTICLE

Filtering Tables in DAX

This article describes a number of techniques available to filter tables in DAX, showing possible pitfalls that you can avoid once you know them, in particular using bidirectional filters.

» READ MORE



 


COURSES HIGHLIGHT

Last seats in NYC & L.A.
Early Bird expiring in EU

Don't miss the coming workshops:

New York, NY  
LAST SEATS

• Apr 24-28: Mastering DAX + Optimizing DAX
Los Angeles, CA  
LAST SEATS

• May 1-5: SSAS Tabular + Mastering DAX
Vienna, AT  
EARLY BIRD EXPIRING

• May 3-5: Mastering DAX
Helsinki, FI  
EARLY BIRD EXPIRING

• May 15-19: SSAS Tabular + Mastering DAX
Paris, FR  
EARLY BIRD EXPIRING

• May 15-19: Mastering DAX + Optimizing DAX


 


LATEST BI NEWS

What's happened in the last two weeks, with our comments:

• Power BI Desktop April 2017 – add column from example

A new transformation in Query Editor of Power BI allows you to create a new column by simply typing examples of the result you want. Only simple transformations by now, but a very promising feature.


• Power BI Desktop April 2017 – quick measures
Between the other many new features of April 2017 release, there are quick measures, which generate new DAX measures with a simple user interface. Microsoft is looking for new templates and we want to work with that. However, this will not happen soon because of current limited support for time intelligence, working only with auto date-time feature (which we suggest disabling when you have more than one date in the model). But it definitely worth to be tried, and measures obtained in this way can be customized.

• Power BI Service – custom cache refresh schedules
Tiles in Power BI dashboards connected to DirectQuery and live data sources are refreshed periodically (only reports are real-time – did you know that?). Now you can control the cache refresh frequency, up to 15 minutes.

• OKViz BETA visuals

Synoptic Panel, Bullet Chart, Sparkline and Card with States got updates that fix several annoying issues. Their release in the Office Store will take a few weeks, so use it in BETA today.