Power BI Desktop hosts a powerful data transformation tool in Power Query Editor that provides users with the ability to structure and cleanse their data before analyzing it. Mastery of Power Query Editor can do so much for your workflow in data analysis by making it easier to get your information ready for meaningful visualizations.… READ MORE
Today a lot of corporations have a lot of Data, which is the new oil in the modern world. The question is what to do with this oil? Oil needs a refinery so it can be created into further products. Similar to oil, data needs to be transformed and cleaned before its usage. For that… READ MORE
Interactive dashboards are fantastic for dynamic data exploration, there are scenarios where a detailed, paginated report is more appropriate. Enter Power BI Report Builder, a powerful tool for creating pixel-perfect paginated reports. What Are Paginated Reports? Paginated reports are ideal for generating operational reports that are formatted to fit well on a page. These reports… READ MORE
Introduction Financial services companies are often required to submit detailed reports to regulators, encompassing everything from financial statements to risk assessments. These reports must be accurate, timely, and in compliance with specific regulatory standards. Microsoft Power BI enables organizations to create dynamic reports, pulling data from various sources. However, the challenge lies in ensuring that… READ MORE
The introduction of the DAX query view (official blogpost) and the new INFO DAX functions (official blogpost) gives us some very possibilities to update our measures without using the formula bar. We can for instance create a query that shows all the measures that has an error message like this This will extract all my… READ MORE
Getting to grips with Visual Calculations Webinar Description: Visual Calculations are a new feature that make life easier for the citizen and pro developer alike. In this session we’ll discuss how and where they should be used, and their limitations. Benefits of attending the webinar Understand what visual calcs are and whether you should use them.… READ MORE
Introducing Power BI in one slide, one hour, and one demo! Welcome to an immersive webinar experience led by renowned analytics expert, Ben Howard, MVP as he guides you through the essential functionalities of Power BI. In this session, we delve deep into the intricate world of data analytics, dissecting each aspect of Power BI… READ MORE
Last week I found a nice little hack that enables us to create a dynamic slicer with one or more levels and let the user pick the different levels in the slicer. This has been very useful in one of our solutions for our clients where it can limit the number of slicers needed in… READ MORE
Introduction You can run Python scripts directly in Power BI Desktop and import the resulting datasets into a Power BI Desktop data model. From this model, you can create reports and share them on the Power BI service. Now, users can seamlessly execute Python scripts directly within Power BI, tapping into a vast array of… READ MORE
Not a member? Sign up here to access all content. Download Chapter 4 – Getting Data from Various Sources. This chapter discusses getting data from various sources and describes some known challenges and common pitfalls in getting data from some sources. We also discuss data source certification and different connection modes to various data sources.… READ MORE
