New board topics in Microsoft Fabric Community

Viewer Role Authorities Changed

doorguy — Thu, 17 Sep 2026 21:18:23 GMT

Users in the 'Viewer' role are now exposed to the semantic models.

Prior to this change, our users had a much cleaner and more intuitive experience. They were presented with the reports and dashboards that we intended for them to consume, without being exposed to the underlying Semantic Models. Now that the Semantic Models are visible, users are seeing additional objects that they do not understand, do not need to interact with, and in many cases may mistake for reports, datasets, or other content they are expected to use.

Organizations have very different Power BI governance models and user populations. A change that intentionally alters what users see within a workspace should, in our opinion, provide administrators with the ability to determine whether that behavior is appropriate for their environment. At a minimum, there should be a supported way to preserve the previous user experience for organizations that do not want to expose these additional objects.

Are any other organizations as frustrated by this change as we are??

It has been explained by support as an "enhancement intended to align the user experience with the documented behavior."

We believe the documentation should have been updated to reflect how the Viewer role is intended to work in practice — not the other way around.

There is no practical use case for Viewer-role users accessing semantic models. This change represents a meaningful degradation in user experience, and we strongly encourage the team to incorporate real-world usage patterns of Power BI Service into future decision-making before changes like this are implemented.

Hide visuals when a page is navigated away from

ACraig08 — Thu, 17 Sep 2026 19:03:25 GMT

Hello, I have kind of an odd question. I was wanting to create a custom page navigator using buttons and bookmarks. I know there is a page navigator button that creates one for you, but it just takes up too much space on the page, so I need to create something that can be hidden and opened with a button. I put a menu button in the top right of my page that has a bookmark action so when it is selected it opens up a custom page navigation that is made from a shape, the buttons for the pages, and another menu button. I grouped those together and called it Menu Group for ease.

The menu button shown in that Menu Group is connected to another bookmark that hides the Menu Group.

All of that works great. However, the bump I have run in to now is that when you select a page button, it takes you to the page no problem, but it leaves the Menu Group visible on the page you just navigated away from.

Is there a way to make it so that when I navigate away from a page, it hides the Menu group? Or defaults to a specific bookmark where the menu is hidden.

It would be nice if the page navigation could be a dropdown or something, but I don't think that is possible.

Export data from Power BI

hchava5292 — Thu, 17 Sep 2026 18:55:24 GMT

Hello All,
I am aware that exporting data directly from a Power BI visual is subject to row limitations. CSV exports are limited to approximately 30,000 rows, while Excel exports can support up to approximately 150,000 rows.

My data is stored in Microsoft Fabric OneLake, and the Power BI report uses a live connection to a published semantic model.

We have a data-export requirement where users need to:

Apply filters within the Power BI report.
Select the fields they want to include through a simple checkbox or slicer.
Dynamically add selected fields to a table visual.
Remove fields from the table when they are unchecked.
Export the resulting filtered dataset to Excel or CSV.
Export more data than the standard Power BI visual export limits allow.

Field parameters can address the dynamic column-selection requirement, but the standard visual export limits are still a concern.

I am looking for the best possible solution that allows users to export large datasets while preserving:

The filters applied in the Power BI report
The fields selected by the user
Semantic model security and business logic
A straightforward user experience
Support for Excel or CSV output

Thanks in Advance

Threadseer: Interactive Process Mining in Power BI

JasonWittenauer — Thu, 17 Sep 2026 18:35:06 GMT

Discover how a process actually works from the event data already in Power BI.
Threadseer is a custom visual I built to bring process mining directly into Power BI. This interactive example explores a synthetic healthcare-claims workflow, showing how claims move from intake to resolution, where paths diverge, and where work repeats.

About the sample
The attached report contains 12,200 events across 1,880 cases and 10 process variants. All data is synthetic, so you can freely explore the report without exposing patient or business information.

With Threadseer, you can:
• Follow the process: Explore an interactive map of activities and transitions.
• Compare paths: Select variants to see common and alternative routes.
• Investigate bottlenecks: Examine delays between activities and inspect the contributing cases.
• Trace rework: Find repeated activities and follow individual case timelines.

To use Threadseer with your own event log, start with three required fields: Case ID, Activity, and Timestamp. Analysis runs inside the Power BI visual runtime, without sending event data to an external service.

Explore Threadseer
Find Threadseer on Microsoft Marketplace to use it in your own Power BI reports, or visit the getting-started guide for setup instructions.

Power BI Data Modeling Question

RajiKarthik — Thu, 17 Sep 2026 16:20:52 GMT

I have 2 questions on my data modeling:

For my Power BI report requirement I had to integrate 2 data sources of different grain

Student Data Source(176 columns) - Student identifier, term, program,major, major school, major department, student level, type ,demograhics - ethnicity,citizenship,country origin, sex - Min 1 row/per student to a max of 3 rows based on the major count and program count for each term

Course Data Source(315 columns) - Student identifier, term, course attributes - course number, course section, instructor, active course details,credit hours - Min of 4 row/student to 6 rows for each term

Additionaly, both the datasources have snapshots captured everyday. So for example for each snapshot, the student data source has 9000 records and course data source has 45000 records roughly. Both the tables has 3 years of data and roughly the data count is around 35 million.

Due to the nature of the grain if I combine these flattened tables, it becomes a cartesian join and the performance would be worse. So following are the steps taken:

1. Removed the unwanted columns from the silver layer and moved the refined tables to gold layer:

Student Data Source(81 columns)

Course Data Source (119 Columns)

2. Created bridge tables as below to filter both the data sources on a common slicer

Dim School - union of distinct schools from both the data source

Dim Department - Union of distinct department from both the data sources

Dim Student Level - Union of distinct Student Levels from both the data sources

Dim Term - union of distinct terms from both the data sources

I used the onelake mode semantic model instead of import or Direct query, due to the number of columns and the multiple snapshots.

Earlier, when I tried with import mode, I had delay issues in rendering the data to the report, whenever I made any changes to the datatype/renaming the values,

etc.

It took 45 minutes per change. So I opted for the Directlake mode, which helped in quick data rendering.

Question 1 - Is my approach correct?

Question 2 -

2.1 The dims I created are having blanks, but if I ignore the blanks, my totals match.

2.2 Although it is a union, I see some values missing.

Example: Student Data Source has an additional department Healthcare Management offering a Major, but that department is not in Course Data Source, as they don't offer any courses

when I list the department in a separate slicer, I see the Healthcare Management, but if I add them in a matrix adding school(from dim_school) and the department(from dim_department), and select the Student enrollment metric(built using student data source), healthcare management is missing. What could be the reason?

"How to translate elements per user language, alongside RLS by country"

ario0991 — Thu, 17 Sep 2026 15:52:49 GMT

I am working on a project to consolidate two Business Intelligence solutions into one, using Row-Level Security (RLS) based on the data's country of origin (Spain and Italy); I have a clear understanding of how RLS works. However, I am unsure about the translation aspect: how can I ensure that text boxes are translated according to the user accessing the report? The same applies to chart axes, titles, and report pages—how can I manage the translation of these various elements?

Horizontal Conditional Formatting in a Matrix

mathmontibeler — Thu, 17 Sep 2026 15:49:14 GMT

Good afternoon, everyone!

I'm having some difficulty implementing conditional formatting (heat map style) horizontally in a Power BI matrix.

By default, Power BI seems to calculate the heat map by column, but I need to clearly highlight when a specific product's volume (number of opinions) is increasing or decreasing over time.

My matrix is structured as follows:

Rows: Product
Columns: Month/Year
Values: Number of Opinions

What I need is a horizontal heat map, meaning I want to compare each product's values across time.

In this scenario, I'd like the color intensity to be calculated within each row, so that it's easy to see whether the volume for a given product is trending upward or downward throughout the months. However, the standard conditional formatting appears to calculate the color scale across the entire column, comparing products against each other for a given month.

Is there a way to make the color scale be calculated per row (product) instead of per column (month)?

Thank you in advance for any suggestions!

Diagnosing a slow Fabric Data Warehouse using the new skill

arthurfr23 — Thu, 17 Sep 2026 14:18:02 GMT

When a Fabric Data Warehouse slows down, the investigation usually means jumping between the Capacity Metrics app, Query Insights, and SQL pool diagnostics while manually correlating time ranges across three different tools.

Microsoft just shipped the SQL DW operations skill as Generally Available, you can find the official announcement here:

https://community.fabric.microsoft.com/t5/Fabric-Updates-Blog/Diagnose-Fabric-Data-Warehouse-workloads-with-the-SQL-DW/ba-p/5366102

I dug into what this actually changes in practice: how the skill consolidates capacity spikes, query regressions, and request failures into a single conversational interface, and where it still has blind spots worth knowing before you rely on it in a production incident. There is at least one behavior around time range correlation that surprised me during testing.

To do that, I wrote a full article, and would love to hear if others are already using this in their warehouse troubleshooting flow.

https://medium.com/@arthurfr23/diagnosing-fabric-data-warehouse-with-the-sql-dw-operations-skill-investigating-workloads-without-e4060fe8661e?sharedUserId=arthurfr23

PL-300 Discount | Is there anybody that could help me?

rene654 — Thu, 17 Sep 2026 14:10:01 GMT

Good morning!

My name is Rene, from Chihuahua, Mexico.

And I'm preparing myself for this awesome certification. I'm at 80% full course training complete, and I was looking at the price and it is a little bit hard for me to pay the full amount.

Is there a way for me to get a discount, I know there was some discounts before early this year, but I wasn't awared of them at time.

I'm preparing also for the AI-103 Azure certification.

I'm studying AI Engineer and have freeCodeCamp certificates although I know for Relational Bases PL-300 is the top of the gun.

Please also, feel free to prepare me for what's coming through in the exam if there is something I should be aware of.

Thank you Community!

The Finance Dashboard

MuhammadMuaaz — Thu, 17 Sep 2026 13:43:45 GMT

The Finance Dashboard | Power BI Project 📊

Excited to share my latest Finance Dashboard built using Microsoft Power BI!

This project focuses on Financial Data Analytics, Business Intelligence, and Interactive Data Visualization.

Key Features:

- Total Amount, Tax, Fees & Final Amount KPIs

- Country-wise Financial Analysis

- Company-wise Amount Analysis

- Transaction Status Monitoring

- Tax Analysis by Country & Company

- Year & Account Type Filters

- Interactive Dashboard Design

This dashboard helps transform raw financial data into meaningful insights for better business reporting and data-driven decision-making.

Tools:

Microsoft Power BI | Data Analytics | Business Intelligence | Financial Reporting

I am passionate about Data Analytics, Power BI, and turning data into actionable business insights.

Your feedback is welcome!

#PowerBI #PowerBIDashboard #DataAnalytics #BusinessIntelligence #FinancialAnalytics #DataVisualization #FinanceDashboard #PowerBIDeveloper #DataAnalyst #MicrosoftPowerBI

Hide column in chart instead of filtering?

MKyger — Thu, 17 Sep 2026 13:15:28 GMT

I have a chart in Power BI that summarizes responses to multiple agreement statements. (If someone selected "Strongly agree" or "Somewhat agree" in the survey to one of the statements, that column % increases.) However, I am unable to hide the column which has the percent who did not agree without changing the percentages in the other columns. I can absolutely filter out "No", but that will show incorrect results.

How do I simply hide an option in a chart without filtering the rest of the data based on it?

DP-700 Fabric Data Days voucher

Salman_Nasir — Thu, 17 Sep 2026 10:47:18 GMT

I have successfully rescheduled my DP-700 exam to October 20, 2026. Pearson VUE confirmed the appointment and the order status shows “Purchased.” My Fabric Data Days voucher email, however, says “Take exam by September 30, 2026.” Could a Community Manager please confirm that my October 20 appointment will still be honored?

DP-700 Fabric Data Days voucher – exam scheduled after “Take exam by” date

Ahtishamishtiaq — Thu, 17 Sep 2026 10:26:32 GMT

Hi, I received a Microsoft Fabric Data Days exam voucher.

The email says:

Redeem voucher by: August 25, 2026

Take exam by: September 30, 2026

I have already scheduled my DP-700 exam for October 20, 2026, and Pearson VUE accepted the voucher successfully.

Since my exam date is after the "Take exam by" date mentioned in the email, I just want to confirm:

Will my October 20 exam appointment still be honored and will the voucher remain valid for this scheduled exam?

Thank you.

Unable to activate Microsoft Fabric trial capacity

NilotpalRay — Thu, 17 Sep 2026 10:15:46 GMT

Hi Microsoft Fabric Community,

I am trying to activate the Microsoft Fabric 60-day trial for a new personal Microsoft tenant, but the Fabric trial capacity is not being provisioned.

Here is what I have already checked:

1. The Microsoft Fabric trial-related tenant settings are enabled.

2. "Users can create Fabric items" is enabled.

3. "Users can try Microsoft Fabric paid features" is enabled.

4. I have a Power BI Individual Trial showing 59 days remaining.

5. In Fabric, the "Start Fabric trial" option is available.

6. When I click "Start Fabric trial", I select the default Central India region and click Activate.

7. I am redirected to Admin portal > Capacity settings > Trial, but no trial capacity appears.

8. The "Start Fabric trial" button remains available.

9. I also tried starting the trial by creating a Lakehouse from My workspace, but received this error:

"Something went wrong. Sorry, we are unable to start trial at this time."

Error details:

Activity ID: 8b5e475c-63bd-43b6-b756-2f5ac4cc5529

Request ID: cc8646ad-898f-47a0-9de3-a12839f34212

Correlation ID: c93727aa-b4b6-933a-aeb8-01c31f5f5c62

Status code: 200

Could someone please help determine why the Fabric trial capacity is not being provisioned and what I need to do to activate the trial?

Thank you.

Test Thread

v-csrikanth — Thu, 17 Sep 2026 09:57:27 GMT

Hi
I am looking for powerbi learn documents which is useful for beginers.
As this is the test thread.

Thank you.

Showing working day no instead of calendar

Nicpet0 — Thu, 17 Sep 2026 09:37:38 GMT

Hello,

i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no.

Data model setup:

Base model: Tabular (storage mode: mixed)
tables and dimensions used:
'Calendar'[ID] - linked to transaction table through a many to one relationship
'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month
'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june
'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june
'Global Measures'[Invoiced Amount]

Requirements:
Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends.

So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.

Gateway Upgrade / Installation - Rebind datasources

KarenL7 — Thu, 17 Sep 2026 09:01:06 GMT

I have had a issue with an upgrade and had to reinstall the gateway due to a recovery key issue

I am now having reset up the datasources to point the gateway - but is there a way I can do this in python or powershell - as I am unable to this in the service as below

I want to go from PowerBiGatewayA > PowerBIGatewayB

I can see there is a some APIs/ rebind source scripts but not sure which one will update these datasources in the service.

I am not worried about doing a bulk update if needs be fo authenication just a change in the cluster

Any help appreciated.

Thanks

Karen

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

Fabric Sign-up Blocked: Error Code 715-123280

ramana1642 — Thu, 17 Sep 2026 06:26:20 GMT

Hello, I am trying to sign up for a Microsoft Fabric free account using my school email address, but the registration is failing with a strict backend security block. Since this is an institutional student email, I do not have tenant administrator rights to log a ticket inside the Admin Portal. Could a Microsoft support engineer please review my transaction on the backend and whitelist my request? Here are the technical details of my failed registration attempt: Error Code: 715-123280. EventId: 031dc695-9d84-44a8-b9f5-486781460ac2. SID: ce8ccc43-ca45-49aa-942e-bef0462c33f5. cV: lbHkN7L2eitBrc57DtDFuH.0.4. Thank you for your assistance in unlocking my access so I can use Fabric.