New board topics in Microsoft Fabric Community

Power bi pro capacity

siddhesh2486 — Thu, 17 Sep 2026 07:42:13 GMT

Can power bi with import mode handle 20 millions rows?

OAP for MLVs cross workspace

TK12345 — Thu, 17 Sep 2026 06:46:30 GMT

Hi all,

I have a question regarding OAP implementation across multiple workspaces.

My current setup consists of three layers:

Bronze: OAP enabled

Silver: OAP enabled

Gold: OAP not enabled

In the Bronze layer, I extract all source data using specific endpoints and gateways, with the required connection rules configured. In the Silver layer, I use shortcuts to access the source lakehouses in Bronze. This works as expected.

Within Silver, I then create Materialized Lake Views (MLVs) for my entities. For example, I create a Person entity based on multiple source tables and store the result in LH_Silver. This also works correctly.

The issue occurs in the next step. On top of the Silver entity, I want to create dim_Person. The MLV reads the entity from LH_Silver, but the output should be written to LH_Gold in the Gold workspace.

When OAP is disabled on all workspaces, this cross-workspace setup works and I can successfully write the MLV to Gold. However, as soon as OAP is enabled on the Silver workspace, I can no longer write the MLV to the Gold workspace.

I've already tried several connection rules, including:

FabricMaterializedLakeView

FabricSqlEndpointMetadata

Fabric SQL Analytics Endpoint

Lakehouse

Notebook

Web V2

I've also configured an MPE for the Gold (3000) workspace, but so far none of these options have resolved the issue.

Does anyone know which connection rule, MPE, or configuration is required to allow an MLV running from an OAP-enabled Silver workspace to write to a Lakehouse in another workspace?

Ideally, I would like to keep the notebooks and MLV logic in the Silver layer rather than moving them to the Gold workspace.

Thanks in advance!

Cel 1:

%%pyspark

spark.conf.set("spark.sql.caseSensitive", "true")

workspace = spark.conf.get("trident.workspace.name")

environment = "DEV" if "DEV" in workspace else "TEST" if "TEST" in workspace else "PRD"

spark.sql(f"SET TargetEnvironment = 3000_CURATED ({environment})")

Cel 2:

CREATE OR REPLACE MATERIALIZED LAKE VIEW `${TargetEnvironment}`.LH_3000.Algemeen.dim_Persoon AS

SELECT *

FROM test.`02_entity`.Person

Secure connection to Azure DocumentDB (with MongoDB compatibility)

morten-gn — Thu, 17 Sep 2026 06:18:21 GMT

Has anyone succeeded with setting up a Managed Private Endpoint from Fabric to an Azure DocumentDB (with MongoDB compatibility).

We have other Azure services connecting to the database using private endpoints.

Documentation mentions support for connections to Azure Cosmos DB for MongoDB using this Resource ID Format:

Azure Cosmos DB for MongoDB

/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.DocumentDB/databaseAccounts/{account-name}

Our database has this resource ID format:
..../Microsoft.DocumentDB/mongoClusters/{account-name}

We can add the Managed Private Endpoint in Fabric and it will show provisioning for 2-3 minutes before failing without any error description.

Paginated Report gets stuck on "Loading report..." when parameter value is confirmed with Enter

MorelG — Thu, 17 Sep 2026 05:30:06 GMT

Hi everyone,

We have recently noticed a strange behavior with Paginated Reports and report parameters.

When a user enters a parameter value and confirms it by pressing Enter, the report starts loading but gets stuck on the "Loading report..." screen indefinitely. However, if the user enters exactly the same parameter value and instead clicks "View Report", the report loads successfully and everything works as expected.

This issue seems to have appeared only within the last few days. Previously, both methods (pressing Enter and clicking View Report) worked without any problems.

We would like to understand:

Has anyone else experienced the same issue recently?
Is this a known regression or service-related change?
Are there any official recommendations or fixes available?

Any feedback would be appreciated.

Thanks

Copy Job - Amazon S3 connector fails with region signing error on generic endpoint

Sharan_Srini99 — Thu, 17 Sep 2026 03:24:05 GMT

I'm trying to connect Fabric's Amazon S3 connector (Copy activity, pipelines) to a bucket in ap-southeast-2, using Access Key authentication.

When I create a connection with the generic regional endpoint:

https://s3.ap-southeast-2.amazonaws.com

connecting fails with:

Expression.Error: Invalid Url. The authorization header is malformed; the region 'us-east-1' is wrong; expecting 'ap-southeast-2'

I've added s3:ListAllMyBuckets, s3:ListBucket, and s3:GetBucketLocation to the IAM user, and the error persists identically.

How to decrease height of row (with image) in matrix?

JustinDoh1 — Wed, 16 Sep 2026 23:55:15 GMT

I have my PBIX file here.

I am trying to decrease the height of row in this matrix?

It is due to the image (red stop image), but I am not sure how to go about decreasing it.

The image itself is not that big, and I was expecting that, somehow, matrix would wrap to its size, but it didn't.

Without image, bottom is what I had originally.

Appreciate for help!

How to Integrate Copilot with an Existing Power BI Report for User Q&A?

manoj_0911 — Wed, 16 Sep 2026 23:22:32 GMT

Hi everyone,

I have an existing Power BI report with a semantic model containing multiple business measures, dimensions, and KPIs.

I would like to integrate Copilot in Power BI so that report users can ask natural-language questions about the report/data, for example:

“What were the total calls yesterday?”
“Show total calls by Division.”
“Which Division had the highest ASA?”
“Why did ASA increase compared to yesterday?”
“Show the trend for the last 7 days.”

My questions are:

Can Copilot in Power BI be integrated directly with an existing Power BI report/semantic model?
Can users ask questions conversationally and have Copilot answer based on the existing semantic model and its measures?
Can Copilot understand existing Power BI measures, relationships, dimensions, and business terminology?
Does Copilot respect Power BI RLS when answering user questions?
What Power BI/Fabric licensing and capacity is required for this?
Can the Copilot experience be made available inside the existing Power BI report for report consumers?
Are there any specific semantic-model preparation steps recommended before enabling Copilot?

If anyone has implemented Power BI + Copilot for an existing production report, I’d appreciate guidance on the recommended architecture and setup.

Thanks!

Switching Microsoft partners & Fabric capacity

cbarrettEM — Wed, 16 Sep 2026 23:12:12 GMT

We are switching to a different Microsoft partner for our various Microsoft subscriptions including Fabric capacity. I have been told that by doing so our current Fabric capacity will be deleted & we cant just move the subscription to a new partner for that capacity.

Does anyone have any experience with this? If that is the case, is there a migration tool we can use to copy the entire Capacity to a new one, which we already have. I have a f128 on the 'old' partner's subscription which will be closed EOY and a f64 on the 'new' partner's subscription, which I can bump to f128

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.

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!

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?