New board topics in Microsoft Fabric Community

How to display images from Dataverse on Power Bi Report Builder

Fern_21 — Tue, 15 Sep 2026 19:10:57 GMT

Hi all!

On Power BI Report Builder I need to display images I have on Dataverse. What format should they be in? Base64? Also, I should be able to change the images based on the filters I select. Is it possible? Thank you so much

This semantic model uses a deprecated gateway version. Upgrade required.

DClark21044 — Tue, 15 Sep 2026 16:35:08 GMT

I started getting the following message on nearly every report on my tenant suddenly. The gateway has been updated the same way with the same cadence for years without have this message appear.

The gateway is one update behind the newest. Was able to get the message to go away for most users by restarting the gateway but the message still persists for some. Everything is working fine but as you can imagine, it's causing lots of panic. Any input would be greatly appreciated.

How can I automatically clear a slicer selection?

Afsaneh25 — Tue, 15 Sep 2026 14:57:01 GMT

Hello,

I have a Power BI report page with three dropdown slicers, all configured as single-select. Based on the selections in these slicers, a fourth slicer, displayed as a vertical list, is dynamically filtered to show a list of options from a column in one of my tables.

When I select an option from the vertical slicer, the related information is displayed in several charts and tables.

However, I am experiencing an issue when changing the selections in the three dropdown slicers.

For example:

Suppose I select X in one of the dropdown slicers. The vertical slicer then displays X1, X2, X3, ....
I select X1 from the vertical slicer, and the charts and tables update accordingly.
Without manually clearing X1, I change the dropdown selection from X to Y.
The vertical slicer now displays Y1, Y2, Y3, ..., but X1 remains selected in the slicer.
Because X1 is not part of the available options under Y, the charts and tables become empty.

My question: Is there a way to automatically clear or reset the selection in the vertical slicer whenever one

of the three dropdown slicers changes?

Ideally, when I change the dropdown selection from X to Y, the vertical slicer should automatically clear its previous selection so that I can select an option from the new list (Y1, Y2, Y3, ...).

I would appreciate any suggestions or recommended approaches. Thank you!

Need to Migrate SP written in Synapse to Fabric

maxravi — Tue, 15 Sep 2026 14:50:23 GMT

Hello,

I need to migrate my stored prodecure SP from synapse to Fabric, can you please help me with best approach. I am seeing a lot of syntax changes. Suggest me some best, quickest and efficient ways to migrate.

Thanks,

How can I create cards with trend percentage and mini sparkline chart like this dashboard?

Rutvika — Tue, 15 Sep 2026 14:39:29 GMT

How can I recreate cards with a metric value, MoM growth indicator, and a sparkline trend line inside the same card in Power BI? Is this achievable using native visuals or does it require a custom visual? Screenshot attached for reference
Requirement:
1.the card on hover should have glow and shadow ( as shown in screenshot for M365 Groups)
2.on default the glow and shadow should disappear (as shown in screenshot for Total Mailbox)

Not able to extract direct lake semantic models through api

Anmoldeep — Tue, 15 Sep 2026 14:25:56 GMT

I’m trying to retrieve the item definition of a Power BI semantic model using the Fabric REST API, but the request is failing for some semantic models.The API returns the following error:

RuntimeError: Get Item Definition failed.Dataset Workload failed to export the dataset with dataset id . We cannot load this Direct Lake dataset because your Power BI capacity does not support Direct Lake mode. Please use a Power BI capacity type that supports Direct Lake mode.

The semantic model is using Direct Lake mode.

Is Get Item Definition / Fabric REST API supported for Direct Lake semantic models only when the workspace is on a Fabric-supported capacity?
What specific Power BI/Fabric capacity SKUs support Direct Lake?
Is there any way to retrieve the semantic model definition/TMDL for a Direct Lake model when the workspace is on a capacity that doesn't support Direct Lake?
Could this error also occur if the model was originally created as Direct Lake but the current workspace/capacity configuration has changed?
Are there any recommended APIs or alternative approaches for extracting metadata (tables, columns, measures, relationships, etc.) from Direct Lake semantic models in this situation?

I would especially appreciate clarification on whether this is an API limitation, capacity limitation, or a limitation of the Direct Lake workload itself.

Thanks!

Databricks Mirroring - Direct Lake and Dynamic RLS/ Masking Access Controls

henry_gonsalves — Tue, 15 Sep 2026 13:59:52 GMT

I want to set access controls for our data in a single place within databricks unity catalogue and have a user's credentials passed back to databricks platform and the relevant data returned on the Power BI report. This seems to works well for direct query but I'd like to ensure that reports are performant for users which may not always be the case using direct query with larger datasets/ models

I've been looking into Direct Lake and have the following questions:

Will we need to set-up databricks/ unity catalogue mirroring with Fabric to enable Direct Lake?
Will there be a performance increase using Direct Lake for databricks over Direct Query connections?
Will I be able to pass back user's credentials back to source to enforce the masking and RLS set within table access policies in dataricks using a Direct Lake connection?

It seems like there are performance benefits to Direct Lake but I am unsure whether RLS and column masking is enforced like Direct Query connections. I don't want to recreate access controls within the Power BI semantic model, ideally.

Can anyone provide the best architecture for working with databricks that is both performant, secure and easy to manage? Is anyone able to provide a practical example of OneLake security and how this applies to mutiple sources and the effect in Power BI? Thanks

Paginated reports and direct query live refresh after PBI GWs update to 09/2026 from 12/2025

STANHTPS — Tue, 15 Sep 2026 13:12:26 GMT

hello everyone,

This is not a spam. I am Windows server Administrator in Czech Republic. I need your help with this case.

Has someone experinced the same issues? Paginated reports should return the easy results with three records from Oracle table but instead it is still loading and cannot render the report, it should take only few seconds. Refresh of report with direct query live return the screen: (sry it is in the czech language :-( ) First of all, I found out that since May 206, the PBI version includes the built in Oracle ODP provider, so I did disable it in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config, and also tried to change MashupDefaultPoolContainerMaxWorkingSetInMB from 0 to 8192MB(VM Hyper-v server has more), but the paginated reports are still not working at all and direct query too. I have few more hours to try to solve it, then have to recover the virtual machine to the previous deprecated September 2025 version and try to update to March or April 2026, without any changes that probably causes the errors.

Thank you very much community for help.

Paginated reports and direct query live refresh after PBI GWs update to 09/2026 from 12/2025

STANHTPS — Tue, 15 Sep 2026 12:55:27 GMT

hello everyone,

Has someone experinced the same issues? Paginated reports should return the easy results with three records from Oracle table but instead it is still loading and cannot render the report, it shold take only few seconds. Refresh of report with direct query live return the screen: (sry it is in the czech language :-( ) First of all, I found out that since May 206, the PBI version includes the built in Oracle ODP provider, so I did disable it in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config, and also tried to change MashupDefaultPoolContainerMaxWorkingSetInMB from 0 to 8192MB(VM Hyper-v server has more), but the paginated reports are still not working at all and direct query too. I have fwew more hours to try to solve it, then have to recover the virtual machine to the prevousl deprecated september 2025 version and try to update to march or april 2026, without any changes that probably causes the errors.

Thank you very much community for help.

Power bi Refresh Failure

Rohit_Agrawal — Tue, 15 Sep 2026 11:51:36 GMT

**Title: Scheduled refresh timing out (5hr XMLA limit) — ServiceNow REST API via Web.Contents, no query folding, incremental refresh not viable**

Hi all,

I'm hitting a wall with a dataset that pulls from ServiceNow via the Table API and would appreciate any guidance from people who've dealt with non-foldable REST sources at scale.

**Setup**

- Source: ServiceNow Table API (`/api/now/table/incident`, `change_request`, `problem`, `sc_req_item`, `task`, and a custom `u_change_deployment` table) — 6 tables total in one semantic model

- Connector: `Web.Contents` with `sysparm_query`, `sysparm_fields`, `sysparm_limit`, `sysparm_offset` passed through the `Query` record (static base URL, so no dynamic data source issue)

- Paging: `List.Generate` loop, page size 5000, looping until an empty page returns

- Volume: roughly 365,000 incident records for the current year, plus large RITM/task volumes having approx 10 lakh rows and 30 columns

- Capacity: Power BI Pro / shared capacity, North Europe

- Refresh: scheduled daily

**Problems I'm facing**

**1. No query folding.** `Web.Contents` isn't foldable, so every transformation (expand record column, type changes, filters) runs locally in the mashup engine after the full payload is pulled. "View Native Query" is greyed out on every step, as expected. I've done what I can by pushing the date filter into `sysparm_query` so ServiceNow returns only the relevant range, but that's manual server-side filtering, not folding.

**2. Incremental refresh flags the query as non-foldable.** The IR dialog shows "Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries." I set it up anyway (`RangeStart`/`RangeEnd` as Date/Time parameters, used both in the `sysparm_query` string and in a `Table.SelectRows` step on `sys_created_on`, with "Only refresh complete days" ticked). Settings were: archive 1 year, incrementally refresh last 2 days.

Even with that, refreshes failed. I've since disabled IR entirely to rule it out as the cause, and the timeouts persist — so the bottleneck is the extraction itself, not the partitioning.

**3. Refresh consistently hits the XMLA timeout.** Refresh history shows:

- 3h 25m — Failed

- 4h 23m — Failed

- 5h 0m 5s — Failed (`Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 17999 sec.`)

After four consecutive failures the service auto-disabled scheduled refresh ("Scheduled refresh has been disabled").

**4. Dot-walked reference fields appear to be a major cost.** My incident query requests around 35 fields including several dot-walked ones: `caller_id.u_zone`, `caller_id.u_market`, `caller_id.u_region`, `location.full_name`, `assignment_group.u_stream`. These are business-critical for the dashboard so I can't drop them, but each one forces a reference join server-side in ServiceNow, and I'm also using `sysparm_display_value=true` which resolves every reference to its label. I suspect this combination is where most of the five hours goes.

**5. Malformed rows in the API response.** Occasionally ServiceNow returns an empty string in place of a record inside the `result` array, which breaks `Table.ExpandRecordColumn` with "We cannot convert the value "" to type Record". I've worked around it with `List.Select(..., each Value.Is(_, type record))` before building the table, but flagging it in case others hit the same.

**What I've already tried**

- Moved all dynamic values into the `Query` record so the data source isn't flagged as dynamic

- Added the mandatory `RangeStart`/`RangeEnd` filter step for IR detection

- Ticked "Only refresh complete days"

- Reduced the incremental window to 2 days

- Disabled IR on the small tables

- Locale-safe datetime parsing instead of hard type conversion

- Null-safe filters throughout

None of it got the refresh under the timeout.

**Questions**

Has anyone successfully run incremental refresh against a ServiceNow REST source at this volume? Is there a paging or query pattern that performs meaningfully better than a sequential `List.Generate` loop?
Is there any way to parallelise page requests in Power Query, or is sequential paging an unavoidable ceiling here?
For those who've moved off direct REST extraction — did you go the ServiceNow Database View / scheduled Export Set route, or stage into SQL Server first? Roughly what refresh times did you end up with?
Would a Dataflow Gen1 (Pro licence, no Fabric access) realistically help here, given it decouples the extraction from the dataset refresh window but doesn't make the extraction itself faster?
Any way to raise or work around the 17999-second XMLA timeout on shared capacity, or is that a hard ceiling?

Happy to share the full M script if useful. Any pointers appreciated.

Thanks

Is it possible connect via a guest account to a Delta table in a Lakehouse from another tenant.

FabricEnjoyer — Tue, 15 Sep 2026 11:21:00 GMT

We have the following architecture in Microsoft Fabric:

Open Mirroring Database ↓ Notebook ↓ Materialized Delta Tables (Lakehouse) ↓ Shortcuts into Connection Lakehouse ↓ Power BI Desktop (Azure Data Lake Storage Gen2 connector) ↓ DeltaLake.Table()

Source = AzureStorage.DataLake( "https://onelake.dfs.fabric.microsoft.com/<workspace-id>/<lakehouse-id>/Tables", [HierarchicalNavigation = true] ), dbo = Source{[Name="dbo"]}[Content], TableName = dbo{[Name="<table_name>"]}[Content], Data = DeltaLake.Table(TableName)

What works

Internal users in the hosting tenant can successfully create the connection.
At least one external Entra B2B Guest user can successfully create the connection.
If we create and publish the semantic model ourselves, external customers can copy/use the model successfully.
Existing reports refresh successfully once deployed.

What fails

Several external customer users that have been invited into our tenant as Entra B2B Guests receive a 404 error when attempting to create a new Azure Data Lake Storage Gen2 connection directly from Power BI Desktop.

The users have:

Accepted the guest invitation.
Been granted access to the Fabric workspace(Contributor)
Been granted access to the Lakehouse.
Been added as Guest users in Entra ID.

Observations

The issue is affecting multiple customers, not just a single user.
The same Lakehouse, shortcut tables, and Power Query logic work for other users.
A Guest account from one customer tenant works, while Guest accounts from several other customer tenants receive a 404.
This suggests the issue may be related to cross-tenant authentication, OneLake access resolution, or the ADLS Gen2 connector rather than permissions on the Fabric artifacts themselves.

Questions

Are there known limitations or issues with Azure Data Lake Storage Gen2 connections to OneLake for some Entra B2B Guest users?
Are there specific cross-tenant access settings, trust settings, or Conditional Access configurations that can cause a 404 during OneLake path resolution?
Is there a recommended approach for external customers connecting directly to OneLake Delta tables via the ADLS Gen2 connector?

Any guidance would be appreciated.

Intermittent Power BI Service Refresh Failure with Snowflake – wsarecv Connection Reset

manoj_0911 — Tue, 15 Sep 2026 10:28:53 GMT

Hi everyone,

We are facing an intermittent issue with Power BI Service semantic model refreshes using the native Snowflake connector through an On-premises Data Gateway cluster.

The refresh works successfully in Power BI Desktop, but intermittently fails in Power BI Service.

Error:

DM_GWPipeline_Gateway_MashupDataAccessError [snowflake] Get "https://sfc-oh-ds1-109-customer-stage.s3.us-east-2.amazonaws.com/..." read tcp ...:443: wsarecv: An existing connection was forcibly closed by the remote host

The failure occurs while Power BI is downloading the Snowflake query results from the Snowflake-managed AWS S3 stage. The Snowflake query itself completes successfully.

What we have confirmed

The issue is intermittent.
Retrying the same refresh can succeed without configuration changes.
The issue occurs in Power BI Service but not Power BI Desktop.
We have a Gateway cluster with two nodes, and both nodes have experienced the same issue.
Other data sources using the same Gateway are not affected.
Gateway logs show the connection being reset while accessing the Snowflake S3 stage.
The S3 Stage endpoint is reachable on TCP 443.
Snowflake authentication and query execution are successful.
Microsoft reviewed the Gateway logs and advised that the next investigation should focus on the network path between the Gateway and AWS S3.

Microsoft's latest recommendation is to capture the network traffic during a failed refresh to identify which device is sending the TCP reset. They also recommended checking TLS/SSL inspection, firewall/session timeouts, connection limits, and host-based security agents.

Microsoft recommended testing

netsh trace start capture=yes tracefile=C:\Temp\gw_s3.etl maxSize=2048 report=disabled

Reproduce the failure and then run:

netsh trace stop

They also recommended running:

SELECT SYSTEM$ALLOWLIST();

in Snowflake and reviewing the Snowflake S3 Stage hosts against TLS/SSL inspection and firewall rules.

My questions

Has anyone experienced a similar wsarecv – An existing connection was forcibly closed by the remote host error when refreshing Snowflake data through the Power BI On-premises Data Gateway?

Could this be related to the Gateway's network path to AWS S3 even though TCP 443 connectivity succeeds?
Are there any known Power BI Gateway or Snowflake connector issues that can cause this type of mid-transfer connection reset?
Are there specific Gateway logs or diagnostics that can identify which component initiated the TCP reset?
Has anyone resolved a similar issue by excluding Snowflake S3 Stage endpoints from TLS/SSL inspection?
Are there any recommended tests to distinguish between Gateway, firewall/proxy, endpoint security, and AWS/Snowflake as the source of the reset?

Any guidance or similar experiences would be greatly appreciated.

Thanks!

Data export error

想要多多的赚钱 — Tue, 15 Sep 2026 10:23:23 GMT

Hello everyone,

I have encountered a problem now. In the Power BI service, I selected a matrix and wanted to export the data in this matrix in a summarized manner. After clicking, I reported an error in the first image below. When I recreated this matrix, the measurement values and screening criteria were the same as before, but there were no errors. I don't know what the reason is. May I ask what the reason is for this?

The explanation of the picture above is as follows：

could not create file

An error occurred while generating a query for the 'Export Data' operation. Please check if your visual object contains metrics from multiple tables, as this may cause the 'Export Data' operation to fail.

Claude Code Credit Cost Estimation for Power Bi report

Yash8160 — Tue, 15 Sep 2026 09:56:42 GMT

Hi everyone,

I’m working on a POC for Power BI + Claude Integration, specifically the Report Authoring skill.

We need to use Claude Code to create the required report pages and visuals. I’m currently trying to estimate the Claude Code credit/token consumption and approximate cost for completing this POC.Has anyone worked on a similar POC using Claude Code? If so, could you please share:

Approximate credits/tokens consumed

Estimated cost

Any recommendations for estimating the usage before starting

Any guidance or experience would be really helpful. Thanks!

Cross Filter with visuals

Kay_Kalu — Tue, 15 Sep 2026 09:55:25 GMT

In the image the section on the left is from table TaskOccurrences and the other visual are from table Team Workload. The problem I am trying to solve is looking at the image when you select a bar from the visuals on the left it filters the rest of the visuals but vise visa it wouldn't work see image below

for context of the build below is the relationship of the dashboard also the dax of the for right visuals count

when I try to make the team workload to Mi number relationship to cross filter both direction i get this error

the dax for right visual count below

I can't figure it out, if it possible I wouldn't mind a solution.

Claude Code Integrate with Power Bi

Yash8160 — Tue, 15 Sep 2026 09:54:54 GMT

Hi everyone,

I’m working on a POC for Power BI + Claude Integration, specifically the Report Authoring skill.We need to use Claude Code to create the required report pages and visuals. I’m currently trying to estimate the Claude Code credit/token consumption and approximate cost for completing this POC.

Has anyone worked on a similar POC using Claude Code? If so, could you please share:

Approximate credits/tokens consumed

Estimated cost

Any recommendations for estimating the usage before starting

Any guidance or experience would be really helpful. Thanks!

Backward Deployment

PBI_2K26 — Tue, 15 Sep 2026 09:06:35 GMT

Hello !

I have a deployment pipeline in this order :

A (Development) -> B (Preproduction) -> C (Production).

This is the standard order of the workspace, but there were some reports that have been created directly in B, so is it possible to deploy from B to A? without unassigning the worskpace from the actual pipeline.

Thank you.

Cross Filter with visuals

Kay_Kalu — Tue, 15 Sep 2026 08:43:42 GMT

for context of the build below is the relationship of the dashboard also the dax of the for right visuals count

when I try to make the team workload to Mi number relationship to cross filter both direction i get this error

the dax for right visual count below

I can't figure it out, if it possible I wouldn't mind a solution.

Incorrect Running Total Resetting by Month in DAX

Mohit009 — Tue, 15 Sep 2026 07:56:38 GMT

I'm trying to create a running sales total, but it keeps resetting at the start of every month instead of continuing across the entire year. My measure is:

Running Total = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales[Date]), Sales[Date] <= MAX(Sales[Date])))

The visual has Year, Month, and Sales Amount. I expected the total for February to include January sales as well, but it starts over from February. What am I missing here?

Microsoft Fabric et Power BI : Peut-on migrer une capacité vers une autre région Azure ?

RomainCasteres — Tue, 15 Sep 2026 06:09:27 GMT

Migrer une capacité Power BI ou Microsoft Fabric vers une autre région Azure : ce qui est possible, ce qui ne l'est pas, et les pièges qui cassent vos rapports en production. Accompagnés de Manel Omani (mlomani) et Akram Drid (akram-drid), nous explorons les différents scénarios de migration, les contraintes techniques actuelles, les considérations de conformité et de souveraineté des données, ainsi que les alternatives disponibles.

🎬 https://www.youtube.com/watch?v=Vwgdz8OpZq8

⚙️ Au programme :

Pourquoi migrer de région et pourquoi le home tenant doit rester l'exception
Multi-Geo : ce qui suit la capacité (compute, OneLake) et ce qui reste dans la région d'origine (permissions, credentials, métadonnées, gouvernance)
Les 4 étapes d'un projet : assessment, décisions, planification par vagues, exécution
Assessment automatisé avec Semantic Link Labs et rapport à code couleur
Prérequis Azure : quotas, réservations, chiffrement CMK • Démo — modèle sémantique Small, puis Large sous 10 Go, puis au-delà de 16 Go (backup / restore)
Démo — workspace rempli d'items Fabric : deployment pipeline, auto-binding et rebind manuels • Direct Lake on SQL : rebinder le SQL endpoint via la définition TMDL
Le piège du dataflow Gen1 dont les données restent dans le home region
Enhanced Compute Engine : pourquoi le premier refresh échoue après migration

❓ Les questions traitées :

Peut-on déplacer une capacité Fabric ou Power BI Premium entre régions Azure ?
Peut-on changer la Home region de son tenant ? • Pourquoi un workspace contenant des items Fabric ne change pas de région ?
Comment migrer un modèle sémantique de plus de 10 Go sans full refresh ?
Où sont réellement stockées les données d'un dataflow en Multi-Geo ?
Quand privilégier Multi-Geo plutôt qu'une migration ?

Que vous soyez architecte, administrateur de plateforme, responsable BI ou décideur Data, cet épisode vous aidera à mieux anticiper les enjeux d'une migration régionale.

📅 Les temps forts de cette vidéo :

00:00 : Phare Data 01:30 : Introduction
03:05 : Pourquoi changer de région ?
04:35 : Pourquoi changer la région du Tenant ?
06:13 : Considérations et limitations
07:42 : Étapes de migration et prérequis
11:10 : Assessment
13:32 : Démo 1
14:52 : Démo 2
17:23 : Démo 3
22:36 : Démo 4
35:02 : Démo 5
41:32 : Démo 6
48:08 : Retours d'expériences
50:24 : Conclusion

💬 N'hésitez pas à partager votre expérience ou vos questions dans les commentaires.

🌊 Phare Data, la chaîne qui éclaire vos données. On décrypte les services de data, d'analytics et d'IA, avec un ton accessible, des choix techniques assumés, et toujours une touche d'air marin.

⚓ Si cet épisode vous aide à mieux comprendre où va Fabric, alors le Phare a rempli sa mission.

🔔 Abonnez-vous à Phare Data pour ne manquer aucun épisode. Les opinions exprimées sont personnelles et ne représentent pas la position de notre employeur.

#MicrosoftFabric #PowerBI #Azure #FabricCapacity #MultiGeo #CrossRegion #DataMigration #DataGovernance #DataResidency #Souverainete #FabricAdmin #DataPlatform #EnterpriseAnalytics #CloudArchitecture #PhareData