Power BI

Using a combination of Notebook and Data Wrangler means we can transform data and write to table writing very little code by hand.

Learn about the Version and source control in Microsoft Fabric in Power BI through an example and learn how it is done in real world scenario

Microsoft Fabric is now generally available! Fabric brings together the best of Microsoft Power BI, Azure Synapse Analytics, and Azure Data Factory into a single software as a service (SAAS) platform. Fabric provides multiple workloads purpose-built for specific personas and specific tasks. Keep reading to learn about all of Fabric’s workloads! Synapse Data Warehouse We … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-workloads-are-now-generally-available/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric workloads are now generally available!”</span></a>

Welcome to the November 2023 update. We’ve got a lot of great features this month including DAX Query view, Semantic Model Scale-out, and Advanced Filtering for Paginated Reports.  There is more to explore, please continue to read on.

We are thrilled to announce the general availability of Microsoft Fabric and the public preview of Copilot in Microsoft Fabric, including the experience for Power BI. With the launch of these next-generation analytics tools, you can empower your data teams to more easily scale to meet the demand of the business. You can create a well-orchestrated data estate that minimizes data fragmentation and makes it easy for business users to find continually up-to-date, accurate data. And it even enables business users to explore and consume governed data, helping them answer questions on their own.

Learn about two key concepts that balance your Fabric capacity workload, and how to save the money along the way!

Now that we know all the pricing details for Microsoft Fabric, let's examine what are our options to save some money in the wallet

Microsoft Graph is the gateway to data and intelligence in Microsoft 365. It provides a unified model to access the tremendous amount of data in Microsoft 365 including Teams, Outlook, SharePoint, Viva Insights, and more. Use the wealth of data in Microsoft Graph to build forward looking business insights to unlock insights on customer relationships, … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-microsoft-365-data-better-together/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric + Microsoft 365 Data: Better Together “</span></a>

As mentioned in Arun’s blog post, we are thrilled to announce that Mirroring in Microsoft Fabric is coming soon. In today’s AI driven world, analytics platforms are only as good as their data. With the ever-increasing amount of data being collected in various applications, databases, and data warehouses in an enterprise, managing and ingesting data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-mirroring-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Mirroring in Microsoft Fabric”</span></a>

Earlier this year, at Microsoft Build, we introduced, in Public Preview, Microsoft Fabric, “the biggest data product announcement since SQL Server”. Today, we are announcing the General Availability of Microsoft Fabric. Arun explains in detail why we all believe Microsoft Fabric will redefine the current analytics landscape. I will focus here on what it means … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-explained-for-existing-synapse-users/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric, explained for existing Synapse users”</span></a>

Welcome to the November 2023 update.   We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic model scale-out, and many more. Continue reading for more details on our new features!    Contents Core Microsoft Fabric User API Power BI Reporting Button … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-november-2023-update/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric November 2023 update”</span></a>

In a dynamic data engineering scenario, Sam, a skilled professional, adeptly navigates urgent requests using Microsoft Fabric. Collaborating with Data Steward Lisa and leveraging OneLake, Sam streamlines data processes, creating a powerful collaboration between engineering and stewardship. With precision in Azure Data Factory and collaboration with a Data Scientist, Sam crafts a robust schema, leading to a visually appealing Power BI report.

A PowerApp to orquestrate Power BI Refreshes is not rocket science but there are plenty of details. This almost my first PowerApp I hope it helps others.

Introducing the public preview of the new Explore feature, where users have a lightweight and focused experience to explore their data. Similar to exporting and building a PivotTable in Excel, now, directly within Power BI users can quickly launch Explore to begin creating a matrix/visual pair to get the answers they need without all the distractions and extra complexity of reports.

We’re excited to announce the latest addition to Power BI’s new slicer experience – the button slicer! Crafted with your feedback and participation in mind, this innovative tool offers unparalleled customization and ease of use.

In the fast-paced world of data analytics, real-time insights are the driving force behind informed decisions and competitive advantage. The long-awaited moment is here: Real-Time Analytics in Microsoft Fabric has reached general availability (GA), unveiling a wide range of transformative features and capabilities to empower data-driven professionals across diverse domains. Whether you’re an experienced business … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-general-availability-explore-the-capabilities-of-real-time-analytics-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing General Availability: Explore the Capabilities of Real-Time Analytics in Microsoft Fabric”</span></a>

Introducing reference labels: the new feature that will rock your new cards! Now you can add custom labels to your new cards that show amazing information and comparisons.

Discover the art of creating Arrow charts in Power BI to transform your data storytelling. Learn to build, customize, and refine charts.

At Microsoft Ignite this year, we were thrilled to announce the General Availability of Eventstream. One of the exciting features is Eventstream’s real-time processing tailored for seamless integration with the KQL Database. This feature ensures a smooth experience for ingesting and transforming data streams into your KQL table. In this blog post, we’ll dive into … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/explore-data-transformation-in-eventstream-for-kql-database-integration/" class="more-link">Continue reading<span class="screen-reader-text"> “Explore Data Transformation in Eventstream for KQL Database Integration”</span></a>

I’ve been experimenting with the functionality of Microsoft Fabric and wanted to share a few things I’m using in Notebooks that help manage the wider Power BI estate. The first step to …

Great Expectations Open Source(GX OSS) is a popular Python library that provides a framework for describing and validating the acceptable state of data. It helps data engineers and data scientists ensure that their data meets specific quality standards before using it for analysis, machine learning, or other data-driven tasks. With the recent integration of Microsoft … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/semantic-link-data-validation-using-great-expectations/" class="more-link">Continue reading<span class="screen-reader-text"> “Semantic Link: Data validation using Great Expectations”</span></a>

Note: This blog is in continuation of the series of modern controls coming to canvas apps. You can find the September 2023 updates here. Recently, we also announced GA for modern, refreshed look in model apps. In October’23, we continued enhancing modern controls and theming and delivered some key enhancements as mentioned in this blog,…

I am delighted to announce the launch of the enhanced Apps page experience, now accessible to all makers. This revitalized Apps page boasts a contemporary design, accompanied by a host of impressive enhancements. Within this update, you will find a newly introduced quick interaction tile featuring Copilot, in addition to streamlined options for app creation.…

We are excited to announce that release channels can soon be set on the model-driven app or have an admin override for specific users. With this new model-driven app will soon start defaulting to monthly channel.

Why? Everyone is getting a bit excited about Microsoft Fabric, and it’s not even in GA yet. I help run the Birmingham Power BI User Group, and have been asked a few questions about the impact…

CSV files are widely used for data exchange and data ingestion into data warehouses, but they often pose challenges on performance. In accordance to a study from Microsoft Research, up to 90% of the total time spent in data ingestion occurs in parsing non-binary data such as JSON when using conventional file parsers. This is … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-improvements-to-csv-data-ingestion-in-fabric-warehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing improvements to CSV data ingestion in Synapse Data Warehouse in Microsoft Fabric”</span></a>

Microsoft Fabric is a SaaS platform that allows users to get, create, share, and visualise data using a wide set of tools. It provides a unified solution for all our data and analytics workloads, from data ingestion and transformation to data engineering, data science, data warehouse, real-time analytics, and data visualisation. In a previous blog … Continue reading Microsoft Fabric: Capacity Options and Cost Management, Part 1; The Basics