Month: March 2021

31 Mar

Data Modeling DAX Power BI SSAS

Power BI – How to fit 200 million rows in less than 1GB!

by Nikola

15 Comments

Extraordinary tasks request extraordinary solutions! Check how to pack 200 million rows in 18 MB of Power BI!

25 Mar

Data Modeling Data Visualization Power BI

In the spotlight – Object Level Security in Power BI

by Nikola

No Comments

Object-Level security exists for a while in some Microsoft's products. But, this is a brand new feature in Power BI! Still in preview, so let's...

14 Mar

Data Modeling Power BI T-SQL

Query folding – tricks, lies & ultimate performance test!

by Nikola

3 Comments

In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference...

09 Mar

Data Modeling Power BI

Query folding – Devil is in the detail!

by Nikola

6 Comments

In the 2nd part of the series on Query folding in Power BI, learn why people say that the devil is in the detail!

05 Mar

Data Modeling Power BI

What is a Query folding in Power BI and why should I care?

by Nikola

4 Comments

“Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: "Query...Whaaaat?!" In this series of...