Power BI Quick Tip: the Formula Bar in Power Query

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[…]

Dataflow: a remedy slow data sources in Power BI

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[…]

How to modify a linked entity in Power BI dataflows

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[…]

Streamline Power BI Refresh: Refresh dataset after a successful refresh of dataflow

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[…]

Power BI Dataflow vs Data Warehouse: Which one to choose?

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?[…]

Remove Columns with Specific Patterns Name in Power BI using Power Query

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[…]

Working with Records, Lists, and Values in Power BI Dataflows

If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method Read more about Working with Records, Lists, and Values in Power BI Dataflows[…]

Remove Digits or Keep them in Power BI Using Power Query

There are a couple of useful actions that help a lot in cleaning data; removing digits, or keeping digits and removing everything else. In this short blog article, I’ll explain a simple method to do that using Power Query. Sample Data My sample data table looks like this: Removing Digits I can easily get rid Read more about Remove Digits or Keep them in Power BI Using Power Query[…]

Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI

I have written previously provided an all-in-one script for the date dimension, and also wrote an article about the relative date slicer. However, sometimes you cannot use the relative date slicer (timezone issue can be one example), adding offset columns help to overcome that challenge, and still be able to do flexible relative filtering in Read more about Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI[…]

Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI

Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I’ll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are Read more about Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI[…]