Power BI

Local AI Skills with Fabric's endpoint and Gradio to create interactive plots. Steps detailed for building your own AI Skillet app

If you’re utilizing Microsoft Fabric and notice consistently high usage—perhaps averaging 90%—or experience occasional throttling, it’s a clear indication that you’re nearing your capacity limit. T…

Blogging about Power BI, Power Platform and other things I find interesting.

Refreshing with a Data Pipeline offers more flexibility with scheduling

View refresh parallelism in one-second bins

IntroductionOverview of the NotebookWhy Use This Notebook?Getting StartedConclusion Introduction Part of the role of the Azure Data Insights & Analytics team is to test new features and provide…

For no particular reason, I recently opened a Power BI report with two fact tables, exported the model definition to TMDL, saved it as a file, and loaded it into several state-of-the-art LLMs, incl…

Use an expression to define which tables and partitions to refresh

We’re excited to announce the preview of the Fabric CI/CD Python library! Recognizing the importance of CI/CD in our success, we decided to open source our project to share with the community. As part of the Azure Data Insights & Analytics team, an internal data engineering group focused on supporting product analytics for Azure Data, we’ve been using Fabric as the backbone of our platform for the last two years. Our team is committed to maintaining and evolving this library, and we look forward to collaborating with the community to enhance its capabilities!

In today’s data-driven world, it’s important to be able to read & understand your data to enable you to gain insights on which patterns/trends you want to monitor. After a data driven decision is taken, you can understand which visualizations you want to build and which machine learning models you want to train to give … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/streamline-data-engineering-data-science-with-copilot-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Streamline Data Engineering & Data Science with Copilot in Fabric”</span></a>

This article shows how you can change the calculation of all measures in a specific folder with the INFO.VIEW function and Calculation Groups in DAX

SQL database in Fabric is currently in preview, and we are actively rolling out improvements as we progress towards general availability (GA). Your insights play a crucial role in this journey. Whether it’s challenges you’ve encountered, features you adore, or any suggestions for enhancement, we want to hear it all—the good, the bad, and the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/enhancing-sql-database-in-fabric-share-your-feedback-and-shape-the-future/" class="more-link">Continue reading<span class="screen-reader-text"> “Enhancing SQL database in Fabric: share your feedback and shape the future”</span></a>

We are pleased to announce the release of several new Admin APIs, which offer tenant administrators advanced tools for managing tenant settings, as well as tenant setting overrides at the capacity, workspace, and domain levels.   These new APIs, along with enhancements to existing APIs, represent our continued commitment to expanding Microsoft Fabric’s administrative capabilities, thereby … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/admin-api-updates-and-upcoming-definition-changes/" class="more-link">Continue reading<span class="screen-reader-text"> “Admin API updates and upcoming definition changes “</span></a>

Easily visualize targets in Power BI using Error Bars. no DAX needed. Learn how to compare actuals against targets effectively.

This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns. The A

OneLake catalog is the central hub for discovering and managing Fabric content. Whether you’re a business analyst searching for the right datasets, a data engineer managing structured and unstructured data, or a BI consumer looking for curated insights, the OneLake catalog seamlessly connects you to the right content. Enhanced exploration in OneLake Catalog OneLake catalog continues to evolve to deliver richer, … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/whats-new-in-onelake-catalog-data-governance-and-more/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new in OneLake catalog: Data governance and more”</span></a>

Partners, come join the Microsoft Fabric Catalyst program. A collaborative knowledge hub aimed at scaling technical expertise and providing partners with the right resources to drive high-impact solutions in Fabric.

In this blog post, we will cover how to build a Python application using Flask framework to connect to Fabric SQL Database and query data.

Additional Authors: Amir Jafari, Shreyas Radhakrishna, Nellie Gustafsson We’re excited to unveil significant enhancements to the AI Skill in Fabric! These updates make it easier than ever to build a powerful generative AI data agent, helping you to unlock deeper insights and streamline decision-making. With improved flexibility, intelligence, and user-friendliness, the updated AI Skill is … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/new-improvements-coming-to-the-ai-skill/" class="more-link">Continue reading<span class="screen-reader-text"> “New improvements coming to the AI Skill”</span></a>

In Fabric, you can have many different items in your Workspace. So many, that you easily get lost! Luckily there are tools at hand like Taskflows and Workspace folders. But still, it can be challen…

Building Canvas Apps in PowerApps presents a challenge. Microsoft has provided great built-in functions, but what if your App needed something other than the built-in functions? You would have to create workarounds—repeating formulas, juggling nested logic, and spending extra time managing it all. It worked, but it wasn’t ideal. Now, Microsoft is upgrading the process

Welcome to the Power Apps update! See what's new in Power Apps. A summary of product, community, and learning updates from throughout Jan.

Consider this use-case: You built a sales dashboard for hundreds of sellers in your organization. The dashboard provides them current statuses and KPIs and links to hundreds useful resources by product including sales collateral and demos. Would it be great if you could analyze the popularity of your products and sales collateral by the amount […]

This article is about how rules like “avoid pie charts” can be useful for beginners, but also unhelpful in real-world scenarios with more nuance. Instea

We are excited to announce the preview of the BULK INSERT statement in Fabric Data Warehouse, which allows you to load CSV files from Azure Data Lake Storage and Azure Blob Storage. Refer to the example of the traditional BULK INSERT statement commonly used by SQL Server or Azure SQL users to import files from … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/bulk-insert-statement-in-fabric-datawarehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “BULK INSERT in Fabric Data Warehouse (Preview)”</span></a>