In this post, we will see how to automatically export the results of best practice analyzer for all our models. This post focuses on SQL Server Analysis, Azure Analysis Services, and Power BI datasets only if you have access to the BIM files. To automatically export the results of best practice analyzer from the Power BI service requires different approaches, especially on the authentication side which I won’t cover in this post. What is Best Practice Analyzer Best Practice Analyzer (BPA) is a feature of Tabular Editor that allows you to define rules based on your model’s metadata and then sca ..read more

In this post, we will cover how to migrate SSAS to Power BI Premium using Tabular Editor. Why migrate SSAS to PowerBI Premium instead of Fabric? Why Migrate SSAS to Power BI Premium instead of opting for Fabric? Well, surely migrating an on-premise architecture to Fabric and taking full advantage of the direct lake would likely be the most optimal solution. Still, it also involves moving all the data sources to Fabric first which is a much bigger project migration. Also, Fabric is still fairly new so you may prefer to wait a bit before considering using all the new Fabric features and start by ..read more

In this short post, we’ll explore how to enable quick-measure suggestions using Copilot in Power BI. Quick measure feature in Power BI If you’re not already aware, Power BI has a feature called quick measure that allows you to simply drag and drop columns to generate predefined measures such as time intelligence, Top N, aggregate measures, etc… Another available feature was the Suggestions where you could simply use natural language to ask Power BI to generate the DAX code for you. Since the recent release of Fabric and the integration of Copilot in Power BI the feature “Suggestion” has been ..read more

In this blog post, we will explore the difference between the Arithmetic Mean and the Geometric Mean with some practical examples in Power BI using the built-in DAX function geomean. Arithmetic Mean The arithmetic mean, also known simply as the “mean” or “average,” is the most common measure of central tendency. It is calculated by summing all the values in a data set and then dividing by the number of values. In DAX, you can use the AVERAGE function to compute the arithmetic mean. Example: Let’s say we have the following daily sales figures for a retail store: Day 1: $100 Day 2: $200 Day 3 ..read more

If like your C drive was running out of space and you decided to free up some space you may have realized that Power BI desktop was using a lot of your disk space. In this short post, we will see why Power BI desktop is consuming a lot of disk space and how we can safely reduce it. Analyze disk space usage There are multiple ways to analyze the disk usage space, we can use the built-in windows tool but I by far prefer more advanced tools like WinDirStat or TreeSize Free. Whatever tool you’re using to analyze the usage of your disk space don’t forget that some files will not show up unless you ..read more

In this post, I describe how to write an optimized median measure in Dax which under specific criteria can be 1,000 times faster than the built-in median function. Some time ago I was tasked to migrate a multidimensional cube to a tabular model, this cube had around 2 billion rows and I also had to create a median measure on the new tabular model. I first thought that the median would be much faster to calculate on a tabular model than on a multidimensional model but it turns out that the median was still extremely slow to compute on tables with large numbers of rows. At that time I had f ..read more

In this short post, I will describe how to show text results from an R script visual in Power BI. Microsoft Idea Today there is already an idea submitted to Microsoft to enable this possibility however this idea does not have a lot of votes so it is not likely to be added anytime soon so then the workaround comes to the rescue! Why do we even need to show text result from an R visual? According to the multiple comments submitted in the “Microsoft Idea”, the main reason is to show the result of a statistical test or summary information of a model. (And this is exactly what I’m using it for too ..read more

In this post, I will describe how we can implement a paired t-test in Power BI using DAX only. What is T-Test A t-test is a type of inferential statistic that can be used to determine if the means of two groups of data are significantly different from each other. In other words, it tells us if the differences in means could have happened by chance. There are three types of t-test: An Independent Samples t-test compares the means for two groups. A Paired sample t-test compares means from the same group at different times. A One sample t-test&nb ..read more

It is possible to hide tables in Power BI by using the “Hide in report view” option, however, if a user downloads the PBIX file this is still possible to view hidden tables or to unhide tables and this is also true for the reports with a live connection to SSAS or PBI dataset. In this post, I’m going to show another way to hide tables in Power BI which prevents users or anyone to view the hidden tables. Hide tables in Power BI To hide tables in Power BI we can either do it from the Model view or directly from the Report view. Once done we can see the hidden icon enabled on the table “v_dimDat ..read more

In this post, I will describe what is the Pearson correlation coefficient and how to implement it in Power BI using DAX. What is Correlation Coefficient The correlation coefficient is a statistical measure of the relationship between two variables; the values range between -1 and 1. A correlation of -1 shows a perfect negative correlation, a correlation of 1 shows a perfect positive correlation. A correlation of 0.0 shows no linear relationship between the movement of the two variables. How to interpret the Correlation Coefficient To go a bit more in detail we can interpret the corr ..read more