Microsoft Fabric for Power BI Developers

Create a data flow Gen 2 in Microsoft Fabric to import JSON and Excel from GitHub, transform into star schema with no-code power query, and query via SQL analytics endpoint.

Explore the dataflow generation 2 interface, add data sources through get data, view applied steps in diagram view and query settings, and learn to export templates and inspect M code.

Extend the dataflow by adding the ECB exchange rate XML as a web data source, and calculate revenue in US dollars via Power Query.

Learn dataflow gen2 data preparation: clean headers, merge product info with region mapping, create location and fact tables, compute euro and USD revenues, and publish to lake house delta table.

Explore dataflow Gen 2 in Microsoft Fabric for Power BI developers, including delta tables in the lake house, renaming within the dataflow, and append versus replace data options.

Convert uploaded Excel files to delta tables with Dataflow Gen2 in Microsoft Fabric, loading from Lakehouse and mapping headers to enable delta table querying in Power BI.

Learn how to use the append option in dataflow gen2 to add data to an existing delta table in a lakehouse, including mapping and publishing steps.

Create a new semantic model in Fabric to link dim location, dim product info, and fact transactions, defining one-to-many relationships and proper cardinality for accurate Power BI reports.

Auto create a Power BI report from a semantic model in Microsoft Fabric using AI features, customize visuals, adjust data selections, and share via workspace or app.

Create tailored Power BI reports in the service from a semantic model, adding visuals like bar charts and matrices for country and revenue, and save as manual reports.

connect power bi desktop to a semantic model in the service via a live connection, build reports from transactions data like country and revenue, then publish to a workspace.

Learn to create paginated reports directly in Microsoft Fabric without external report builders, using the semantic model, adding headers and parameters, and exporting or printing multi-page data.

Discover the main Power BI connection modes—import, direct query, and streaming—and how Direct Lake in Microsoft Fabric combines fast import speed with near real-time queries via delta tables.

Extend a Fabric semantic model by adding data sources and tables using direct query, import, or DAX calculations; configure relationships and dynamic date tables for time intelligence.

Create explicit measures in Power BI using DAX to test time intelligence with a dates table and last-month comparisons, validating a local data table within the lake house semantic model.

Extend a local model with a bridge table to fix many-to-many relationships in Power BI and build a snowflake schema including dim management, dim product, and facts transactions.

Explore task flows in the Fabric Power BI experience to map workspace items to tasks using templates or manual links, filter dependencies, and visualize data workflows.

Discover lake house connection modes in power bi desktop for microsoft fabric, including semantic models and direct lake or sql endpoint connections with import and power query.

Install and explore the Microsoft One Lake File Explorer for Windows to view metadata for your fabric workspaces, lake house, data flows, and delta tables, without downloading data.

Connect to Microsoft Fabric lake house SQL endpoint with tools like SQL Server Management Studio or Azure Data Studio using the SQL connection string and Microsoft Entra ID multi-factor authentication.

Enable semantic models to export to One Lake delta tables, then sync to a lakehouse so data is shareable across your organization and accessible via SQL, Python, or Power BI.

Set up version control for Power BI in Microsoft Fabric using Azure DevOps and a linked Git repository, then connect to your Fabric workspace.

Explore Power BI version control inside Fabric 2 by loading a Pokemon dataset from GitHub, saving as a Power BI project, and syncing with Azure DevOps using Git.

Explore methods to connect Power BI to SharePoint data, compare web, SharePoint folder, and SharePoint contents connectors, and learn when to use each for speed and access constraints.

Automatically update Power BI slicers to the latest date in your sales data by using an offset month column and a data-filtered slicer that selects the most recent month.

Power BI introduces a new DAX function, info.view, to quickly list all measures in a report as a measures documentation table created with a calculated table.

Discover how Fabric translytical flow with data function lets Power BI trigger python code and write data back.

Use a resize measure to make table columns equal width in Power BI. Turn off auto size width, enable values to rows, and apply a placeholder resizer to lock sizing.

Explore visual calculations in Power BI to accelerate DAX work and gain deeper insights, using in-visual delta calculations versus previous and easy enablement via preview features.

Use ai to generate descriptions for Power BI DAX measures and build a DAX documentation table, then enable tmdl preview and add annotations to improve documentation.

Leverage AI to optimize Power BI data models by exporting metadata with DAX Studio and sharing it with an AI expert for actionable, privacy-preserving improvements.

Leverage GenAI to optimize Power BI data preparation with Power Query, unpivot, split, and pivot steps, and validate results to ensure accurate, transparent queries.

Power BI users learn to create their own DAX functions by enabling user defined DAX functions in preview features, defining simple and parameterized functions, and using them in measures.

Copy multiple power query queries between power BI reports by selecting tables and pasting into a new file; Mac users can use the service to get SharePoint data.

Discover how the Power BI MCP server enables external agents to interact with a locally running Power BI report, create dax measures, analyze models, and generate documentation.

Learn to surface free user-defined function packages in Power BI, enable previews, and build SVG chips using the BackySVG package and image URL measures for total sales.

Discover how to disable drill down and drill up in Power BI visuals, including tooltips, by adjusting the tooltip settings and actions icon in Power BI Desktop and service.