Get the SQL Query used in DirectQuery mode
When you are optimizing your DirectQuery model and you have done all the optimizations on the model already, you might want to run the queries... Read more
Category: Power BI
5 reasons to use aggregations in Power BI
A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys... Read more
Power BI and the year 2019 in review
As the end of the year closes I was reminiscing on what a huge year it has been for Power BI. I work mostly with... Read more
Building a dataculture with Power BI
I meet a lot of customers in my job, either through the Microsoft field or at conferences and many times we hear the same: “We... Read more
Learn AAD when you manage a Power BI environment
I get many questions around Power BI and security related features. Users and customers often don’t realize that most of their requirements can actually be... Read more
Build your custom visual with Charticulator and Power BI
Recently I attended an excellent session by Andy Kirk on the state of data visualization for 2019. One of the tools Andy is most excited... Read more
Find all queries to Azure AS from a Power BI report or dataset
I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report... Read more
Refresh a Power BI dataset that feeds from SharePoint list automatically
The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and... Read more