Power BI

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.

This article shows how to compute ratios when row-level security hides some of the data. If the percentage also includes the hidden rows in the comparison,

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…

Welcome to November and a new version of the on-premises data gateway! We are excited to announce a new feature for allowlisting which tenants can register an on-premises data gateway on a machine. Read the post to find out more.

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

In today’s ever-evolving world of data management, security is a paramount concern for organizations. We are committed to providing our customers with robust solutions that empower them to safeguard their data effectively. That’s why we are thrilled to introduce Dynamic Data Masking (DDM) for Fabric Warehouse and SQL Endpoint in Lakehouse! What is Dynamic Data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-dynamic-data-masking-for-fabric-warehouse-and-lakehouse-sql-endpoint/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing: Dynamic Data Masking for Fabric Warehouse and Lakehouse SQL Endpoint”</span></a>

Measure how well a column is compressed in Power BI

This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current”

We are excited to announce that the Data Warehouse now supports sp_rename. With sp_rename, you can rename user objects like Tables, Stored Procedures, Functions etc. Here is an example of how to use sp_rename that fixes a spelling mistake for city: When you use these features, change the schema an object belongs to or drop … p class="link-more"a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-fabric-warehouse-support-for-sp_rename/" class="more-link"Continue readingspan class="screen-reader-text" “Announcing: Fabric Warehouse support for sp_rename”/span/a

In this post, we will learn How to offline download WebView2 for Power BI Desktop if you don't have an internet connection on your current machine.