Power BI Date or Calendar Table Best Method: DAX or Power Query?

So you want to create a date or calendar table in Power BI, and you search for ways to do that. Then you will find many different approaches for that. Some of the approaches are using Power Query, some are using DAX. Which method is the best? What is the actual difference between a date Read more about Power BI Date or Calendar Table Best Method: DAX or Power Query?[…]

Power Query Transformation Pattern: Convert Status Log Dates Table to Start and End Date Table in Power BI

I have previously explained how to analyze the data of a status log table and a from/to date table (like a subscription pattern). I also explained that in some scenarios a from/to table works better than a status log table. In this article and video, I’ll explain how you can transform or convert a status Read more about Power Query Transformation Pattern: Convert Status Log Dates Table to Start and End Date Table in Power BI[…]

Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters

I have written a blog article and explained how Power Query parameters can be used to change the data source in Power BI. Another useful scenario of it is actually to change even the data source itself. For example, you may have two data sources with exactly the same data structure (columns), but different data. Read more about Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters[…]

Power Query Function: Column Value Distribution in Power BI

If you have a table and want to create a report of column value distribution of it in Power BI, This function helps you achieve it. I have explained previously in another blog and video, how to do this process step by step. In this article, I’ll share the code for a custom function that Read more about Power Query Function: Column Value Distribution in Power BI[…]

Creating Column Values Distribution Report in Power BI Using Power Query

I have written about profiling data and the importance of it in Power Query, I also explained how the profiling data can be prepared to create a report in Power BI for the user to understand the data better. And I explained how the error count of that can be added to the report. Another Read more about Creating Column Values Distribution Report 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[…]

Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query

I am excited about this blog post, this is based on the New service in Cognitive Service name “Anomaly Detection” which is now in Preview. I recorded a video about how it works in cognitive service¬†https://youtu.be/7ZOtZDbn6gM.¬† However, I am going to talk about how to use it in Power BI. In this post first, a Read more about Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query[…]

Get The Error Count with the Profiling Data of Power BI Data Table using Power Query

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

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only Read more about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]