by Chris Webb | Jul 21, 2019 | Chris Webb
There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the...
by Chris Webb | Jul 15, 2019 | Chris Webb
If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data. Badly designed portals you have to log into every week to download the data,...
by Chris Webb | Jul 10, 2019 | Chris Webb
The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While there’s a good reason for this it can nevertheless be mildly confusing...
by Chris Webb | Jul 4, 2019 | Chris Webb
Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules. For example, say you have a table with the following data in it: …and...
by Chris Webb | Jun 30, 2019 | Chris Webb
A quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection: …and then you put a Q&A button on the report, clicking on the button gives the following error message: This post first appeared...
by Chris Webb | Jun 26, 2019 | Chris Webb
An interesting – if obscure – fact I learned recently is that a small number of DAX functions such as Median() do not work on tables with more than 2 billion rows in Analysis Services Tabular, Azure AS and Power BI. It’s quite easy to reproduce in Power BI. The...
