It’s highly possible that you need an enabled query folding, but this option is disabled for your table in Power BI. Let’s see how to resolve it. Why We need to Enable Query Folding? You may need to enable query folding for different reasons. For example, to apply the incremental refresh, to use direct query …
Do you know Power Automate can help you to refresh all your reports just by clicking a button or by setting refresh automation for all of them in a specific time? I previously created a blog post and video, and showed you how to refresh a report using a button. After that, some of you …
Do you like to know how Power BI report users can extract the Data behind Visuals into a CSV file just by pressing a button? Imagine that we have a report like this one. As you can see, this Line graph shows sales information for two product categories. I also created a slicer which helps …
Do your end users need notification on their emails when their sales amount picked a value or decreased below a certain amount? You can set an alert and she will get notified when this condition satisfied. To set an alert email we are using Power Automate in Power BI. You can also read other articles …
It is not always required to set a schedule for your Power BI reports to refresh it. You can create a button on the report and your end users can refresh data when they need. In this post I’m going to help you how you can create a report, to monitor and trigger refreshes using …
It’s absolutely valuable for your users to understand when was the last time your report get refreshed. Don’t miss this tutorial to learn how to create last refresh date and time field in your Power BI report. Consider we have a Power BI report like this one and you set a schedule to refresh it’s …
Do you like to create a dim date table in Power BI but you don’t know anything M Power Query language? Don’t worry! It’s a piece of cake with AI technology. Just try ChatGPT. If you’re new to my blog or YouTube channel I recommend you to read and watch all the previous tutorials. I’ve …
Slicers in Power BI are being used to filter the reports. The greatest thing about slicers is that you can completely change their format. You can easily customize slicers based on the end users’ requirements. Please read the article completely to understand how to use and apply it. You can also watch the video on …
Drill through is one of the most useful features available in Power BI which helps you to see the details behind your visuals. Please read the article completely to understand how to use and apply it. You can also watch the video on YouTube channel for better understanding. Example Let’s have this example. Consider that …
Do you want to use inactive relationships in you reports? Relationships are very important in Power BI. It’s something similar to joins in SQL. Sometimes you need to join two tables in Power BI using different fields. For example, you have a table in Power BI with 3 Date columns. And you want to join …