Power BI

LLM tools: Likewise, you can use LLM tools to facilitate various aspects of report development, including the creation of custom visuals in DAX (via SVG visuals), R, Python, and Deneb.

Figma and Excalidraw: general-purpose design tools that you can use to facilitate the design for anything. For models, you might use Figma (FigJam, likely) or Excalidraw to create the conceptual or logical model for your semantic model during the design There are many other tools for doing this, including Visio or even the diagram view in Tabular Editor 3.

Tabular Editor: an end-to-end development tool that you can use either together with Power BI Desktop or as an alternative. Tabular Editor is an integrated development environment specialized for working with semantic models. It is designed from the ground up, to empower semantic model developers with everything they need to build good semantic models while being efficient.

Large language models (LLMs) and other generative AI tools

Power BI Desktop tools: New features and tools in Power BI Desktop also support a variety of use cases.

Power Designer

It is important to emphasize that you do not need to use any of these tools. Rather, you typically turn to them when you have specific problems that you want to solve, or scenarios that you aim to address

Fabric Copilot and AI Capabilities available on all paid SKUs

Low-code AI tools to accelerate productivity in notebooks (Preview)

Low-code AI capabilities in Data Wrangler (Preview)

Convert natural language to code with Copilot:

Data Warehouse ALTER Table Drop Column and sp_rename column support in Fabric Warehouse (Generally Available) There are two powerful new features in Fabric Warehouse that we are happy to introduce: ALTER TABLE DROP COLUMN and SP_RENAME COLUMN. ALTER TABLE DROP COLUMN effortlessly removes unnecessary columns to streamline storage, boost performance, and improve query efficiency. Cloning a table as of a point in time & time travel to a point in time that is before the table was dropped is not supported. Dropping columns from Lakehouse tables is not a supported scenario. SP_RENAME COLUMN easily renames columns without downtime, making schema adjustments faster and reducing the risk of errors.Columns and Tables are not renamable in Lakehouse.

Migration assistant for Fabric Data Warehouse (Preview)

The Migration Assistant for Fabric Data Warehouse is now in preview. The migration experience is built natively into Fabric and enables Azure Synapse Analytics (Data Warehouse) customers to transition seamlessly to Microsoft Fabric. This new DW migration experience allows users to easily migrate both metadata and data from the source database, automatically converting the source schema to Fabric Data Warehouse, helping with data migration, and providing AI powered assistance. With integrated assessment tools and guided support, this capability simplifies migration, enabling customers to leverage Fabric’s capabilities without the complexity of traditional migrations. The Migration Assistant for Fabric Warehouse streamlines the migration process into four steps:

BULK INSERT statement (Generally Available) The BULK INSERT statement in Fabric Data Warehouse is generally available, it enables you to ingest data into a table from the specified file path:

Databases SQL database in Fabric We have several new advances to share in SQL Database within Fabric. Continuous innovation is at the heart of our development, outlined are several key enhancements.

This capability enables customers to automate, scale, integrate, and govern their SQL databases within Microsoft Fabric, using a declarative approach with Terraform. HashiCorp Terraform, an open-source tool that offers a secure, predictable, and consistent method for deploying and managing infrastructure across multiple cloud environments. This functionality extends the capabilities of Fabric through Infrastructure-as-Code (IaC).