Power BI

How sorting makes certain information easier to access

Fabric is here but what does that mean if you are using Power BI? What do you need to know and what, if anything will you need to change if you are a Power BI report designer, developer or BI solut…

I was trying some stuff out in a notebook on top of a Microsoft Fabric Lakehouse. I was wondering what some of the default values are of the configuration variables, and if there's an easy way to retrieve them all. Luckily there is. In the code, I'm using Scala because it has a nice GetAll() functio

You might know the feeling: you're writing code in a Notebook in Microsoft Fabric and suddenly you have to leave your workstation for a while. Someone ran the doorbell (you're working from home and you get some parcels delivered), or you took a coffee break with some colleagues. When you return to y

This article describes the different approaches to format your DAX measures in Power BI semantic models using format custom and dynamic format strings. Form

This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Visual calculations, introd

Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at t

This article describes the usages of Microsoft Copilot in Fabric Data Factory Dataflow Gen2 or Power Query in Power BI Service.

Carlos Barboza is experimenting with visualizing Elon Musk’s activity on Twitter. That looks really great, but I wanted to see more than just quantity; I … Read More

Playfair’s charts, from the end of the 18th century to the beginning of the 19th century utilized single-color hand-engraved copperplate printing with the following hand-staining … Read More

This blog post shows you how to successfully run a data pipeline using a notebook where the notebook is using the Sempy (Semantic-Link) python package.

Changing Power BI add-in as snapshot made easy and with more options. You can now change your live data to an image, that only people who can see the report will be able to see.

With the exciting release of Microsoft Fabric and the Fabric capacity SKUs last year, we are consolidating purchase options and retiring the Power BI Premium per capacity SKU after January 1, 2025.

Learn how to generate a business-friendly PowerBI data dictionary using OpenAI, SemanticLink, and MSFabric! In this video, we explore how to incorporate Azure OpenAI into the world of Business Inte…

In Power BI development in Microsoft Fabric, understanding and utilising source control mechanisms is crucial for efficient collaboration and version management. This blog post delves into the essential aspects of source control for Power BI. This blog also includes the recording of my session at Saudi Arabia’s Excel User Group on the 26th of August … Continue reading Microsoft Fabric: Source Control Options for Power BI Developers

I had a task to help a managed services team in monitoring multiple production datasets and reports in Power BI. These resources, accessed by thousands of users, demanded optimal performance. For this we had to streamline information gathering, implement an intuitive platform, and empower the team to explore both high-level overviews and granular query details.

The DAX windowing functions have helped me a lot in tackling complex analytical challenges. Nevertheless, I do not use them daily. This means sometimes I need time to regain the “windowing feel” again. This article will shorten the time until I’m thinking “windowing” again. Maybe it might help you as well.

Model metadata in Power BI is getting more and more accessable and there are a fair amount of tool that we can use to work with it. Report metadata on the otherhand is not easy to work with. In my previous blog post, I showed how you can use Log Analytics to improve the performance

We’re excited to announce the winners of HackTogether: The Microsoft Fabric Global AI Hack! What is #HackTogether? In this HackTogether, we had the opportunity to build innovative AI solutions with Microsoft Fabric. The event challenged over 640 registrants with prize awards for top submissions (including one grand prize that includes passes to attend the Microsoft … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-the-winners-of-hacktogether-the-microsoft-fabric-global-ai-hack/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing the winners of “HackTogether: The Microsoft Fabric Global AI Hack””</span></a>

Last month, we announced that Copilot in Fabric begins billing on March 1st, 2024, as part of your existing Power BI Premium or Fabric Capacity. Since then, we have received many questions about how to estimate the cost of using Fabric Copilot.   In this post, we will show how Fabric Copilot usage is calculated. We’ll walk … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-copilot-pricing-an-end-to-end-example-2/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Copilot Pricing: An End-to-End example “</span></a>

With the new ‘browse Azure’ functionality in Get Data, you can easily browse all your Azure resources and automatically connect to them, without going through manually setting up a connection, saving you a lot of time. Using the regular path in Get Data to create a new connection, you always need to fill in your … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/browse-azure-resources-with-get-data/" class="more-link">Continue reading<span class="screen-reader-text"> “Browse Azure resources with Get Data”</span></a>

When you have a Lakehouse or Warehouse and you want to load data into it, you can use Dataflow Gen2 as an easy, low-code way for landing your data with the right shape. You can always create a stand-alone Dataflow Gen2 and use the data destinations to load your data in any Fabric Lakehouse or … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/updates-to-default-data-destination-behavior-dataflow-gen-2/" class="more-link">Continue reading<span class="screen-reader-text"> “Updates to default data destination behavior in Dataflow Gen2”</span></a>

Fabric ISV Partner Ecosystem enables ISVs to use a streamlined solution that’s easy to connect, onboard, and operate.

When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides

Explore AI pricing models: Understand fixed vs. variable costs with examples and learn how to choose the right model.

The right title for this blog post should be “Guidelines for SQLBI content publishing”, but it would be too boring. And, at the time of writing, the mor

If you have used Spark in Azure Synapse, prepare to be pleasantly surprised with the compute experience in Microsoft Fabric as Spark compute starts a lot faster because the underlying technology ha…

Introduction OneLake can be used as a single data lake for your entire organization, it provides ease of use and helps eliminate data silos. It can also simplify security while ensuring that sensitive data is kept secure. OneLake and Fabric provide several out of the box capabilities to keep data access restricted to only those … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/building-common-data-architectures-with-onelake-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Building Common Data Architectures with OneLake in Microsoft Fabric”</span></a>

For years, CDOs have struggled to develop strong data cultures at their organizations. This article explores whether AI can solve data culture challenges for companies.