The new EVALUATEANDLOG DAX function is great, but how do you actually use it in conjunction with SQL Profiler. This articles shows how and also demonstrates how to configure SQL Profiler as an external tool for Power BI Desktop.
If you use power bi direct query, you can define a date table at the source or in power bi. You can create a date table in Power BI. The table created in Power BI is in import mode. Power BI will enable mixed-mode queries.
Easily build dynamic pareto charts, and even more importantly, dynamically show which percentage of a category accounts for the majority of activities. Using the pareto principle, easily build an interactive parety style dashboard.
In this 3 minute post, you'll learn how to modify the custom theme file in Power BI to toggle the visibility of the calendar icon in the Date Slicer. This feature was introduced back in the March 2022 PBI Update, but it lacks the GUI option to turn on or off the calendar icon.
The world that we live in is filled by an infinite number of sensors that continuously collect data of all sorts. Among several other categories of data, these devices read a huge of amount of telemetry data which can be analysed thoroughly and put to good use. Azure IoT Central is a ready to use platform that allows us to connect to multiple IoT Devices and monitor the data that we receive from them. It can be used by large enterprises to analyse data at scale. Alternatively, it can be used by individuals who are looking for a new report idea.
Once such idea is connecting our mobile phones to IoT Central and then analysing the telemetry data received from it by exporting it into Power BI. Here's a quick walkthrough of the steps that you'll need to perform to export the required data into a Power BI Dataset:
Check the data that is flowing in from the Android Device.
Go to Azure portal and create an Event Hub. Start by creating a Namespace first. Create an Event Hub within it.
Give access to the event hub for listening to messages and get the connection string.
Configure Destination in IoT Central by choosing the event hub you just created.
Configure the Export.
Check the status of the Export.
Create a Stream Job in Azure.
Set the Event Hub as input and a Power BI workspace as output for the job.
Modify the query to get data in the required format.
Start the Stream Job.
A dataset will automatically be created in the selected Power BI workspace.
Once you have the Dataset in your workspace, you can use that as a source in your Power BI Report and analyse your phone’s GPS coordinates, whether it was picked up by someone and moved and a lot more by looking at the telemetry data.
What if when Power BI was released all those years ago that it defaulted to table and matrix totals simply summing the rows? Let's explore this alternate reality and how you would handle displaying an alternate summary of information in a table or matrix.
Using Power Query ETL, here's a method I implemented for transforming multiple columns in a single step based on another column. In my most recent Power BI project on Financial Reporting, I had to deal with this challenge. In Power Query, using just the GUI may take more steps and take longer to achieve the desired result. The results can be obtained quickly and efficiently by applying a bit of "M" coding.