You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I’ll explain how this works. If you like to learn more Read more about Pre Concatenate List of Values in Power BI using Power Query[…]
I have written about both types of parameters in Power BI; Power Query parameters and also the What If parameters. However, still many people are not aware that these two are different, and serve different purposes. In this blog article, I am explaining the differences between these two types of parameters, as well as the Read more about Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases[…]
Parameters in Power Query are useful for many scenarios when you want to do something dynamic in the data transformation process. I have previously explained how helpful they are in creating a custom function. In this article, I am showing you another useful way of using Parameters to create dynamic datasets, that you can change Read more about Change the Source of Power BI Datasets Dynamically Using Power Query Parameters[…]
I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn’t provide you with one Read more about Get The Error Count with the Profiling Data of Power BI Data Table using Power Query[…]
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in Read more about Overview of Available AI and ML capabilities in Power BI[…]
If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I’m talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the Read more about Change the T-SQL Script of a Power BI Table without Add/Remove from the Model[…]
I’ve been asked from one of my friends who were trying to create a random dataset for his presentation. There is a great and quick way that you can create a random list of numbers in Power BI using Power Query. In this short blog post, I’ll explain how to create this random list. You Read more about Generate Random List of Numbers in Power BI Dataset Using Power Query[…]
Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only Read more about Only Get the Last Few Periods of Data into Power BI using Power Query Filtering[…]
Power Query can connect to a web page and get data from there, and I have explained it before in my article about movies data analysis. However, the default way of getting data from the web page doesn’t fetch images into your report. Images in a webpage come through their own URL. If you can Read more about Get Images from Web Page Into the Power BI Report Using Power Query[…]
There are many scenarios that you might want to implement a conditional expression. When the conditional expression’s logic is on a row-by-row basis, the best is doing it in Power Query rather than DAX (there are exceptions always), The Add Conditional Column in Power Query is a very helpful option, but often many people find Read more about Conditional Column in Power BI using Power Query; You can do anything![…]