rss.livelink.threads-in-node

Power BI Report Builder - Total not totaling correctly.

HG_16159 — Wed, 16 Sep 2026 22:12:51 GMT

I am building a report in Report builder and am having difficulty getting the total to calculate correctly. I have four parameters (user name, start date, end date, and activity grouping) acting on the single dataset this report is drawing on. It is displaying the correct Activities and hours associated with each Activity for that Date; I'm just looking to sum those hours for each date. I added a Total row by right clicking on the ActivityGroup in the Row Groups panel > Add Total > After. It popped up as a row with "Total" in one column and nothing else. Then, I added in the Value: =SUM(Fields!Count.Value)

I'm assuming this is related to how I've set up my groups or expression. Suggestions welcome; this is my first paginated report.

Thank you.

Building Self-Healing Data Pipelines

ipkus — Wed, 16 Sep 2026 21:34:37 GMT

This article shares practical examples on building self healing piplelines and data quality. Do take a read and share your inputs.

https://medium.com/@rishabh.gulati_94109/ms-fabric-building-self-healing-data-ecosystems-67a7e83c5380

Will the current "invoke pipeline" activity be fixed?

alloowishus — Wed, 16 Sep 2026 20:34:41 GMT

I found out on google that the new invoke pipelines can suppress failures from child invoke pipelines. I have experience this firsthand. Will fabric fix this problem in the new activity before retiring the legacy one? It is much more elegant to capture the error output of a master pipeline than to capture all the individual failures of the child pipelines.

Personal Bookmarks require browser refresh to work or be created

saul009 — Wed, 16 Sep 2026 20:22:38 GMT

Hi everyone,

We're experiencing an unusual issue with personal bookmarks in Power BI Service, and I'm wondering if anyone else has encountered something similar.

Environment:

* Power BI Apps containing multiple reports.

* Issue occurs in both Power BI Premium and Microsoft Fabric environments.

* Reproduced in multiple browsers, including Edge and Chrome.

* This behavior is relatively new. Our users previously worked with personal bookmarks without encountering these problems.

Issue 1: Creating personal bookmarks

Users are sometimes unable to create a personal bookmark until they refresh their browser.

After refreshing, bookmark creation works normally. However, when they navigate to another report within the same Power BI App, they may need to refresh the browser again before they can create a bookmark in that report.

Issue 2: Existing personal bookmarks stop responding

When users return to a report where they previously created personal bookmarks, those bookmarks are still visible in the bookmark menu.

However, clicking a bookmark does nothing. There is no error message, and the saved report state is not restored.

Refreshing the browser immediately resolves the issue, and the same bookmark works correctly without needing to be recreated.

What we've observed:

* Refreshing the browser resolves the problem.

* Using the refresh option in Power BI also appears to resolve it.

* Clearing the browser cache can also resolve it.

* The issue seems particularly noticeable when navigating between different reports within the same App.

* The problem occurs in both our Premium and Fabric environments.

Questions:

1. Has anyone experienced similar behavior recently?

2. Could this be related to how Power BI Service manages report sessions or cached state when navigating between reports within an App?

3. Is there a known issue, permanent fix, or recommended workaround that doesn't require users to refresh the browser every time they switch reports?

Since refreshing resolves the issue immediately, it doesn't appear that the bookmarks themselves are permanently corrupted.

Any insights or suggestions would be greatly appreciated.

Thank you!

Current Power BI Desktop Version: 2.157.879.0 (64-bit, August 2026).

Issue first observed: Approximately two weeks ago (early September 2026).

Navigate Between Multiple Power BI Report Server Reports Inside Power BI Mobile App

Mohmmadabdr — Wed, 16 Sep 2026 20:16:57 GMT

Hello everyone,

We are using Power BI Mobile with an on-premises Power BI Report Server.

We have multiple Power BI reports, and we would like users to navigate from one report to another using buttons inside the reports.

For example:

Report 1 → Report 2 → Report 3

Our goal is to keep the navigation inside the Power BI Mobile app.

Currently, when we use the normal Power BI Report Server report URL in a button, the link may open through the mobile web browser instead of opening the target report directly inside the Power BI Mobile app.

Is there an officially supported way to navigate between different Power BI Report Server reports while staying inside the Power BI Mobile app?

For example, is there a supported deep link, URL format, or another navigation method specifically for on-premises Power BI Report Server?

Please note that we are using Power BI Report Server (on-premises), not the Power BI Service.

Thank you for your help.

Navigate Between Multiple Power BI Report Server Reports Inside Power BI Mobile App

Mohmmadabdr — Wed, 16 Sep 2026 20:15:41 GMT

Hello everyone,

We are using Power BI Mobile with an on-premises Power BI Report Server.

We have multiple Power BI reports, and we would like users to navigate from one report to another using buttons inside the reports.

For example:

Report 1 → Report 2 → Report 3

Our goal is to keep the navigation inside the Power BI Mobile app.

Is there an officially supported way to navigate between different Power BI Report Server reports while staying inside the Power BI Mobile app?

For example, is there a supported deep link, URL format, or another navigation method specifically for on-premises Power BI Report Server?

Please note that we are using Power BI Report Server (on-premises), not the Power BI Service.

Thank you for your help.

Power BI Mobile – “An unexpected error occurred” when opening reports from Power BI Report Server

Mohmmadabdr — Wed, 16 Sep 2026 20:09:10 GMT

Hello,

We are experiencing an intermittent issue with the Power BI Mobile app connected to our on-premises Power BI Report Server.

When opening a report in the Power BI Mobile app, the following message sometimes appears:

“An unexpected error occurred. Please try again later.”

After pressing “GOT IT”, the report opens and works normally.

The issue is intermittent. Sometimes the same report can be opened several times without any error, while opening another report may show the error. After closing and reopening the report, it may work normally without displaying the message again.

The same reports work normally through a web browser, and the issue appears to occur only when using the Power BI Mobile app.

I will attach screenshots showing the error message.

Has anyone experienced the same issue with Power BI Mobile and Power BI Report Server?

Is this a known issue, and is there any recommended solution or configuration change?

Thank you.

Why are Calculation Groups so hard to modify?

AaronReasoner — Wed, 16 Sep 2026 19:45:37 GMT

Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. When I want to make updates to the DAX, it turns into a mining project to figure out where to go. I'm just not sure why this can't be more of a commonsense setup or layout. I should be able to edit the DAX just as easily as a measure, parameter or data table.

Dataflow Gen2 vs Copy Job vs Pipeline: Choosing by Workload, Not by Habit

FarhanJeelani — Wed, 16 Sep 2026 19:35:15 GMT

Every Fabric team has a default tool. People who came from Azure Data Factory build a pipeline for everything. Power BI people open Dataflow Gen2 for everything. Newer teams might put every table into a Copy Job because the wizard is quick.

Each tool does its own job very well. Problems start when it gets used for another tool's job: pipelines full of hand-built watermark logic, dataflows used only to copy tables, and Copy Jobs expected to handle transformations they were never built for.

This post gives you a simple way to pick the right tool based on what the workload needs.

One sentence each

Copy Job moves data from A to B, including incremental loads, with as little setup as possible.

Dataflow Gen2 shapes data. It cleans, merges, reshapes and applies business rules using Power Query.

Pipeline coordinates work. It runs steps in order, handles dependencies and failures, and ties everything together.

If you remember only one thing, remember this: Copy Job moves, Dataflow shapes, Pipeline orchestrates.

Start with three questions about the workload

Ask these before you open any editor.

Am I moving data or changing it?
If the data arrives at the destination looking mostly like the source, with only column mapping or type changes, you are moving data. If you are joining, deduplicating, deriving columns or applying business logic, you are transforming it.
How does the source change?
A one-time or full reload is a different problem from an ongoing incremental sync. Incremental loads based on change data capture (CDC) are different again.
How many steps depend on each other?
A single load on a schedule is one thing. "Load these, then validate, then transform, then run a stored procedure, then alert someone if it fails" is a workflow.

Your answers usually point clearly to one tool.

Copy Job: when the job is data movement

Copy Job is the newest of the three and the one most often overlooked by teams stuck in old habits. Microsoft's decision guide lists its main scenarios as incremental copy and replication (both watermark-based and native CDC), data lake and storage migration, medallion ingestion, and out-of-the-box multi-table copy. Microsoft Learn

The incremental support is the main reason to use it. In a pipeline, the Copy activity handles incremental copy through pipeline expressions and control tables, and only with watermarks. That means you build and maintain the control table, the lookup, the parameterized query and the watermark update yourself. Copy Job does this for you. Microsoft Learn

Choose Copy Job when:

You need to ingest many tables from a database into a lakehouse or warehouse.
You want an initial full load followed by incremental updates, and you don't want to build watermark logic.
The source supports CDC and you want inserts and updates merged into the destination automatically.
The destination is outside Fabric. Copy Job supports 40+ destination connectors. Microsoft Learn

Microsoft's own example fits this well: an analyst who needs multi-table selection across regional SQL Server instances, a bulk initial load, and then CDC-based incremental merges picks Copy Job because it supports both watermark-based and native CDC incremental copying through a wizard, and automatically detects CDC-enabled tables. Microsoft Learn

Don't choose Copy Job when:

You need real transformation. Its transformation support is rated low, and that is intentional. Microsoft Learn
The load is one step in a larger workflow with conditions, retries and downstream dependencies. That belongs in a pipeline.

Dataflow Gen2: when the job is shaping data

Dataflow Gen2 is Power Query running at Fabric scale. It is the right tool when the value lies in the transformation logic. It offers 170+ built-in connectors, 300+ transformation functions in a visual interface, and data profiling tools for checking data quality. Microsoft Learn

A common complaint is that dataflows are slow for large volumes. That used to be a fair criticism, but Fabric has added several performance features aimed at specific workloads:

Fast Copy is for direct, high-throughput copies from a supported source with no transformations. It uses the same backend as the pipeline Copy activity. microsoft microsoft
Modern Evaluator helps when you are shaping data from connectors that don't fold, or only partly fold. microsoft
Partitioned Compute is for large, partitioned or multi-file datasets that can be processed in parallel. microsoft
Staging lets you land raw data first and transform it afterwards (ELT), so ingestion and transformation don't compete in one pass. microsoft

Choose Dataflow Gen2 when:

Business logic is the main work: cleansing, standardizing codes, merging sources, calculated columns.
The people who own the logic know Power Query and would struggle to maintain Spark or SQL.
You are combining files, APIs, SharePoint lists and databases into one clean dataset.
You want visual data profiling while you build.

Don't choose Dataflow Gen2 when:

You are only copying tables. Fast Copy makes this workable, but Copy Job is simpler, gives you incremental loads without extra work, and has less to maintain.
Your destination isn't supported. Dataflow Gen2 lists around 7+ destination connectors, compared with 40+ for the copy tools. Microsoft Learn
The transformations are very complex or code-heavy. At that point a notebook is usually the better choice.

Pipeline: when the job is coordination

A pipeline is not mainly a data movement tool. It is the orchestrator. Microsoft describes it as low-code orchestration that groups several activities together to complete a task. The Copy activity inside it is powerful, and it remains a strong option for very large migrations. The guide describes it as the best low-code choice for moving petabytes of data into lakehouses and warehouses, either ad hoc or on a schedule. Microsoft Learn Microsoft Learn

The real reason to use a pipeline is the control flow: dependencies, branching, retries, failure handling, parameters, and calling other items.

Choose a pipeline when:

Several steps must run in a set order, where step B only runs if step A succeeds.
You need logic such as If/Else, ForEach over a metadata list, or waiting on an external event.
You are combining different item types, such as a Copy Job, a dataflow, a notebook, a stored procedure and a web call.
You need error handling and notifications around the whole process.
You are doing a large, custom migration where you want detailed control over the Copy activity.

Microsoft's scenario for pipelines describes a workflow that runs stored procedures, calls web APIs, moves files and executes other pipelines. That is orchestration, not simple ingestion. Microsoft Learn

Don't choose a pipeline when:

It would contain a single activity that just runs one dataflow on a schedule. Dataflows can be scheduled on their own.
You would be rebuilding incremental loading by hand when Copy Job already supports your source.

Side-by-side

	Copy Job	Dataflow Gen2	Pipeline
Main job	Move and replicate	Transform and shape	Orchestrate
Incremental loads	Built in (watermark and CDC)	Possible, but not its strength	Manual (watermark and control tables)
Transformation	Low	High	None itself (calls other items)
Destinations	40+	~7+	Depends on activities
Authoring	Wizard	Power Query	Visual canvas and expressions
Best owner	Data integrator, analyst	Analyst, data engineer	Data engineer
Warning sign you picked wrong	Adding transformation workarounds	Dataflow has no transformation steps	Pipeline has one activity

Common mistakes that come from habit

The "everything is a pipeline" team. Every source table gets a Lookup, a ForEach, a parameterized Copy activity and a stored procedure to update the watermark. It works, but you now maintain a small custom framework that Copy Job gives you ready-made. Keep the pipeline and let it call the simpler pieces.

The "everything is a dataflow" team. Dataflows with forty queries that just select a table and load it. Move the raw ingestion to Copy Job and keep dataflows for the layer where logic actually happens.

The "Copy Job does it all" team. Trying to handle business rules with column mappings, then adding SQL views downstream to fix what should have been transformed properly. Once logic appears, add a Dataflow Gen2 or a notebook.

The single-activity pipeline. A pipeline whose only purpose is to run one item on a schedule adds a layer to monitor without adding control. Use the item's own schedule until you really need dependencies.

The pattern that usually wins: use all three, each for its own job

For a typical medallion architecture, the tools fit together naturally:

Bronze with Copy Job. Ingest source tables with built-in incremental or CDC loads. No custom watermark logic.
Silver and Gold with Dataflow Gen2 (or notebooks for heavy, code-first logic). Apply cleansing, conformance and business rules where they are visible and easy to maintain.
Pipeline around everything. Run ingestion, then transformation only if ingestion succeeded, then refresh or post-processing steps, and send an alert if anything fails.

Each tool does what it is best at, and each is simpler because it isn't doing another tool's job.

A 30-second decision checklist

No transformation, and data must stay in sync over time? → Copy Job
One-off or very large custom migration needing fine control? → Copy activity in a pipeline
Transformation logic is the main work, and owners know Power Query? → Dataflow Gen2
Complex, code-first transformation at scale? → Notebook
Multiple steps, dependencies, branching or error handling? → Pipeline, calling the tools above

Closing thought

The right question isn't "which tool do we use?" It is "what does this workload need?" Movement, shaping and coordination are three different problems, and Fabric gives you a dedicated tool for each. Teams that choose by workload build less custom plumbing, find problems faster, and hand solutions over more easily, because each piece does one clear job.

Next time you start a new load, answer the three questions first, then pick the tool.

Types of BI Reports

powerbiexpert22 — Wed, 16 Sep 2026 19:29:15 GMT

what are types of BI reports available , example master detail etc

Dynamic Show/Hide of Legend Images Based on Slicer Selection (Native Power BI Only)

DrRegiste — Wed, 16 Sep 2026 18:49:33 GMT

Hi everyone,

I'm trying to implement a dynamic legend in Power BI based on the selected indicator in a slicer, and I'd like to know if there is a native Power BI solution for this.

Current setup

I have:

A slicer based on Topic[INDICATOR_FR]

A data table OLN_Combined

A field OLN_Combined[IND_INTE] that determines which legend should be displayed

The value of IND_INTE can be:

1 or -1

Business rule

When the selected indicator has:

IND_INTE = 1 or -1

Display Legend 1

Legend 1 contains:

Red = Similar

Blue = Better

Green = Worse

When the selected indicator has:

IND_INTE = 0

Display Legend 2

Legend 2 contains:

Red = Similar

Yellow = Different

What I've tried

Option 1: Shapes / Images in the Selection Pane

I inserted both images using Insert > Image and grouped them in the Selection Pane.

However, I cannot find any way to conditionally control the visibility of these objects using a DAX measure. The available formatting options only include things like:

Background

Border

Shadow

There doesn't appear to be any conditional visibility setting.

Option 2: Buttons containing the images

I also considered using buttons with the images as backgrounds, but I couldn't find a way to dynamically show/hide buttons based on a measure either.

Option 3: Image URL table

I created a table containing the image URLs and categorized the field as Image URL.

This works in a Table visual, and the correct image can be filtered using a measure such as:

ShowImage =

VAR SelectedType =IF(SELECTEDVALUE(OLN_Combined[IND_INTE]) IN { -1, 1 },1,0)

RETURN

IF(MAX(Legends[TypeLegend]) = SelectedType,1,0)

However:

The image is displayed inside a Table visual.

Styling and sizing options are limited.

Ideally, I would like the image to behave like a regular image object on the canvas.

My question

Is there a way, using native Power BI only (no custom visuals), to:

Dynamically show/hide image objects based on a slicer selection and a DAX measure?

Dynamically switch between two image files based on a measure?

Display an Image URL as a standalone image visual (not inside a Table or Matrix)?

If not, what is the recommended native Power BI approach for implementing dynamic legends like this?

Thanks in advance!

Microsoft Frontier Townhall Series: Transforming AI Pilots to Business Impact

Riya99 — Wed, 16 Sep 2026 17:56:03 GMT

Join us for a live executive Townhall focused on what it takes to move beyond isolated AI experiments and build structured adoption, workforce readiness, governed usage, and measurable outcomes across the organization.

LIVE ON MICROSOFT TEAMS | EXECUTIVE TOWNHALL

DATE: Wednesday, September 30, 2026
TIME: 12:00 PM EDT
REGISTER HERE

WHY JOIN?

Get a leadership-level perspective on the challenges that prevent AI initiatives from scaling. Explore practical ways to align people, processes, technology, and governance while creating a clear path from AI access to everyday workforce adoption and business value.

WHAT WE’LL DISCUSS

The gap between AI usage and measurable business impact
Why AI pilots often remain isolated instead of scaling
Aligning people, processes, platforms, and governance
Building a practical 90-day AI adoption path
Measuring workforce adoption and business outcomes
Leadership priorities for scaling AI across the organization
Live Q&A and leadership takeaways

MOVE FROM AI PILOTS TO BUSINESS IMPACT

AI experimentation is only the starting point. Discover the leadership priorities, adoption strategies, and organizational practices needed to turn AI initiatives into measurable business outcomes.

REGISTER NOW, See you in the Townhall! 😊

Month on Month difference table visual that's sortable

OffColour1972 — Wed, 16 Sep 2026 17:53:55 GMT

Newbie here so bear with me.
I want to create a visual like this

I've done it using a matrix but only the total column is sortable and I need it to be sortable on all columns.
Carrying on with the example, the raw data would have multiple entries each day for each breed of each species.

Any ideas?

Using LookUpValue

greenda4 — Wed, 16 Sep 2026 17:53:13 GMT

Hi,

I created a calculated column and trying to use the LookUpValue function and am receiving the following error

Underlying Error: DataViewMappingError_ConditionNotHierarchicallyRelated

Activity ID: 77181316-2e02-44ea-b104-201ac8d72366

Also, I am getting an error on my visual saying "You are using fields that don't have a supported set of relationships". Not seeing the issue as I have used this LookUpValue function before.

Data Factory definition

db042190 — Wed, 16 Sep 2026 17:52:16 GMT

Hi, as i set up a data movement (etl/elt not versioning) pipeline in fabric, i become more aware of definitions. Am i in "data factory" when adding such a pipeline to my fabric ws or is the notion of data factory more specific to components like data flow gen2 or is data factory none of these things?

E-Commerce Sales Analysis

FarhanJeelani — Wed, 16 Sep 2026 17:47:01 GMT

I've been building an e-commerce analytics report in Power BI covering 48,000 transactions, 4,000 customers and 101 software products (Apr 2024 – Oct 2025). It now has five pages: Executive Summary, Customer Loyalty, Revenue Drivers, Customer Health & Retention, and Refunds & Promotions.

Some of the insights the data surfaced:

Annual plans drive the business. They're 49% of orders but 88% of revenue, and each annual order is worth 10× a monthly one.
Big deals matter most. Orders of 10+ seats are 29% of volume but 70% of revenue.
Revenue is concentrated. 38 of 101 products generate 80% of revenue.
Retention is strong. About 85% of customers keep buying each quarter, but new customer acquisition almost stopped in 2025.
There's a clear win-back list. 492 high-value customers have gone quiet, and together they hold $5.9M of lifetime revenue.
Over half of refunds are preventable. 56% of refunded revenue came from billing errors and duplicate orders.
Promo codes are leaking. Welcome codes were reused on ~5,000 repeat orders ($319K in discounts), and 89% of Black Friday codes were redeemed outside Nov–Dec.

What I used:

DAX for RFM segmentation, cohort retention, like-for-like YoY and Pareto analysis
Deneb (Vega-Lite) for custom visuals: Pareto chart, cohort heatmap, dumbbell chart, refund hotspot matrix
HTML Content visuals for KPI tiles with sparklines and dynamic insight cards
SVG measures to put data bars and bullet charts inside tables
A consistent custom theme, background and typography across every page

Lesson learned: auditing the model before adding visuals paid off. It caught a discount measure totaling $61.9B instead of $1.26M, discount rates above 100%, and tax counted twice in gross revenue.

Feedback welcome!

#PowerBI #DataAnalytics #DAX #Deneb #DataVisualization #Ecommerce #BusinessIntelligence

Advice on number of medallion layers in fabric pipeline

db042190 — Wed, 16 Sep 2026 17:46:10 GMT

Hi , in the prototype im setting up, my fabric pipeline lands the rawest data in the bronze layer and should soon land curated data in the silver using meta data from json to map raw column names to target column names.

i was hoping to take advantage in silver of 1) data typing when target is a table 2) other very common hoops like dealing with duplicates 3) rollback features available in notebooks, i think notebook uses a different term.

As i move forward, i'm noticing that the api's (off the shelf from sap in this case) im using in the bronze layer sometimes wrap/append their own weird things around/to column values...in this case the word "date" with the date value and possibly other non date related characters and possibly a special date format.

I dont want to couple erp specific transform logic (like this date parsing) with more cookie cutter transforms i had planned for the notebook in the silver layer. I think i'd rather add another layer maybe with a metal more valuable than bronze but less valuable than silver, eg copper. Any thoughts, i mean on having 4 layers in a medallion architecture, not the choice of copper?

notebookutils.fs.cp() cannot copy from Lakehouse shortcut to Files in Python notebook

svencken — Wed, 16 Sep 2026 17:39:56 GMT

I've been playing around with notebookutils.fs.cp() and notebookutils.fs.fastcp() in Fabric Python 3.12 notebooks.

This function seems to be unable to copy a file (e.g. PDF) from a SharePoint folder behind a Lakehouse shortcut to a directory in the Lakehouse Files. This produces a AzCopyFailedException.

Somewhat strangely, it is possible to use fs.cp() and fs.fastcp() to copy files from the shortcut to local file storage in the notebook environment and to then copy from this local file storage to the Lakehouse Files.

Has anyone come across a similar issue?

Feature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures

Murtaza_Ghafoor — Wed, 16 Sep 2026 17:07:54 GMT

Problem Statement:

In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to that table as well.

In large or complex semantic models, measures are frequently moved or organized under different tables. As a result, developers can easily delete a table without realizing that critical DAX measures are hidden inside it. Once deleted, those calculations are lost, which breaks visual elements across the report and wastes time spent rewriting DAX code.

Proposed Solution

Power BI should display a clear warning dialog whenever a user tries to delete a table that contains one or more measures.

The pop-up should:

Warn the user that measures will be removed along with the table.

Show the total count of measures affected.

List the specific measure names so the user can double-check before confirming.

Example Mockup:

⚠️ Delete Table?

The table "Sales" contains 8 measures. Deleting this table will permanently delete these measures from your model:

Total Sales
Gross Margin
Sales YTD
Sales LY
Average Sales
(and 3 more)
[Cancel] [Delete Table & Measures]

Key Benefits

Prevents Data Loss: Stops developers from accidentally deleting core business logic and complex DAX formulas.

Saves Troubleshooting Time: Reduces hours spent tracking down why visual cards or charts suddenly broke after a table cleanup.

Improves Developer Safety: Gives beginners and experienced developers peace of mind when cleaning up complex semantic models.

Provides Better Visibility: Makes model management transparent by explicitly showing what dependencies exist before an action is completed.

Please vote for this idea and share it with others so the Power BI team considers adding this feature in a future update rollout !

Post is taken down after ~ 1 minute.

dcrow5378 — Wed, 16 Sep 2026 16:40:46 GMT

I have a question about Power BI desktop canvas default layout that has somehow gotten changed. Every time I post my question it is taken down within about a minute.