Dataflow is a tool that has been around in the Power BI service for a very long time , and is used to import, transform, and load data into a semantic model (ETL). Practically, it is Power Query in a cloud environment. With the advent of Microsoft Fabric, Dataflow Gen2 was introduced , which is much more advanced compared to the previous version and enables faster work with large amounts of data, as well as their parallel processing.
Since Power BI has been transformed and become part of the Microsoft Fabric platform, we have a number of new, useful options at our disposal. OneLake is the place where all of an organization’s structured, semi-structured, and unstructured data now resides, and is stored in an open Delta Parquet format for ease of access, sharing, and management . The OneLake catalog is a feature within Microsoft Fabric that works as a centralized place to store, find, analyze data.
If you want to allow the user to filter a report or one of its parts, you can do so by adding a Slicer visual. Traditional slicers are just fine, New Slicer visual has brought some additional improvements, and recently three new, similar visualizations have appeared, which can improve the quality of your reports. Let’s see what it’s all about.
Power BI visualizations often have a Tooltip section with which is a feature that enables focus on specific attributes. For example, if you hover an item shown in the report, you can see information about the manufacturer, number of brands, average price, etc. Something like this does not exist in Excel, but if we can mark items in some way, it is possible, with a little improvisation, affect the display of attributes. To do this, we will use the Checkbox option…
Microsoft Copilot is a chatbot, based on ChatGPT, and is integrated within many Microsoft services and applications. If you use it in Power BI Desktop reporting platform, it enables you to create quick measures and to generate DAX statements based on natural language. With Microsoft Copilot, creating measures has become much simpler, and you will find out how it is used in the “recipe” that follows.