Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then you need to create that as a custom column. Fortunately, Power Query has transformations that can help. In this Read more about Create Customized Age Bins (or Groups) in Power BI[…]
When you have blank values in your data table, you can use Power Query transformations to remove the row with blank values. There are two transformations that are used very often for this purpose: Remove Empty and Remove blank rows. These two transformations are not exactly the same. In this article, I’ll explain what is Read more about Row Filtering in Power BI and Power Query: Remove Blank Rows Vs. Remove Empty[…]
If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract all the text parts based on that, there is a simple way for it. In this article, I’ll explain how to extract multiple parts of a text value based on a delimiter in Power Read more about Split Column by Delimiter in Power BI and Power Query[…]
If you have a text field and you want to extract a part of that text field, there are multiple ways to do that. You can do this using the SUBSTRING function in DAX. However, These types of actions are better to be done using Power Query transformations. Fortunately, Power Query is very easy and Read more about Extract Parts of a Text Value in Power BI using a Delimiter: Power Query Transformation[…]
Often you do the transformation in Power Query using the graphical interface, but having the formula bar visible, makes it much easier to understand or change the transformations. In this short blog and video, I’ll explain that. Power Query transformations In Power BI, we use Power Query a lot for transformations, but mostly using the Read more about Power BI Quick Tip: the Formula Bar in Power Query[…]
I have previously explained a number of use cases for dataflows. One really useful case for it is to use dataflow for slow data sources. In this short article and video, I’ll explain how this works. What is a dataflow? Dataflow is a Power Query process that runs in the cloud and stores the result Read more about Dataflow: a remedy slow data sources in Power BI[…]
It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]
Do you have a Power BI dataset that gets data from a dataflow? have you ever thought; “can I get the dataset refreshed only after the refresh of dataflow completed and was successful?” The answer to this question is yes, you can. One of the recent updates from the data integration team of Power BI Read more about Streamline Power BI Refresh: Refresh dataset after a successful refresh of dataflow[…]
Dataflow is the data transformation service in Power BI, and also some other Power Platform services. Data Warehouse is the cloud storage and also compute engine for data. I often get this question that: “Now that we have dataflow in Power BI, should we not use the Data warehouse? What are the differences? which is Read more about Power BI Dataflow vs Data Warehouse: Which one to choose?[…]
I was in the middle of data transforming to create a clean dataset for a Charticulator post, that I come across a dataset as http://mdgs.un.org/unsd/mdg/SeriesDetail.aspx?srid=749 This dataset is for Carbon dioxide emissions in different countries around the world. The only columns I need from this datasets is about country name and the number of emissions for Read more about Remove Columns with Specific Patterns Name in Power BI using Power Query[…]