New board topics in Microsoft Fabric Community

Issue Export Summarized Data & Fields Parameter

pinellus — Mon, 14 Sep 2026 10:09:08 GMT

Since this morning, users can no longer export "Summarized data" from a matrix visual. The matrix uses three Field Parameters (on Rows, Columns and Values) to let users dynamically choose the fields to cross-tabulate. No changes were made to the report or the semantic model. The following error appears:

"Couldn't create the file. Generating the query for the Export data operation resulted in an error. Verify that the visual contains measures from more than one table, because in that case an error may occur in the data export operation."

Impact: All users of the report are affected. Export "Data with current layout" still works, so the issue is specific to the summarized-data query generation.

Expected: Summarized-data export used to work with this same visual until 11 Sep 2026.

Note: This appears to be a service-side regression in the summarized-data query generation for visuals using Field Parameters with measures from multiple tables.

Are we the only ones with this problem??

Have any of you come across this problem as well?

Refreshes happening but with warnings

ArchStanton — Mon, 14 Sep 2026 08:08:52 GMT

Hi,

My report has, until today, been refreshing with warnings:

I deleted the incidentid column from the Data Model several weeks ago because it was surplus to requirements.

Does anyone have any idea what I should do to address these warnings?

Thanks,

Refresh Failed

ArchStanton — Mon, 14 Sep 2026 08:01:14 GMT

Hi,

My reports have been refreshing every night for several years without any problems until today, this is the error message I get:

I'm not very technical and so I hope the fix is easy and straightforward, can anybody shed some light on why this has happened and how to fix it please?

Thank you!

Best Practices for Ingestion Logging and Metadata Management in Microsoft Fabric

RMori95610 — Mon, 14 Sep 2026 06:35:14 GMT

Hi Fabric Community,

We are building a data platform in Microsoft Fabric to ingest Salesforce and Marketo data into a Lakehouse.

We are currently planning to use the following medallion architecture:

Salesforce / Marketo → Bronze → Silver → Gold

Our basic approach is to keep the Bronze layer as close to the raw source data as possible, while performing transformations such as data type conversion, deduplication, JSON parsing, and upserts in the Silver layer.

For Marketo in particular, we are considering using the Bulk Extract APIs to extract data such as Leads, Activities, and Program Members as CSV files and store the raw CSV files directly in the Files area of the Bronze Lakehouse.

At the same time, since we plan to run incremental ingestion through a daily Fabric Pipeline, we are wondering whether we should separately record ingestion metadata for operational monitoring, troubleshooting, and reruns.

For example, we are considering storing information such as:

Dataset name
Pipeline Run ID / Batch ID
Extraction start and end timestamps specified in the source API
Timestamp when the data was successfully stored in Bronze
Source file name/path
Number of records ingested
Processing status (Success / Failed, etc.)

One idea is to create a separate Ingestion Log / Control Table in the Lakehouse and insert one record per dataset for each Pipeline run, for example:

run_id	dataset	extract_from	extract_to	ingested_at	record_count	status
RUN001	MarketoActivity	2026/09/13 09:00	2026/09/14 12:00	2026/09/14 12:08	15,230	Success

I would appreciate your advice on the following questions:

When implementing scheduled incremental ingestion using Fabric Pipelines, is it common or recommended to maintain a separate ingestion log/control table like this? Or are Fabric Pipeline run history, Monitoring Hub, and other built-in monitoring capabilities generally sufficient, making a separate table unnecessary?
Should technical metadata columns such as ingested_at or batch_id be added directly to the raw data in the Bronze layer? Or is it better practice to keep Bronze as an unchanged copy of the source data and manage ingestion metadata separately in a control/log table?
When storing raw CSV files directly in the Files area of a Bronze Lakehouse, as in the case of the Marketo Bulk Extract APIs, what is the recommended way to associate each file with its ingestion metadata? For example, we are considering recording the file name/path and Pipeline Run ID in the ingestion control table.
From the perspective of reruns, failure recovery, and detecting missing data, what would you recommend as the minimum metadata that should be retained?

At this point, we are not planning to maintain a separate watermark control table. For data such as Marketo Activities, we are considering using a time-based extraction window with a small overlap to reduce the risk of missing records around extraction boundaries or due to short processing/API availability delays.

If anyone has implemented a similar ingestion architecture in Microsoft Fabric, I would greatly appreciate any recommendations, best practices, or examples of how you manage ingestion metadata in practice.

Thank you in advance for your help!

Connection error while using dataflow in power bi desktop

MostVIP2023 — Mon, 14 Sep 2026 03:22:20 GMT

Hello experts,

When I try to connect the dataflow in desktop,it shows below error, would you pls advise me how to solve it?

ZigZag pattern as new Column for ID

damit230183 — Mon, 14 Sep 2026 02:26:30 GMT

Hi,

I am looking for ZigZag pattern for the report,

I have this

I would like to show table like this

Thanks

Power BI Proライセンス未保有者でも共有BIが見れる件

SB樋川幸絵 — Mon, 14 Sep 2026 01:43:46 GMT

現在組織でPower BI Proライセンスを複数所有しています。

Proライセンスを保有しているユーザー同士は作成したBIのWEB閲覧が可能だと思いますが
Proライセンスを所有していないユーザーでも一部閲覧が可能になっています。（一部のみ）
以下パターンが発生している状況ですが、原因や対策など教えてください。

①Pro保有者が部署メンバーへ作成済みBIを公開＆共有（Pro保有A、ProなしB、ProなしC）
②Pro保有AとProなしBは閲覧できた
③ProなしCは閲覧できなかった

Some NSW LGAs (Counties) not mapping

00oO0oO — Sun, 13 Sep 2026 23:28:55 GMT

I'm having trouble getting all of the NSW LGAs (counties) to work in Azure Maps

have tied Data Category to County in Table View
have made a located field - eg "Cumberland, NSW, Australia"
am using the latest version of Power Bi Desktop

The following LGAS do not work:

Cumberland
Fairfield
Orange
Unincorporated

The other 125 LGAs work fine.

I've used a shape file to get around this - but it has some other limitations.

I'd like to use the inbuilt functionality.
Would anyone know how I could solve this?

Unable to provision Fabric trial capacity

Frank_9008 — Sun, 13 Sep 2026 17:41:36 GMT

sub: Unable to provision Fabric trial capacity — tenant reports trial-capacity limit but has no trial capacity

Hello,

I’m trying to set up a Microsoft Fabric trial capacity in a new personal Entra tenant for DP-600 learning.

I can sign in to Fabric and have a Power BI trial, but starting a Fabric trial capacity fails with:

Sorry, we are unable to start trial at this time.

The Fabric Help pane then identifies the issue as:

Tenant has reached the limit for permitted free trial capabilities.

However, under Admin portal → Capacity settings → Trial, there are no existing or usable Fabric trial capacities in the tenant.

I have already checked that:

I am using a Microsoft Entra work/school-style account in my own tenant.
The tenant has a Fabric Administrator.
Users can create Fabric items is enabled.
I tried creating a Lakehouse from My workspace to trigger the Fabric trial.
The tenant only has two users and no old trial capacity is visible.

Original error details:

Activity ID: e8c8d3d2-be9a-457d-9cf9-5fbcd22f2893

Request ID: 8c749726-eea5-4256-90b3-5b524edbea37

Correlation ID: 7c58b5a3-c6fd-1916-3e8d-e3317de06609

Time: 2026-09-11 19:11:41 CDT

Cluster: wabi-us-central-b-primary-redirect.analysis.windows.net

Has anyone experienced this quota/provisioning mismatch? Is there a way to have the tenant’s Fabric trial-capacity eligibility checked or reset?

Thank you

Frank

How do I apply three different colours to all background columns and not just one at a time?

Fedup — Sun, 13 Sep 2026 15:40:53 GMT

I don't want to have to go through each GW to apply the three different colours to W D & L.

Where i can learn Power BI and Fabric as a Pro

dany000011 — Sun, 13 Sep 2026 13:08:59 GMT

Hello All,

i just want to check is there any portal any plat6form offer power bi and fabric learning in low cost and all the required information.

I know we have ms learn portal but it's max text based , I am not a fan of text based learner.

How Can i get free Microsoft tenant ID

dany000011 — Sun, 13 Sep 2026 13:05:53 GMT

Hay i am learning Power BI and fabric , i want a corporate mail id to access this portal , But how can i get any option we have .

Can any one help me with it,

Calculate YTD, PYTD and % change YTD

epang — Sun, 13 Sep 2026 09:57:51 GMT

hi,

this is my date table.

DimDate =

VAR MinYear = YEAR(MIN('Cases'[Lodged Date]))

VAR MaxYear = YEAR(MAX('Cases'[Lodged Date]))

RETURN

ADDCOLUMNS (

CALENDAR ( DATE ( MinYear, 1, 1 ), DATE ( MaxYear, 12, 31 ) ),

"Year", YEAR ( [Date] ),

"Month Number", MONTH ( [Date] ),

"Month Name", FORMAT ( [Date], "MMMM" ),

"Month Short", FORMAT ( [Date], "MMM" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"Year Month Key", INT(FORMAT([Date], "YYYYMM")),

"Day of Week Number", WEEKDAY ( [Date] ),

"Day of Week Short", FORMAT ( [Date], "ddd" )

)

my YTD count of incident cases is

YTD Serious Incidents = CALCULATE([Number of serious incident cases],DATESYTD('Cases'[Lodged Date].[Date]))

My PYTD count of incident cases is

PYTD Serious Incidents =

CALCULATE( [YTD Serious Incidents],SAMEPERIODLASTYEAR('friendly Cases'[Lodged Date].[Date]))

YTD_Cases_%_Change =

VAR CurrentRate = [YTD Serious Incidents]

VAR PriorRate = [PYTD Serious Incidents]

VAR PctChange = DIVIDE(CurrentRate - PriorRate, PriorRate, 0)

VAR Arrow = IF(PctChange > 0, "▲ ", IF(PctChange < 0, "▼ ", "")) RETURN Arrow & FORMAT(PctChange, "0.0%")

I currently use auto date intelligence. However, this gives me the full year of data, for PYTD. Is it possible to resolve this issue and get the correct YTD, PYTD and % change of YTD cases?

Thanks

Regards

what’s the most cost-effective option?

Ahmed-Elfeel — Sat, 12 Sep 2026 21:04:26 GMT

Hi everyone,

I’m currently working as a Data Analyst for a BPO company, where we still rely heavily on traditional Excel dashboards and tables to share weekly performance.

At the moment, I have to prepare and send separate reports to each Supervisor by email. We have 12 Supervisors, 3 ACMs and 1 Manager so this process is becoming quite time-consuming and repetitive.

I brought an idea to my manager about creating a Power BI dashboard that centralizes all the data in one place.

The idea is that Supervisors, ACMs, Managers, and Agents would be able to access the dashboard and see the data relevant to them, along with additional insights and interactive analysis.

For example:

Agents → only see their own performance
Supervisors → only see their assigned agents
ACMs → see the Supervisors/teams under them
Managers → see the relevant overall hierarchy

I’m planning to use Row-Level Security (RLS) to control access.

However, my main concern now is architecture and licensing cost. Since this is for a BPO account with potentially a large number of Agents giving every user an individual Power BI license could become expensive.

So I’m looking for a cost-effective architecture using Power BI.

A few questions I have:

Do I actually need Microsoft Fabric for this scenario, or can Power BI Pro handle it?
What would be the most cost-effective architecture for a large number of users with RLS?
Would Power BI Pro licenses for users be better, or would Fabric capacity make more sense as the number of viewers grows?
Since the source data is currently Excel files would you recommend keeping Excel + Power Query or moving the data into Fabric/OneLake
Is there a better architecture that would reduce both licensing and maintenance costs?

I’d really appreciate advice from anyone who has implemented a similar BPO performance dashboard with hierarchical RLS and had to deal with a large number of users.

Percentage from two measures

HMMFPUA — Sat, 12 Sep 2026 19:01:01 GMT

I have created to two measures in my measure table for the Total number of tickets created and the total number of tickets closed. I created another measure using the above mentioned measure to calculate the percentage of closed tickets. I keep zero...it should be 95%. I even used a quick measure to create the percentage measure. I have a slicer based on a fiscal datetable. Any idea why this isn't working?

Total Tickets Created % difference from Total Tickets Closed =

VAR __BASELINE_VALUE = [Total Tickets Closed]

VAR __VALUE_TO_COMPARE = [Total Tickets Created]

RETURN

IF(

NOT ISBLANK(__VALUE_TO_COMPARE),

DIVIDE(__VALUE_TO_COMPARE, __BASELINE_VALUE)

)

Thank you

Date Slicer Truncated at lower browser zoom

RichFlorida — Sat, 12 Sep 2026 14:48:06 GMT

I'm noticing when users have their browser set at a low zoom (ie: 67% or below), it causes the date slicer to get truncated in the PowerBI Dashboard. They can see the StartDate part but not the EndDate (see image below).

Has anyone experienced this? Do you know how this can be prevented?

Thanks!

Usage Metrics Report - Report Views Vs Report Page Views

RichFlorida — Sat, 12 Sep 2026 13:59:46 GMT

I'm reviewing my PowerBI Usage Metrics Report. i'm noticing that for some days, there are report view counts but there is zero report pages views for that same report.

Has anyone noticed the same? What could cause this? How are the views counted?

Marked as spam for no reason

llueg — Sat, 12 Sep 2026 13:11:03 GMT

Could a moderator look at my post, which was marked as spam immediately after posting?

Pure Python Notebook: authenticate to Azure DevOps Artifacts using Fabric Workspace Identity | Microsoft Fabric Community

Thanks!

Pure Python Notebook: authenticate to Azure DevOps Artifacts using Fabric Workspace Identity

llueg — Sat, 12 Sep 2026 12:47:07 GMT

Can a Pure Python Fabric notebook running under a Workspace Identity obtain an Azure DevOps access token so that `pip install --index-url ...` can authenticate without a PAT?

It would be very nice if we could use the Workspace Identity to authenticate directly against a DevOps Feed in order to pull dependencies, as that would allow DevOps to directly target Feed-permissions for that Workspace (in particular, `Feed Reader`). For Spark Notebooks, we can use a Connection to do that, but for Pure Python Notebooks I can't find a documented way.

At the end of the day, one needs a token to pass to `pip` in order to bootstrap the notebook's runtime environment from the Feed, but as far as I can see there is no documented way to generate that token from the Workspace Identity. Currently, I'm using a keyvault'ed PAT. However, while this is fine-ish on the Fabric-side, it requires a dedicated Identity on the DevOps side, which I'd like to avoid.

Fabric Eventstream MySQL CDC scans all databases and does not emit row-level events

girishtharwani2 — Sat, 12 Sep 2026 09:17:46 GMT

Hello Fabric Team,

We are testing the Microsoft Fabric Eventstream MySQL CDC connector with an AWS RDS MySQL database.

The MySQL instance is accessible through a private IP, and Fabric connects through a VNet data gateway/private network connection. Connectivity is successful, and the connector remains Active without reporting processing errors.

Our MySQL environment contains the same table structure across multiple databases, following a pattern similar to:

application_<tenant>.sample_table

We configured the source to capture only one fully qualified table:

application_tenant1.sample_table

The MySQL configuration is:

log_bin = ON
binlog_format = ROW
binlog_row_image = FULL
The connection user has SELECT, SHOW DATABASES, REPLICATION CLIENT, REPLICATION SLAVE/REPLICA, and the required snapshot permissions.
Each Fabric source uses a unique Server ID.
CDC from the same RDS instance has previously worked successfully through another CDC platform.

However, we are seeing the following behavior:

Although only one fully qualified table is selected, Fabric/Debezium scans schema metadata for every accessible database and table on the MySQL server.
More than 45,000 schema events were generated across the tenant and history databases.
The schema events contain DDL such as DROP TABLE IF EXISTS and CREATE TABLE.
Snapshot mode is configured as Initial.
The selected table contains approximately 16,000 records, but Fabric emitted zero snapshot r events.
We committed a new insert into the selected table after schema discovery finished, but no c event was emitted.
Eventhouse receives the schema events successfully, confirming that the source-to-Eventhouse path is operational.
The Eventhouse destination stores the Debezium payload in a dynamic column using a mapper from payload to RawEvent.

Could you please confirm the following?

Is it expected for the Fabric-managed MySQL CDC connector to scan and publish schema events for every database when only one fully qualified table is selected?
Does Fabric expose or support settings equivalent to:
- database.include.list
- table.include.list
- schema.history.internal.store.only.captured.databases.ddl
- schema.history.internal.store.only.captured.tables.ddl
Why would the connector finish schema discovery but not emit existing rows from the selected table when Snapshot mode is Initial?
Why are committed inserts not emitted after the schema phase appears to finish?
Is there a known limitation involving AWS RDS MySQL accessed through a private IP and VNet data gateway?
What is the recommended supported destination pattern for this CDC stream?

Our main objective is reliable ongoing CDC capture. We are flexible about the landing destination and can use:

Eventhouse
ADLS Gen2 in JSON or Parquet
Fabric Lakehouse/OneLake
Snowflake as the final destination

Please let us know which logs, connector identifiers, timestamps, or additional configuration details would help investigate this behavior.

Thank you.