Power BI

Scenario:  In many cases, when we import data into Power BI, Power Query will automatically add suffixes if there are identical column names. However, even if there are multiple duplicate column names in the table, it will add them in numerical order without recognizing the fields and adding them ba...

Introduction Cbind is a function in R that allows you to bind columns / vectors or tables, not by joining them using a column, but by adding the column to the table in the existing order.   Solution There are use cases where we would like to use this function in Power Query as well. For example when...

Recently I wrote about things you can’t do on the Power platform when querying an on-premises SQL database. Specifically, I wanted to recreate views in a database that gets wiped and recreate…

Data Validation with Power BI is not impossible but messy. Here a script and a couple of calculation groups are used to streamline the process.

Best practices for designing and developing complex dataflows

Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. Sometimes when you’…

When migrating processes you need to compare the outputs thoroughly. Power Query is a great tool to build such comparisons as you can refresh from the source.

If we want to make a dynamic disposition of fields in a matrix and give the user the possibility to select the order in which he can display the fields in rows or columns, we can use the Field parameters feature to achieve this goal. Here are the steps to configure it:

If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calc

I still get a lot of questions from various Power BI developers about table storage modes and how table storage modes affect an entire model’s type. Here is a post to summarize all table storage mo…

I have been reading a lot of good feedback of the Power BI May 2022 update especially and the introduction of field parameters. Do not want to go into details what it is, because the official blog post and video gives a good explanation. I would like to highlight this post from Chris Webb's about

You want to merge multiple files with transactional data. The files are saved with the month name, yet contain no date records in the file. Here's how.

We are thrilled to announce the launch of Fabric Copilot capacity, a new billing feature designed to enhance your experience with Microsoft Fabric. This new capability allows you to leverage the full potential of AI in your organization by simplifying the ability to enable access to Copilot within Fabric. What is a Fabric Copilot capacity? … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/17673/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Fabric Copilot capacity: Democratizing AI usage in Microsoft Fabric”</span></a>

I compared which Microsoft Fabric workload uses the least amount of Capacity Units when loading data from On-Premises SQL Server to a Lakehouse.

Use the Smart Narrative visual to summarise text data

With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to switch out an image in a report. Maybe you ne…

Update for R/Py visuals in PBI

Use Semantic Link labs to get the sizes of all columns touched by a DAX query

The October 2024 Power BI update introduces an inconspicuous yet significant preview feature: Value Filter Behavior. This feature is activated by setting a new model-level property, ValueFilterBeha…

Learn more on how to automate the migration of your Power BI capacities to Microsoft Fabric.

Welcome to the Power Apps monthly feature update! We will use this blog to share what's new in Power Apps. A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we're excited to shared a simplified approach to writing Power Fx with Copilot, Performance improvements to the Canvas designer, Studio visual updates, and smart paste for model driven apps!

Using a Microsoft Fabric Notebook to read from a Lakehouse A in Workspace A and write to Lakehouse B in Workspace B.

This blog post shows you how to use #MicrosoftFabric AI Skills, #MSFTCopilot and #MicrosoftTeams to answer questions on your data!

The Fabric notebook version history feature has launched! This new feature is designed to significantly improve your experience in developing and managing notebooks by providing robust built-in version control capabilities.  Highlights These enhancements are part of our ongoing efforts to improve collaboration, reproducibility, and the overall user experience within Fabric. We believe these updates will … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/notebook-live-versioning/" class="more-link">Continue reading<span class="screen-reader-text"> “Notebook Live Versioning”</span></a>

Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain 3rd-party tools such as Measure Killer and Power…

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the SaaS operational database in Fabric - Fabric SQL Database

With the new pricing changes in Power BI Pro (+40%) and the need to move from Power BI Premium to Fabric capacities next year, it is a perfect timing to start strategizing how to gain higher return on investment (ROI) from your Power BI investments. As your organization explore opportunities and use-cases for AI, a […]