Developer topics

How to add RLS on top of FUAM datasets

TobNyg — Mon, 14 Sep 2026 13:42:15 GMT

We are testing the FUAM reports and would like to share some of them with workspace administrators.

To achieve this, we want to implement RLS so that workspace owners can only see data for the workspaces they own.

I tried creating a composite model with an RLS security table containing User and WorkspaceName, and created a relationship to the Workspaces table.

However, the filtering does not seem to work properly for the Workspaces table, which is running in DirectQuery mode.

Has anyone implemented RLS for FUAM before, and if so, what approach would you recommend?

How to automatically export a PBI screenshot for the latest month?

SRJPBI — Mon, 14 Sep 2026 10:55:04 GMT

I have a Power BI report published in the online service. It automatically refreshes via a schedule. I now want to set up a scheduled process which automatically emails a screenshot of the report to certain people.

I know I can do this by setting up a subscription, but here's the tricky bit: the report has a couple of slicers for year and month. So if I set up a subscription with the slicers set to August 2026, then the screenshots will keep showing August 2026 unless I manually update the slicers.

Is there a way for me to have the slicers automatically update before the screenshot is emailed out?

I have access to Power Automate Desktop if that helps.

How to Configure Scheduled Refresh in Power BI for Data Connected via Zoho People API?

Agni2171 — Fri, 11 Sep 2026 07:24:51 GMT

Hi Community,

I have connected Zoho People API data to Power BI using Power Query (API calls), and the data refreshes successfully in Power BI Desktop. However, I am facing challenges when configuring Scheduled Refresh in the Power BI Service.

The main issue is that the Zoho People access token expires every hour. When the token expires, the API calls fail, causing scheduled refreshes to stop working.

I'm looking for advice on the following:

What is the recommended approach for implementing scheduled refresh with Zoho People API in Power BI Service?

How can the access token be refreshed automatically before it expires?

Is it possible to use a refresh token within Power Query or Power BI Service to generate a new access token during each refresh?

Does this scenario require an On-premises Data Gateway, Azure Function, Power Automate, or another middleware solution?

Are there any best practices for handling OAuth 2.0 token expiration when connecting to APIs from Power BI?

Has anyone successfully implemented automated scheduled refresh for Zoho People API data? If so, could you share your architecture or approach?

Current Setup:

Data Source: Zoho People API

Connection Method: Power Query Web/API calls

Authentication: OAuth Access Token

Token Validity: 1 Hour

I would appreciate any guidance, sample implementations, or documentation that explain how to handle token renewal for Zoho People API integrations with Power BI scheduled refresh.

Dax - Execute Queries/RLS

marcio_fornari — Tue, 08 Sep 2026 23:33:06 GMT

It's possible execute dax query against dataset with RLS to Power BI Embedded?

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

To Power BI Embedded my users not need power bi account, this example works only with power bi account.

{ "queries": [{"query": "EVALUATE VALUES(MyTable)" } ], "serializerSettings": {"includeNulls": true }, "impersonatedUserName": "someuser@mycompany.com" }

i would like send the Rule and the username together with dax query.

Power BI Embedded registers blocked unload handler in Microsoft Edge

codijk — Tue, 08 Sep 2026 11:05:37 GMT

We embed Power BI reports in an ASP.NET Core Blazor Server application. Microsoft Edge 152 logs this warning whenever an embedded report is loaded:

[Violation] Permissions policy violation: unload is not allowed in this document.

The report itself renders correctly. The warning originates in the Power BI hosted reportembed script, not in our application code. We tested the available Permissions-Policy header and iframe allow configurations. The embedded Power BI frame remains unable to use unload in every case.

Is this expected during the Chromium unload deprecation rollout? If so, is there a planned change to replace the unload listener with a supported page lifecycle event?

Environment: Microsoft Edge 152.0.4191.66, ASP.NET Core Blazor Server, Microsoft.PowerBI.JavaScript.

Submission process for Certified Connectors

BreannaNery — Sat, 05 Sep 2026 00:44:40 GMT

I'm one of the owners of a certified connector (Autodesk Forma). Historically, we've been instructed to submit updates for our certified connector over email.

We submitted an update for our certified connector in July 2026 and have yet to receive a response from our usual contacts. Has any changes been made to the certified connector submission process?

PBIP Report page fails to render after adding custom visual via Power BI authoring API

KumbharM — Thu, 03 Sep 2026 07:25:43 GMT

Environment:

Power BI Desktop: August 2026 (version 2.157.xxx, PBIR format with PBI_enhancedReportFormat enabled)

Format: PBIP (Power BI Project) — PBIR mode

Authoring method: Fabric MCP / Power BI Authoring Skill (programmatic JSON file generation)

OS: Windows 10/11

What I am doing

I am using the Microsoft Fabric MCP server and Power BI authoring skills to programmatically scaffold PBIP projects and add visuals by writing visual JSON files directly under:

MyReport.Report/

└── definition/

└── pages/

└── {pageId}/

├── page.json

└── visuals/

└── {visualId}/

└── visual.json

I add standard built-in visuals (barChart, donutChart, treemap, columnChart, tableEx, card) using schema 2.12.0 and register each visual ID in the visualContainers array in page.json.

What I expect

Power BI Desktop opens the .pbip file and renders all visuals on the page correctly — the same behaviour as when visuals are added interactively through the UI.

What actually happens

After adding custom visuals (e.g., from AppSource or .pbiviz files) programmatically and registering them in page.json, the entire report page fails to render. The error shown is:

"An error occurred while rendering the report"

Inspecting the browser console (via PBI Desktop's developer tools) shows:

Cannot read properties of undefined (reading 'visualContainers')

Even though visualContainers is correctly populated in page.json, the page renderer crashes when encountering a custom visual whose type string (e.g., Gantt1448688115699) is not recognized by the locally available visual registry at render time.

The crash is not isolated to the custom visual itself — it takes down the entire page, preventing all other standard visuals from rendering too.

Steps to reproduce

Create a PBIP project with PBIR format (modern definition/ structure).

Add 5 standard visuals (card, barChart, donutChart, treemap, tableEx) via JSON files — all render fine.

Add 1 custom visual (AppSource, e.g., Gantt or Chiclet Slicer) via a JSON file with "visualType": "<customVisualTypeName>".

Open the .pbip in Power BI Desktop.

Result: Entire page is blank. The JavaScript error Cannot read properties of undefined (reading 'visualContainers') is thrown.

Expected: Custom visual shows a placeholder/error tile; remaining 5 standard visuals render normally.

exportToFile: reportLevelFilters AND a single-select slicer's default value → empty page

Ceo_psh — Wed, 02 Sep 2026 10:44:57 GMT

**Setup:** Power BI Service, workspace on Fabric capacity (not PPU). Export via `exportToFile` (PPTX) from Power Automate. Server-side only — no JavaScript embedding, so `bookmarksManager.capture()` and `report.reset()` are not available to me. Report-level filters work correctly on pages without slicers on the filtered column. **Problem:** on a page with a slicer that has **Require single selection** enabled, the slicer keeps its saved default value, and my filter is applied on top of it. Since both conditions target the same column and the values differ, the intersection is empty and the page exports blank.

"powerBIReportConfiguration": {
"pages": [ { "pageName": "ReportSectionXXXX" } ],
"reportLevelFilters": [
{ "filter": "MyTable/MyColumn eq 'A'" }
]
}

Slicer default is `'B'`. Result: empty page. The only value that exports correctly is `'B'` —the one the slicer already holds. I understand *why* this happens: a report-level filter narrows the values available to a slicer but never changes the slicer's selection, and preexisting filters combine with the new filter using AND. With single selection enabled, the slicer can never be cleared, so the conflict is unavoidable from the report's default state.

**What I'm asking:** is there anything on the API side that resolves this without editing the report?

Can `defaultBookmark` or `pages[].bookmark` override the slicer's selection during export, or is single selection a formatting property of the visual that a bookmark cannot affect?

2. Is the precedence between a bookmark and `reportLevelFilters` documented anywhere? The only statement I've found is that export filters are applied *in addition to* the current report state, which reads as AND.

3. Is there any payload option that exports a page as if the slicer weren't there — a server-side equivalent of `report.reset()`?

4. Would moving the field into the "Filters on this report" pane change how the export resolves the conflict?

If the answer is "no API-side option exists", a confirmation I can point to would already help — the remaining path is a report-side change (disabling single selection, or an export-only copy of ,the page without the slicer)

Power BI Embedded: Multiple Users Seeing the Last Logged-In District's Data

Bhavik13101991 — Tue, 01 Sep 2026 17:53:19 GMT

Hi,

We have a Power BI report embedded in our .NET application. We use DirectQuery, and our SQL Server production environment contains around 1,800 databases. In Power BI, we pass a database parameter to connect the report to the appropriate district's database.

Each user belongs to a specific district, and the report should display data only from their respective district/database.

We are facing an issue when multiple users log in at the same time.

For example, User A logs in from District A, and the report connects to the District A database and displays the correct data.

Then User B logs in from District B, and the report connects to the District B database.

After User B logs in, User A also starts seeing District B data.

It appears that the last-loaded database parameter value is being used by all users instead of maintaining a separate database parameter value for each user's embedded report session.

We are using Power BI Embedded with a .NET application and DirectQuery, with approximately 1,800 SQL databases in production.

What is the recommended approach for this scenario? How can we ensure that each user's embedded Power BI report independently uses the correct database parameter without affecting other users?

Would Dynamic RLS, effective identity, separate embed tokens, or another Power BI Embedded approach be appropriate for this architecture?

Any guidance on how Power BI handles parameters and DirectQuery connections for multiple concurrent embedded users would be greatly appreciated.

Thanks!

Fabric keeps deleting files!!

alloowishus — Tue, 01 Sep 2026 17:16:07 GMT

THis has happened several times already, a couple of times I didn't have GIT setup yet and lost work. This time at least I had GIT setup in my workspace so I was able to recover the files. What is Fabric deleting files?

Any news when Power BI MCP server will be GA?

Johag — Wed, 26 Aug 2026 08:27:43 GMT

I have tried the modelling MCP server but would very much like to also try out the Power BI Remote MCP.
At the moment its a Preview-feature. Haven't found any info about this in the roadmap, anyone read when its likely to go GA?

Consolidation of Data from existing reports

RobRayborn — Thu, 20 Aug 2026 11:37:28 GMT

I've created about 20 Power BI reports for 20 different customers.

Because the data provided by the 20 customers is different, or provided in different formats, each is it's own report with it's own semantic model. Each one of these reports does carry some common datasets.

I now need to consolidate all 20 into one report so that I can pull all the data into a Matrix by Customer and Product are in rows and Month & Year as well as Quarter & Year are in columns, like the individual reports.

I started by importing the semantic models one at a time into a new Power BI report. These imported fine, but it also brought in the Common data for each report as well, Like the Date table, and the Product table. I don't need these in there multiple times, just once and I can pull these in separately. I just need the base data, the customers' data, and it won't let me delete the Common tables.

How to make Power BI Slicer to show the latest forecast selected when the report loads

kaysunda — Wed, 19 Aug 2026 15:49:17 GMT

I have a request to show the latest Forecast selected as a default slicer when the report loads.. every 3 months new forecast will come. 2026_F1, 2026_F2, 2026_F3 like that, The slicer is a single select when the report loads the selection should be latest and the user can change the visuals will change accordingly. I use a calculated column in power bi to add a new column that will have values2026_F1, 2026_F2, Latest...... When new forecast comes 2026_F1, 2026_F2, 2026_F3, latest like that.. and i made the default selection as Latest. The user doent want to see the word latest he wants to see the forecast name instead of the workd Latest. How to do it. I know bookmarks is an option but we have so many bookmarks in that report and doesnt want to use that one .

PowerBI Workspace Not Found" Issue

mahendra9490 — Tue, 18 Aug 2026 12:30:27 GMT

Hi Team,

I am trying to deploy a thin report to a Power BI workspace using a Service Principal. However, I am receiving the error "Power BI Workspace Not Found".

The Service Principal has Admin permissions on the target workspace, and I am passing the correct workspace ID in the API request.

Has anyone encountered this issue before? Are there any additional permissions, configurations, or prerequisites that I should verify?

Any guidance would be greatly appreciated.

Thanks.

pbivisuals.powerbi.com server failure

dapster105 — Mon, 17 Aug 2026 14:34:43 GMT

We're using PBI Embedded with some certified custom visuals including Plotly.

These custom visuals have stopped displaying recently and we've traced the problem to simple GET calls on pbivisuals.powerbi.com returning data so incredibly slowly that the visual times out.

Occasionally that server will return the requested json definition (all 38MB of it) in 150ms. But the vast majority of times it will respond at less than 10kb per second (or not at all) and the request will ultimately time out.

This is very easy to replicate in any browser by trying to access the Plotly visual definition directly:

https://pbivisuals.powerbi.com/plotlyJSVisualEEDDFAAB4619388784AE7972BC162ECDFAAB46196.2.1.0.0.cc6d7a5f02f9a7ef6a04543a2a66140847cec0ac298cbe8d7eb853fead875102.pbiviz.json

We've tested fetching this via VPN across multiple global locations, via different browsers on different machines etc and is is almost always paralyzingly slow.

Is anyone able to suggest how to get Microsoft to look at this?

Just to reiterate, our production reporting platform is effectively down atm because of this server-side issue.

Thanks for any assistance you can offer!

Dataset Refresh REST API returns 415 "Model-based dataset" error

ZachChin — Mon, 17 Aug 2026 02:08:06 GMT

Since 2026-08-14, calling the Refresh Dataset REST API (POST /v1.0/myorg/groups/{workspaceId}/datasets/{datasetId}/refreshes) on any dataset in my tenant fails with:

HTTP 415 UnsupportedMediaType

{"error":{"code":"InvalidRequest","message":"Invalid dataset. This API can only be called on a Model-based dataset"}}

This happens even on datasets that refreshed successfully via this exact API for weeks before that date, without any changes to the dataset itself. Manual "Refresh now" via the Power BI portal UI still works fine on the same datasets — only the REST API call fails.

What I've already ruled out:

Not a client bug — reproduced identically with curl using the same bearer token, bypassing my application entirely.

Not just a POST/trigger issue — a plain GET /datasets/{id}/refreshes (listing refresh history) fails with the same error.

GET /datasets/{id} succeeds fine and returns "isRefreshable": false, even for a standard Import-mode, on-premises-gateway-connected dataset (targetStorageMode: Abf) that worked correctly before.

Not a capacity issue — my Fabric trial capacity shows Active/healthy.

Checked Service Health and Known Issues in the Admin Portal — nothing matching.

Possible trigger: the issue started the same day I added (then a few hours later removed) two unused Azure AD Application permissions (Tenant.Read.All, Tenant.ReadWrite.All) on my app registration for an unrelated experiment. It's been 3+ days since removing them and forcing a fresh sign-in, and the issue persists.

Has anyone else seen this, or does anyone know what could cause isRefreshable to flip to false tenant-wide like this? Happy to share more details (workspace/dataset IDs, full error bodies) if useful.

Power BI custom connector

VedantChauhan — Fri, 14 Aug 2026 05:27:22 GMT

I'm building a Power BI custom connector for an OData API and would appreciate some guidance from the community.

My connector currently allows users to select a table/entity and load data successfully. However, I'd like to enhance the user experience with two additional capabilities:

Filter Selection Dropdown
- Similar to the Advanced Options available in the built-in Web connector, I want to provide users with a dropdown (or similar UI control) to select predefined filter values before the data is loaded.
- Ideally, the selected value would be passed as an OData filter parameter to the API request.
- Is there a supported way to create dropdowns or dynamic parameter selection screens in a custom connector?
Back Navigation / Re-selection of Table
- After a user selects a table/entity, I'd like to provide a way for them to go back and choose a different table without having to restart the connection process.
- Is there any concept of a "Back" button or navigation flow within Power Query custom connectors?
- If not, what is the recommended approach for handling multi-step selection scenarios?

I've reviewed the custom connector documentation but haven't found clear examples covering these UI/navigation requirements.

If anyone has implemented something similar or can point me to relevant documentation, sample connectors, or best practices, I'd be very grateful.

Thanks in advance!

Can we improve relationship arrow rendering in the semantic model view?

kevincron — Wed, 12 Aug 2026 19:19:12 GMT

There are multiple issues with the way relationship arrows are rendered, and this image displays a few of them:

(Note: I am using the web interface, via Edge.)

Is there anything I can do to combat this confusing display pattern? An arrow that points ambigiously is worse than no arrow at all.

If anyone in power is reading: please either give us more control over how these are rendered or make them behave logically.

Example: in the first and last relationships shown above, I know that the arrow has rotated because the connecting lines are not perfectly aligned, but these lines should automatically align vertically as the others have and the arrow should only rotate if there are visible horizontal connectors extending out its sides.

Dynamic Refresh Period Per Firm - Date Slicer Shows Global Range Instead of Firm-Specific Range

yazdanb — Wed, 12 Aug 2026 14:15:15 GMT

Hey all,

I have a transactions dataset with multiple firms where each firm needs a different data retention period. Firm A needs 12 months of history, while Firm B needs 15 months. Users are scoped to one firm at a time via RLS.

The issue: Even though the fact table correctly loads firm-specific months from Snowflake, the date slicer shows the same global date range (15 months) for both firms.

Current Setup:

Parameters:
- RefreshPeriod = "12" (default months)
- RefreshPeriodOverrides = "FirmB:15" (firm-specific overrides)
- FirmRefreshCaseSQL = generates CASE WHEN FIRM_KEY = [FirmB] THEN -15 ELSE -12 END
- MaxRefreshPeriod = "15" (max across all firms)
Data Loading:
- Transaction fact table: Uses FirmRefreshCaseSQL in WHERE clause, correctly loads 12 months for Firm A and 15 months for Firm B
- Calendar dimension: Uses MaxRefreshPeriod, loads 15 months globally
Relationships:
- Transaction[Transaction Date] → Calendar[Transaction Date] (many-to-one, single direction)
- Transaction[FIRM_KEY] → Firm[Firm ID] (many-to-one)
Date Slicer:
- Bound to Calendar[Transaction Date]

Expected Behavior:

When Firm A is selected: slicer shows last 12 months
When Firm B is selected: slicer shows last 15 months

Actual Behavior:

Both firms show last 15 months because the calendar dimension is global and doesn't know which dates belong to which firm

What I've Tried:

✗ Setting parameter overrides at the report level - didn't propagate to semantic model
✗ Testing with measures - confirmed fact data is correct per firm, but slicer uses calendar dimension
🔄 Current approach: Adding a "Firm-Date Availability Bridge" table with distinct (FIRM_KEY, Transaction Date) combinations to enable filter propagation: Firm → Bridge → Calendar

Questions:

Is a bridge table the right approach for this scenario, or is there a simpler pattern?
Should I consider making the Date↔Transaction relationship bidirectional instead? (Concerned about RLS implications)
Are there any DAX-only solutions that don't require model changes?
Has anyone solved firm-specific date filtering without loading separate datasets per firm?

Any guidance would be appreciated! Thank you!

Archivos de Adobe incrustados en la aplicación powerbi

g_manrique — Fri, 07 Aug 2026 19:47:47 GMT

En la aplicación de powerbi tenía publicados unos vínculos que hacían referencia a archivos adobe y no tenía ningún problema, los podía visualizar correctamente en la misma página de la aplicación, pero ahora me está apareciendo el error que adjunto y no sé si es problema de la aplicación, del adobe o de permisos de mi institución. Alguien tiene alguna sugerencia o idea?