Category: Data Modeling
25
May
Solved! Query folding for native SQL in Power BI
by Nikola
3 Comments
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
31
Mar
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
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
Query folding – tricks, lies & ultimate performance test!
by Nikola
4 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
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
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...
03
Feb
DAXis – Dynamic axis in Power BI
by Nikola
2 Comments
Have you ever tried to dynamically change the axis on your visual? It's easier than it seems, with little DAX magic!
28
Jan
Handling locale letters in Power BI using Synapse SQL
by Nikola
No Comments
Special alphabet letters can be tricky to handle in Power BI. Or not? Check this straightforward solution using Synapse Serverless SQL pool!
15
Jan
How to capture SQL queries generated by Power BI
by Nikola
3 Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
02
Jan
Static vs Dynamic ranking in Power BI
by Nikola
No Comments
Learn how to handle one of the most common business requests in multiple different ways!