New board topics in Microsoft Fabric Community

filter earlier posts based on keyword

powerbiexpert22 — Sat, 19 Sep 2026 11:02:08 GMT

i have more than 1000 posts created by me on this forum, i want to filter those posts based on certain topic or key word so that it should give me ony those posts where that keyword is used , let say for example if i search on "direct query" then it should give my posts where direct query word was used, how to do on this forum?

Fire! Leicestershire Fire and Rescue Service incident report

Coriel-11 — Sat, 19 Sep 2026 10:35:07 GMT

The aim with this Fire Service report was to create a fully interactive, all-on-one screen, dashboard that showcased the incidents dealt with by Leicestershire Fire and Rescue Service. I was able to do this because they make this data publicly available on their website.

Fire service data is good to play with because it's something that affects us all. All the visuals and filters all interact with each other, so you can break down the data and look at it by:

Local authority area within Leicestershire
Ward area (a subdivision of each LA)
Time range
Day of the week
Hour of the day
What caused the incident
The perceived motive

In this data visualization I tried to keep the colours in line with LRFS's branding, though I added darker colours on the heat map showing the times with most incidents. I also used colour to distinguish between the different LAs, keeping that consistent across the map, LA selector bar chart and the top ten wards graphics.

Technical details

The data is published as a downloadable Excel file from LFRS's website. I coded the location of this as a parameter in Power Query for easy switching when new data becomes available.

I used #PowerQuery to break the data down into a classic star schema, as well as bringing in some LA location data in PQ to make the maps work. The #Mcode was fairly basic for this one.

I used my own #DAX built calendar/date fact table combining the tables in Model View.

The reporting cards are my own custom-built #SVG images, powered by DAX.

This is the largest canvas size I have yet used, but the intention is that it means all the text/numbers are readable on a monitor screen, even if some zooming is required. But that is its intended user context, rather than in a presentation.

Please let me know what you think.

Power BI Financial DAX Functions Explained | ODDFPRICE, ODDFYIELD, ODDLPRICE & ODDLYIELD

suparnababu8 — Sat, 19 Sep 2026 04:06:48 GMT

In this video, you'll learn four advanced Financial DAX Functions with practical, real-time business examples.

✅ ODDFPRICE

✅ ODDFYIELD

✅ ODDLPRICE

✅ ODDLYIELD

If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel for more learning content.

Power BI - Slicer Control

RajiKarthik — Fri, 18 Sep 2026 23:12:49 GMT

I need a slicer selection to appear and disappear based on a parameter slicer selection:

I have 3 metrics in my parameter: Student Enrollment, Course Enrollment and Credit Hours

Whenever student enrollment is selected, the user should be provided with an additional slicer option, "Area of Study Category", and for other metrics, it should stay invisible.

I created control DAXs "Show Area of Study Slicer" and "Area of Study Slicer Header". Added the "Show Area of Study Slicer" to the visual level filter and set it to 1. Similarly added the "Area of Study Slicer Header" to the header control, so the header disappears too.

Issue - Header disappears, but if I make any selection in the "Area of Study Category" slicer and then change the metric to "Course Enrollment", then the slicer remains with only the selected value. Other values disappear, though. But I want the whole slicer to disappear when the metric parameter changes. Experts, please help! Thanks in advance!!

Parameter Definition:

Metric Selector =

DATATABLE(

"Metric Key", INTEGER,

"Metric Name", STRING,

"Sort Order", INTEGER,

"Department Map", STRING,

{

{ 1, "Student Enrollment", 1, "Student" },

{ 2, "Course Enrollment", 2, "Course" },

{ 3, "Credit Hours", 3, "Course" }

}

)

Control DAXs to use in the filter & Header:

Show Area of Study Slicer =

VAR MetricKey = SELECTEDVALUE('Metric Selector'[Metric Key], 1)

RETURN

IF(MetricKey = 1, 1, 0)

Area of Study Slicer Header =

VAR MetricKey = SELECTEDVALUE('Metric Selector'[Metric Key], 1)

RETURN

IF(MetricKey = 1, "Area of Study Category", "")

Monitor Power BI Report Performance

Lorenz33 — Fri, 18 Sep 2026 21:42:03 GMT

I am a Fabric administrator and with my permissions I can utilize the MS Fabric Capacity Metrics app. However, regular users do not have access to this data. I have a report developer who is requesting data on performance metrics for his report. Data such as how long did it take a report to load. How many CUs did an object use. Is there any way I can make this information available? I have a report I created that access the Power BI Activity log and shows audit data but it does not have the performance information he is requesting. He would like this for performance tuning and optimization. I checked out the reports in the Admin Monitoring workspace but they do not appear to have performance data.

semantic models no updated in admin monitoring workspace

bbtresoo — Fri, 18 Sep 2026 20:59:26 GMT

hello,

is there any reason admin monitoring reports such as Feature Usage and Adoption is not refreshed ???

Content sharing report hasn't been refreshed for 6 months.

what's the purpose of making available no updated monitoring artefacts?

Regards

Fabric Pipeline Error

odtJitendra — Fri, 18 Sep 2026 19:00:07 GMT

Today, we noticed that our production pipeline started failing with the following error:

Error:

BadRequest Error fetching pipeline default identity userToken{

"code": "LSROBOTokenFailure","message": "AADSTS50173: The provided grant has expired due to it being revoked, a fresh auth token is needed. The user might have changed or reset their password. The grant was issued on '2026-08-24T05:50:05.7907970Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2026-09-18T16:05:07.0000000Z'. Trace ID: 250ed633-08f0-4dcb-bad0-11596983e901 Correlation ID: 430f0833-fbc4-44f8-b19a-883ada2cad74 Timestamp: 2026-09-18 18:29:30Z",

"target": "PipelineDefaultIdentity-3e591cb6-2704-49f2-9efd-7196287c9feb","details": null,"error": null }FetchUserTokenForPipelineAsync

Has anyone encountered this issue before or have any idea what could be causing it?

Any suggestions on how to resolve this would be appreciated.

updating .sqlproj file (version issue with git)

justfetz — Fri, 18 Sep 2026 18:58:50 GMT

We recently had a couple issues syncing from main with INFORMATION SCHEMA errors.

When we reviewed the documentation Upgrade Fabric Data Warehouse System File Version in a Git Integrated Fabric workspace - Microsoft Fabric | Microsoft Learn, we noticed that we had two errors.

The first is that we were self referencing in a couple PROCS, eg WH.dbo.Table from current WH.

We fixed that problem, and th INFORMATION SCHEMA sync still persisted, but the self ref error went away.

Then we noticed that the sqlproj file is listed as a possible cause. We have the old preview version listed in git.

However, if you export the warehouse project, the actual wh sqlproj file shows up to date.

So there is a difference b/w git and what is actually in the workspace.

We have tried to PR the change to this file, update it directly in git, make a small change in the wh and commit directly to main to see if we could trigger the change. In the one case, we went into ADO, we updated this file directly, committed to it. It actually SHOWED as an update for a hot second, BEFORE converting to a change and the change was showing the old definition.

In that referenced article, we have tried a and b, and we cannot for whatever reason get this file to update in git, which then causes sync issues.

Does anyone have experience with this, a recommendation?

Thanks J.

Distance-Based Location Highlighting

Swami_om — Fri, 18 Sep 2026 15:28:14 GMT

Hello,

I’m trying to calculate the distance between the assigned location and the employee’s home location using the latitude and longitude available in this file.

The objective is to identify locations that are within the selected distance range (in kilometres) using a kilometre slicer. I would like the locations that fall within the selected range to be highlighted in green, while all other locations remain grey.

Additionally, I would like the selected location to be highlighted based on the selected City, Employee Location, or StoresDummy[City] value.

I’ve also referred to the following YouTube video for guidance: youtube

Could you please help me implement this logic in Power BI/DAX?

Sample data

Best Practices for Handling Incremental Data Loads in Dataflow Gen2

codeautomation — Fri, 18 Sep 2026 15:26:56 GMT

Hi everyone,

I am exploring different approaches for handling incremental data loads with Dataflow Gen2 in Microsoft Fabric.

For larger datasets, refreshing the entire dataset every time can become inefficient, so I am interested in understanding how others are designing their dataflows to process only new or changed records.

A few questions:

How are you identifying and filtering changed records between dataflow runs?

Is it better to manage incremental logic directly inside Dataflow Gen2, or use a Fabric pipeline to control the process?

How do you handle failed runs or partially processed data without creating duplicate records?

Are there any recommended patterns for maintaining good performance as the volume of historical data grows?

I would appreciate hearing about approaches that have worked well in real Fabric environments.

Designing AI Agent Workflows on Modern Data Platforms

codeautomation — Fri, 18 Sep 2026 15:21:22 GMT

Hi everyone,

I have been exploring how AI agents can work with modern data engineering platforms to automate business processes.

A common architecture I see is that data pipelines collect and prepare information, AI agents analyze the context and determine the next action, workflow services execute tasks through APIs or connected systems, and the results are stored for reporting or further processing.

I am interested in how teams are approaching this with Microsoft Fabric.

Are you using AI agents directly with Fabric workflows, or keeping the AI layer separate?

What patterns work well for connecting AI agents with Lakehouse, Data Pipelines, or notebooks?

How do you manage security and permissions when AI applications need access to enterprise data?

Are there recommended approaches for combining Fabric workloads with external AI services?

I would be interested to hear what architecture patterns others are using and what challenges you have encountered.

The permissions granted to user '' are insufficient

eduardserediuc — Fri, 18 Sep 2026 15:18:41 GMT

I installed Power BI Report Server – SQL Server 2025 Standard, product version 15.0.1121.109, on the primary node only of a Windows Failover Cluster SQL Server 2025 (no AG) – OS Windows Server 2025 Datacenter.
I configured the SMTP settings in the Email Settings section of the Report Server Wizard.
I created a shared PostgreSQL data source that connects using a username and password, and then created a paginated report using that data source.
The permissions for my AD user on the Report Server folder containing both the data source and report are all: Browser, Content Manager, My Reports, Publisher, Report Builder.
I created an Email distribution subscription for my report, but when I run the subscription either manually or on schedule I get the below error:

Failure sending mail: The permissions granted to user '' are insufficient for performing this operation.Mail will not be resent.

Can Power Automate Automatically Retry a Power BI Dataset Refresh Until It Succeeds?

manoj_0911 — Fri, 18 Sep 2026 14:32:32 GMT

Hi Power BI Community,

We currently perform a manual refresh of a Power BI dataset in our Production workspace. We would like to automate this using Power Automate.

Our requirement is:

Dataset: Recording
Workspace: Production
Required to be successfully refreshed before 8:00 AM EST every day
Start the refresh automatically, for example around 6:00 AM EST
Sometimes the refresh fails intermittently, so we would like Power Automate to retry the refresh if it fails
Once the refresh successfully completes, the flow should stop immediately and should not trigger any further refreshes
We don't need a success email/notification.
If the refresh continues to fail after a predefined number of retries, we would like to be notified.

Our intended flow is roughly:

Scheduled trigger – 6:00 AM EST ↓ Refresh Power BI Dataset ↓ Check actual refresh status ↓ Completed? ↓ YES ↓ NO / FAILED STOP Wait ↓ Retry ↓ Check status again ↓ SUCCESS → STOP

Questions:

Can this be implemented reliably using the Power BI connector in Power Automate?
Is there an action/API that allows us to check the actual dataset refresh status after triggering the refresh?
How can we make the flow retry only when the refresh fails or does not complete?
Once the refresh succeeds, how can we ensure the flow stops and does not trigger another refresh?
Is there any limitation on repeatedly triggering dataset refreshes through Power Automate that we should be aware of?
Would you recommend using the Power BI REST API instead of the Power BI connector for this scenario?
What Power BI and Power Automate licenses are required for this solution?

Any guidance or examples of a recommended Power Automate design would be appreciated.

Thanks!

Building an AI-powered quote engine on Microsoft Fabric

Avyaktha — Fri, 18 Sep 2026 14:15:20 GMT

The problem

Sales teams for technical products often get free-text enquiries like:

"I need 4 x 5T chain hoists, 10m lift, for offshore use"

Turning that into a quote usually means someone manually matching the product, checking the bill of materials, checking stock, checking supplier lead times, and pricing it up. I wanted to see how far Fabric's native AI capability could get toward automating that whole chain, without reaching for an external LLM service.

What I built

A proof of concept entirely inside one Fabric workspace:

A Lakehouse holding a synthetic but realistic-looking dataset: a product catalogue (chain hoists, wire rope hoists, lever hoists, beam clamps, trolleys), a bill-of-materials per product, inventory levels, supplier lead times, and pricing
A set of notebooks using Fabric's built-in AI Functions to read a customer enquiry and turn it into a structured, priced draft quote — matching the enquiry to a product, exploding the BOM by order quantity, checking stock, and rolling up a price and lead time
A simple interactive demo — type an enquiry into a text box, click a button, get a quote back — running entirely inside a notebook, no external app or Azure OpenAI resource needed

I deliberately made some components tight on stock (gearboxes, motors, brakes — the genuinely long-lead-time parts), so the demo shows a real "can we fulfil this now, or is it pending procurement?" decision, not just a happy path.

The interesting part

Real enquiries aren't always single, clean requests — customers often ask for a few different things in one message ("2 hoists, one standard and one offshore"). The AI extraction naturally returns one value per field, so it initially collapsed multi-item enquiries into a single line and silently dropped part of the request. Getting a reliable split-then-process approach working — without it silently swallowing half the enquiry — was the trickiest part to get right.

A couple of smaller but important lessons: null/missing values from the AI extraction need explicit handling in code rather than relying on prompt instructions alone, and discontinued or not-yet-launched products need to be filtered out at the matching stage so the system doesn't quietly quote something no longer sold.

Happy to go into more detail on the data model or the AI extraction approach if anyone's tackling something similar on Fabric.

Manage Roles - Row level data restrictions

Msampedro — Fri, 18 Sep 2026 14:10:12 GMT

Hi all,

Working on row level data restrictions. I do have a Budget table by Sales representative. Every sales person only can see their own data, plus two managers that they can see the sales representatives reporting to them and finally Director having access to all the data. Somehow it's not working.

I have created a "Security Table" with the users and Sales Rep ID, what indicates which users can see each one (i.e.; meaning Director can see Sales Rep ID 1,2,3 & 4. Manager1 sales rep ID 1 and 2, Manager2 sales rep ID 3 and 4 and finally Sales rep1 only can see Sales rep ID 1 and so on...

Model view below with Relationships are both one to many.

Formula DAX use in the manage roles

Export dashboards created in Power BI

Anas2 — Fri, 18 Sep 2026 13:15:38 GMT

Hello,

is it possible to export dashboards created in Power BI to a PowerPoint file or an interactive PDF ? if it's the case, how to do it ?
Thank's

Error while exporting Excel using the "Summarize Data" option.

AAM_ — Fri, 18 Sep 2026 11:12:59 GMT

Hi,

When trying to export to Excel, some users are receiving the following error message:

No changes have been made to the report or to the underlying data model. However, starting today, some users have begun encountering this error.

The issue does not occur consistently, and it is not associated with any specific combination of measures and dimensions.

We are unsure what could have caused such a sudden issue.

thanks!

Refill Buffer Error while refreshing a table

ShreyasMungad — Fri, 18 Sep 2026 08:53:28 GMT

The power bi has tables connected to Databricks SQL Server

While refreshing 1 of the tables getting this error: OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [08S01] [Microsoft][Hardy] (115) Connection failed with error: Could not refill buffer

I have already tried to reduce the size of the output by reducing the date range in SQL Query, cleared cache. The only step applied in power query is converting text to date for a date column. This error has started occuring after I replaced a column with another in Query.

The query loads correctly in Databricks, the power query preview loads as well, the problem occurs only after "Close & Apply"

New to this forum, I have tried looking for solutions on Copilot, nothing helps if any ideas please let me know, I will be very grateful

Unifying two country BIs under RLS - how to handle historical data without a Country column?

ario0991 — Fri, 18 Sep 2026 07:10:28 GMT

Hi everyone,

We're working on a project to unify two separate Business Intelligence solutions (Spain and Italy) into a single one, using Row-Level Security (RLS) filtered on a Country field.

The RLS setup itself is clear to us. The issue is historical data: our old data doesn't have a Country column, since each BI used to be completely separate and never needed that distinction. Migrating/backfilling this historical data into the new unified model with a Country field is not an option for us.

One idea we had was adding buttons/links on the new reports that take users back to the legacy (old) reports for historical data, keeping the two worlds separate rather than merging them.

Has anyone dealt with a similar scenario, where historical data has to stay outside the new RLS-governed model? Specifically:- Is the "button linking to legacy report" approach a reasonable pattern, or are there better ways to handle this?- Any recommended navigation/UX patterns for pointing users from a unified report to a separate legacy report?- Any pitfalls we should watch out for with this kind of hybrid setup (new unified model + old standalone reports)?Thanks in advance for any input!

From Odoo & personal gateways to a Fabric Lakehouse: Medallion + Direct Lake, and F64 down to F16

psdhillon1 — Fri, 18 Sep 2026 06:49:02 GMT

We recently modernized the Power BI estate of a manufacturing client running Odoo while working on a project at DataToBiz

Before: Gen1 dataflows pulling Odoo over XML-RPC, Python scripts running through personal gateways, and many reports nobody opened. All of it ran on an F64 capacity with slow refreshes (trial version)

What we did (in about 60 working days):

Built everything in a separate dev workspace on a small F8 capacity, so production was never touched
Used report-usage metrics to pick only the reports worth migrating
Moved Gen1 → Dataflows Gen2, and switched Odoo XML-RPC → JSON-RPC
Moved the Python scripts into Fabric notebooks and removed the personal gateways
Bronze/Silver/Gold medallion into a Fabric Warehouse, then one certified Direct Lake semantic model
Rebound the Sales, Marketing and Production reports, ran UAT against the old workspace, then deleted the old content

Result: Production capacity went from F64 to F16 with stable CU usage. Estimated saving is about $75K per year. Refresh time went up significantly.

Question for the community:
1. When you downsize a capacity, how much CU headroom do you keep for spikes like month-end or bulk refreshes?
2. We used 75% peak utilisation on the Capacity Metrics app as our cut-off. Curious what thresholds others trust.