Power BI

We are excited to announce the preview of the OPENROWSET function in the Fabric Data Warehouse and SQL endpoint for Lakehouse. This powerful function allows you to read the content of external files stored in Azure Data Lake Storage and Azure Blob Storage without the need to ingest them into the Data Warehouse. With the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-openrowset-function-public-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric OPENROWSET function (Preview)”</span></a>

Last week I was running a post-conference (postcon) workshop at Fabric February in Oslo. To have a successful postcon, workspaces were needed for all attendees of the workshop. In these workspaces …

Data workspace, the ERD data experience with Copilot is now generally available in 9 languages supporting solution and model-driven app.

This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Have you ever wondered what the subtle difference between ALL and

Microsoft Power Apps announces preview of ability to customize in-app chat with Copilot Studio.

More Power Fx formula reuse! User defined functions can now call behavior functions with side effects and be chained. User defined types enable passing records and tables in and out of user defined functions and can type JSON and untyped objects. And enhanced component properties move to preview.

The plan designer is now available for preview for makers worldwide! The plan designer can help you transform a simple business requirement into a complete, end-to-end low-code solution in minutes!

We’re excited to tell you more about org apps, now in public preview. Fabric org apps are Power BI workspace apps rebuilt for Fabric as a new item type. With org apps as items, you can create multiple org apps per workspace. And you work with org apps the way you would any other item type – from creating a new org app, saving changes, managing access, to sharing the org app – all the things you find familiar and easy about managing other items, such as reports, will be familiar with org apps as items.

Microsoft Ignite 2024 is currently taking place in Chicago from November 19th to 21st. As always, the Data and AI community is eagerly anticipating the latest announcements from Microsoft. With FabCon Europe having taken place less than two months ago, there was some scepticism about Microsoft’s ability to unveil any major new Fabric features. However, they still had a couple of aces up their sleeve, ready to be revealed at just the right moment.

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline ...), you are also the owner of the item. There has been an outstanding issue in Microsoft Fabric, where if a user's account was deactivated, other users could no longer access the item. Whoopsies. When a c

Last year we announced a sneak peak of a migration assistant designed to accelerate the migration of SQL Server, Synapse dedicated SQL pools, and other warehouses to the Fabric Data Warehouse. This tool enables users to migrate the code and data from the source database, automatically converting the source schema and code to Fabric Data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/private-preview-of-migration-assistant-for-fabric-datawarehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “Private Preview of Migration assistant for Fabric Data Warehouse”</span></a>

We’ve got a lot of exciting updates this month. To name a few, NotebookUtils session management utilities, Enhancing COPY INTO operations with Granular Permissions in Data Warehouse, Application Lifecycle Management (ALM) and Fabric REST APIs. Keep reading to hear about everything we have in store for you this month. Microsoft Fabric Community Conference 2025 After … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-january-2025-update/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric January 2025 update”</span></a>

Use LLMs like gemini-1.5-flash-002 with Microsoft Fabric updates to convert unstructured data into structured JSON

Turning off relationship columns can improve report performance slightly

Stop Power BI sending unnecessary SQL queries when using hybrid tables

The maximum value this property can be set to in Premium has been increased

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,

Measure how well a column is compressed in Power BI

How to get data from Power BI into Excel and use Excel's Python integration to analyse it

We are excited to announce the Public Preview release of our new Power Query SDK for Visual Studio Code!

This blog post shows how to use a Power BI DAX query to extract data and then email it out to users using Power Automate

Defining different formats for values and totals in Power BI can be achieved with the use of a calculation group which will reuse the original format string.

One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and la…

Using Tabular Editor with Power BI, I show how to create a group with all the required values even if they are not in your dataset!

This week it just happened that two of my consulting clients needed a date dimension table so I started revising my base Power Query template to make sure it was ready to share. After I improved my…

If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your …

After last week’s post on measuring Power Query CPU usage during dataset refresh, someone asked an obvious question that I should have addressed: does using a gateway change anything? After a…

This content applies to: Power Query Online One of the most powerful capabilities of Power Query and the M Language is Query Folding (also referred to as query delegation, and predicate push-down). Query Folding allows the Power Query Mashup Engine to push the transformations expressed in an M (mashup) query to the data source, in […]

Power BI has two fundamental ways of working with data: Import mode and DirectQuery mode. In Import mode the data for your reports is…

Recently I collaborated with a number of people from Microsoft and Snowflake to write a blog post on best practices for using Power BI in DirectQuery mode on Snowflake. You can read it here: It bui…