rss.livelink.threads-in-node

Power BI Service Home – Recent items sometimes not showing

manoj_0911 — Wed, 16 Sep 2026 12:32:43 GMT

Hi Team,

I'm facing an intermittent issue with the Power BI Service Home page.

Normally, under Home → Recent, I can see the reports and workspaces that I recently opened, along with the Opened time and Location.

However, sometimes the Recent section does not show the recently opened reports/items, even though I have opened reports normally.

Issue:
The Recent list is sometimes empty/not populated or doesn't appear to update.

Environment:

Power BI Service (Web)
Browser: Microsoft Edge / Google Chrome
Issue is intermittent
Reports are located in Power BI Workspaces

Has anyone else experienced this issue with the Power BI Service Home → Recent section?

Is this related to a Power BI Service issue, browser/session/cache issue, or some limitation with how the Recent list is populated?

Any information on how the Recent list is generated and how to troubleshoot this would be appreciated.

I'd also attach the screenshot you sent me and circle the Recent section.

Best Practice for CICD Deployment Connections in Fabric UDFs?

david_avgarcia — Wed, 16 Sep 2026 12:21:11 GMT

I recently faced a challenge with Fabric User Data Functions where environment-specific SQL connections need to be handled across Test and Production deployments (deployment pipelines do not update the connectionId )

My current approach is to register both connections in the UDF and use a Fabric variable to determine which one to use at runtime:

@udf.connection(argName="testsqlDB", alias="testsqldb") @udf.connection(argName="prodsqlDB", alias="prodsqldb") @udf.connection(argName="envConfig", alias="environmentConf") @udf.function() def FO_Subscribe_Unsubscribe(testsqlDB: fn.FabricSqlConnection, prodsqlDB: fn.FabricSqlConnection, envConfig: fn.FabricVariablesClient, IsUserSubscribed: int, UserEmail: str, FundingOpportunityID: str, FundingOpportunity: str) -> str: # Step 1: call stored procedure that inserts or delete rows from the subscription table try: connection = get_sql_connection(envConfig,testsqlDB,prodsqlDB) cursor = connection.cursor()

This seems to work well for now, although ideally Fabric would support deployment-time connection binding so that only a single logical connection alias is needed in the code.

I'm curious how others are handling CI/CD for UDF connections:

Are you using a similar pattern?
Is the deployment-time connection binding for UDF planned for the future?

Session diagnostics error

Matthew_Martell — Wed, 16 Sep 2026 12:17:55 GMT

Since the June 2026 version of power BI, if I enable 'Start Diagnostics' in the Tools menu of Power Query (for Query Editor only), I get an error when I refresh the data preview:

Container exited unexpectedly with code 0x80131623. PID: 5844.

This didn't happen on older versions, but I get the error in June and July 2026 versions. I haven't tried August - we haven't installed it on our tenant yet.

Has anybody come across this error before? It is a known bug that is fixed in later versions? Thanks

Snowflake schema

powerbiexpert22 — Wed, 16 Sep 2026 11:29:20 GMT

i need to convert snowlfake schema into star schema, the only way i can think is by denormalizing tables however i am not sure which tables i should consider for denormalization, also is there any other approach can be considered for conversion from snowflake to star?

Pearson VUE OnVUE Crash at 92% Check-in - DP-700 Exam - Voucher Expired

Rassai — Wed, 16 Sep 2026 11:14:25 GMT

Hello Microsoft Fabric Community,

I am reaching out for advice regarding a technical failure I experienced yesterday ( 15/09/2026 ) while trying to check in for the DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric exam.

During the Pearson VUE check-in process, the OnVUE software crashed exactly at the 92% mark (during the camera streaming check). The system completely locked me out and revoked my session before the exam could launch.

I immediately contacted Pearson VUE support, and they opened a technical case for me (Case Number: 42616814). However, the voucher I used to schedule this exam expires today (15/09/2026 ).

Has anyone experienced a similar OnVUE check-in failure recently? Can anyone clarify if Microsoft or Pearson VUE typically reissues expiring vouchers when a technical crash occurs on the platform's end on the final day of eligibility? Any guidance or escalation advice would be greatly appreciated.

Thank you, Rassai

Paste values in slicers for hierarchy data

eddieisking2000 — Wed, 16 Sep 2026 11:01:42 GMT

Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting values from Excel into the slicer search/paste box.

Today, pasted values usually match only the first (top) hierarchy level. This is a problem when users need to paste at a deeper level. For example, with a Product RCN > SKU Key slicer, users may want to paste a list of SKU values, but the slicer tries to match against RCN instead. Sometimes users paste RNs; sometimes they paste SKUs. The current behavior forces workarounds such as removing hierarchy, adding extra flat slicers, using the Filter pane, or building custom DAX logic.

Requested enhancement:

Add an option to control which hierarchy level pasted values should match.

Suggested options:

A slicer setting: "Paste match level" (Level 1, Level 2, Deepest level, etc.)
A user-facing control before paste: "Paste as: RCN" or "Paste as: SKU"
Optional auto-detect: match pasted values across hierarchy levels and select the best match

Example:

Slicer hierarchy: Product RCN > SKU Key

User pastes SKU-001, SKU-002, SKU-003 → slicer should select those SKUs
User pastes RCN-100, RCN-200 → slicer should select all SKUs under those RCNs
Ideally, users can choose the target level before pasting

Benefits:

Faster bulk filtering without workarounds
Keep hierarchy for browsing while supporting paste at the correct level
Less report complexity (fewer duplicate slicers and custom measures)
Better self-service for business users

Why this matters:

Current workarounds reduce usability and increase maintenance. A native "paste target level" option would make hierarchical slicers work for both exploration and Excel-driven bulk filtering.

Power BI M-Query with TVF execution issue

jishnubhattacha — Wed, 16 Sep 2026 10:25:06 GMT

Dear Team,

I have designed a report in Power BI it is art of a Tableau to Power BI migration. I have separated the visuals among three pages with drill through option. It is working as expected but facing a slowness. So I think to use a benefit of M-Query with TVF passing parameter values to make pushdown query. parameter value is a single parameter and accept a comma separated values from 1st page visual. However I have created TVF. TVF is executing properly in DB side. But when I create a bind parameter and associated with my column make it text and enable multi option to get multiple values . Now I write a code snippet

let

VP=if P_param= null or P_param= "" or P_param= "XXXX" then "ALL"

else if Value.Is(P_param, type list) then Text.Combine(List.Transform(P_param, Text.From), ",")

else Text.From(P_param),

SQL_Query = "SELECT * FROM MY_TVF('" & VP & "')",

Source = #table({"Generated_SQL"}, {{SQL_Query}})

Source

This code has been written to check whether the selected parameter from visual VP=1001 is passing properly in TVF.

Objective: 1. SELECT * FROM MY_TVF('1001,1002') (if multiple value selected from visual)

2. SELECT * FROM MY_TVF('1001') (if single value is sent)

But when I click from visual using drill through feature the TVF is showing always

SELECT * FROM MY_TVF('ALL') -

The drill through fields when I put in the 2nd page then it is showing proper values . but it is not passing in the TVF so query is not executed it returns blank.

My objective is from 1st page matrix visual when I select record one by one accordingly the value will pass and show the result.

In matrix 1st column is A1 and A2 is the second column. A1 & A2 are also in drillthrough bucket.

A1 can contain multiple A2. so when one A1 is selected then multiple comma separated A2 has been passed in TVF. A2 is an id field. and when A2 column it self selected then single value will pass. But value is not passing and I am not getting the benefit of query pushdown by M-Parameter. The A2 column is parameter binded. it is a text field. P_Param= A2. (bind to A2) . multiple accepted.

could you please check and provide any assistance?

I have tried all possible options but no results has been encountered.

Regards

Jishnu Bhattacharya

How do you decide between Dataflow Gen2 and Notebooks for transformation workloads?

ravee432 — Wed, 16 Sep 2026 10:15:11 GMT

At what point does transformation complexity, data volume, performance, or maintainability justify moving from Dataflow Gen2 to Spark?

Power BI - Sharepoint folder

Brianhungary — Wed, 16 Sep 2026 08:33:18 GMT

I would like to load a SharePoint folder that contains images into Power BI Desktop. These are the steps I followed:

I clicked Get Data.
I clicked More....
I selected SharePoint Folder.
I pasted the SharePoint site URL (https://xy.sharepoint.com/sites/Testsite).
After clicking OK, I received the following error message:

"The property 'ExtendedSharePointPermissionOfflineDaysForLibrary' does not exist on type 'SP.List'. Make sure to only use property names that are defined by the type."

I have the required permissions. In fact, I am the owner of the SharePoint site. I do not understand why this is not working.

So far, I have:

Installed the latest updates.
Restarted my computer.
Created a completely new PBIX file.
Signed out of and back into my m365 account.
Cleared the Power BI cache.

However, I still cannot get it to work and I have no idea what else I could try.

Does anyone have any suggestions or ideas about what might be causing this issue?

Thank you in advance for your help.

Make Copilot Approval status for semantic model available through API

FrançoisD — Wed, 16 Sep 2026 08:16:20 GMT

In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction.

However there is no specific way for external governance application to analyse which semantic model is approved and to approve one.

Can we have the property accessible either via a new endpoint or via the Get SemanticModel/List Semantic Models endpoint of fabric API and then change the status via the Update Semantic Model endpoint?

PowerBI dataflow not visible in PowerBI desktop

dillinger111 — Wed, 16 Sep 2026 07:47:33 GMT

On platform workspace I have multiple dataflows, all showing up and working when I try to connect to them from desktop app. yesterday I created new dataflow, same workspace, updated data, when I click on it in the platform it shows my data. But when I try to connect to it from the app it does not show up. all other dataflows are visible. gen1. what can be the problem?

Clone a workspace, including its data, to a new workspace

gclements — Wed, 16 Sep 2026 07:12:47 GMT

Description:

Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS CLONE OF explicitly doesn't work across workspaces; and the Fabric CLI's recursive workspace copy (fab cp -r) copies items one by one, not warehouse row data.

This is a real gap for teams running feature-branch or test workspaces provisioned from git — after standing up a new workspace, we have to hand-build separate pipelines/notebooks just to reload representative data, because there's no platform-native "clone with data" step. This is exactly the scenario dbt-style dev/test/prod parity workflows need too.

Ask: a first-class "Clone workspace" action (portal, REST API, and Fabric CLI) that provisions a new workspace with both:

All item definitions (as git sync/Deployment Pipelines already do), and
Their underlying data — Lakehouse Delta tables/Files (likely straightforward via OneLake), and Warehouse table data (even a physical copy would help, given cross-workspace zero-copy clone isn't supported).

This would remove the need for bespoke data-reload pipelines every time a team needs a fully working, data-populated copy of a workspace for testing or development.

Grand Total is WRONG but every single row in my matrix is correct??

Bob_Marley — Wed, 16 Sep 2026 04:20:59 GMT

I've got a matrix Product Category on rows, and a measure called Avg Margin % next to it. Every single row shows the right percentage when I check it against Excel. But the Total row at the bottom is showing some random number that's way off not an average of the rows, not a weighted average, just... wrong.

My measure:

Avg Margin % = DIVIDE([Total Margin], [Total Sales])

Total Margin and Total Sales are their own simple SUM measures and those total up fine on their own. It's only when I wrap them in the DIVIDE that the grand total breaks.

I tried changing it to AVERAGEX over Product Category but then the row values change too and now those are wrong. Is this a Power BI bug?

Best practice for loading Salesforce data into Fabric with deleted records

RMori95610 — Wed, 16 Sep 2026 01:53:21 GMT

Hi Fabric Community,

We are currently evaluating the best way to load Salesforce data into a Microsoft Fabric Lakehouse.

We would like to keep the implementation and ongoing operation as low-code as possible, and we are currently considering the following three options:

Dataflow Gen2 + Pipeline
- Use the Salesforce Objects connector in Dataflow Gen2 to retrieve Salesforce data.
- Load the data into a Lakehouse.
- Use a Pipeline to run the Dataflow Gen2 on a schedule.
Pipeline + Copy Activity
- Use the Salesforce Objects connector directly in a Copy Activity within a Pipeline.
- Copy Salesforce data directly into the Lakehouse.
Copy Job
- Use Salesforce as the source and the Lakehouse as the destination.
- If necessary, invoke the Copy Job from a Pipeline using a Copy Job Activity.

In addition to active Salesforce records, we also need to retrieve records that have been deleted in Salesforce and retain them in the Lakehouse with a deletion flag such as IsDeleted = true, rather than physically removing them from Fabric.

For example, we would like to preserve the Salesforce record state in the Bronze layer as follows:

Id	Name	IsDeleted
001	Company A	false
002	Company B	true

We would then update the latest state in the Silver layer using the Salesforce record ID as the key. For downstream use cases such as AI, we would normally use only records where IsDeleted = false.

For this initial implementation, we are not planning to use a watermark-based incremental load. Our current goal is simply to determine the most appropriate ingestion method from Salesforce into Fabric.

My current understanding is that the Salesforce source in Copy Activity provides an "Include deleted objects" option, so option 2 appears to support retrieving deleted Salesforce records.

However, I am not sure how the same requirement should be handled with Dataflow Gen2 or Copy Job.

I would appreciate your advice on the following questions:

If we want a low-code implementation and also need to retain deleted Salesforce records in the Lakehouse with an IsDeleted flag, which of the three approaches would you recommend?
Can Dataflow Gen2 retrieve deleted Salesforce records in a way equivalent to the "Include deleted objects" option available in Copy Activity? My understanding is that simply selecting the IsDeleted field may not be enough if deleted records are excluded from the Salesforce query itself.
With Copy Job, is it possible to retrieve deleted Salesforce records and retain them in the Lakehouse with IsDeleted = true? In this case, I am not asking about detecting deletes through watermark-based incremental loading or CDC. I would like deleted records to be included as part of the Salesforce data retrieval itself.
If there is another recommended low-code architecture for loading Salesforce data into a Fabric Lakehouse while retaining deleted records, I would also be interested in hearing about it.

If anyone has implemented a similar Salesforce-to-Fabric ingestion pattern in production, or knows the recommended approach in Microsoft Fabric, I would greatly appreciate your experience and advice.

Thank you in advance.

Allow NotebookUtils getSecret() to authenticate with Workspace Identity

tmihara — Wed, 16 Sep 2026 01:39:37 GMT

Current behavior

In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook.

This behavior applies not only to interactive notebook execution but also to pipeline and scheduled executions in our environment.

Problem

Many enterprise environments separate responsibilities across multiple teams:

- Fabric administrators

- Azure administrators

- Entra ID administrators

Because getSecret() uses the executing user's identity, every Fabric notebook developer and operator must be granted Azure Key Vault permissions individually.

This creates significant operational overhead and makes centralized credential management difficult.

We have already enabled Workspace Identity and assigned the required Azure Key Vault permissions to it. However, notebookutils.credentials.getSecret() still authenticates using the user identity instead of the Workspace Identity.

As a result, Workspace Identity cannot currently be used as a central security boundary for Key Vault access in Fabric notebooks.

Requested enhancement

Please provide an option for notebookutils.credentials.getSecret() to authenticate using Workspace Identity instead of the executing user identity.

Example:

notebookutils.credentials.getSecret(

vaultUrl,

secretName,

authMode="WorkspaceIdentity"

)

Provide a workspace-level setting that enables Workspace Identity as the authentication context for Azure Key Vault access.

Benefits

- Centralized permission management

- No need to grant Key Vault access to every developer individually

- Better alignment with Workspace Identity governance model

- Improved enterprise security and maintainability

- Easier migration from hardcoded secrets to Azure Key Vault

This capability would significantly improve real-world enterprise adoption of Azure Key Vault within Microsoft Fabric.

We verified that Azure Key Vault access succeeds when permissions are assigned directly to the executing user, but fails when only Workspace Identity is granted access. This confirms that Key Vault access is currently evaluated using the executing user's identity rather than the Workspace Identity.

Can a service principal with federated credentials be used for SQL cloud connection auth?

CharlieFab — Wed, 16 Sep 2026 00:00:14 GMT

Replacing OAuth 2.0 personal-account auth on our Fabric SQL cloud connections. Workspace identity doesn't fit, because semantic models in other workspaces share the same connection and each workspace has its own identity — those refreshes fail with invalid credentials unless every workspace identity is granted on the database.

A service principal solves that, but I'd like to avoid storing a secret. I added a federated identity credential to the app registration. In the connection settings, Service Principal auth only offers a key or a certificate, with nowhere to reference the federated credential.

Is that expected? I assume federation needs the caller to present a token it already holds, and the Fabric refresh engine has none — so it simply can't apply. Confirmation would be useful, as would any roadmap or Ideas link for secret less cloud connection auth.

If certificate is the answer, I'd also welcome hearing how others handle cert rotation across many connections given the encrypted payload on the update credentials API.\

Power BI semantic model refresh fails in Service, but Gen1 dataflow and Desktop refresh successfully

Teddddddddddddd — Tue, 15 Sep 2026 23:53:57 GMT

Hi everyone, my semantic model refresh fails in Power BI Service with this error:

DataFormat.Error: The input couldn't be recognized as a valid Excel document.
Microsoft.Data.Mashup.ErrorCode = 10311.
The exception was raised by the IDbCommand interface.

However:

The Gen1 dataflow refreshes successfully.
The model also refreshes successfully in Power BI Desktop.
I’ve reviewed the Power Query queries and couldn’t find any problems.

The failure appears to happen only when refreshing the semantic model in Power BI Service. What could cause this difference, and how can I identify the specific query or source triggering the error?

Error details:

Cluster: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 76273612-20ed-4ca2-988e-4f593db29fa5
Request ID: 42e32479-4c91-40cf-b83c-e1ebd9591dc4
Time: 2026-09-15 20:18:51 UTC

Any help would be appreciated.

Office 365 Outlook activity cannot bind Workspace Identity or Service Principal connection

vicenteajm — Tue, 15 Sep 2026 23:47:21 GMT

Hi Fabric Community,

I am testing the Office 365 Outlook / Office 365 Email activity in Microsoft Fabric Data Factory for a CI/CD scenario.

According to the current Microsoft Learn documentation, the Office 365 Outlook activity supports User Authentication OAuth, Workspace Identity WI, and Service Principal SPN.

I tested both Service Principal and Workspace Identity.

The Fabric workspace has an active Workspace Identity.

The corresponding Microsoft Entra application and service principal exist.

The Office 365 Email / MicrosoftOutlook cloud connection can be created successfully.

The connection is visible in Manage connections and gateways.

From the pipeline Outlook activity, the connection is also visible through Browse all.

The issue is that when I select the WI or SPN connection from Browse all, Fabric shows the loading indicator but does not bind the connection to the Outlook activity.

No error is displayed.

The problem occurs before pipeline execution, so this is not a Microsoft Graph Mail.Send runtime error.

Expected behavior:

The selected Workspace Identity or Service Principal connection should be associated with the Office 365 Outlook activity.

Actual behavior:

The connection is visible and discoverable, but selecting it does nothing and the activity remains without a connection.

This blocks our CI/CD scenario because we want to avoid user OAuth connections that must be recreated or rebound between DEV, TEST and PROD.

I also noticed a documentation inconsistency.

The current Office 365 Outlook activity documentation explicitly says that Workspace Identity and Service Principal are supported.

However, the general Service Principal support page does not currently list Outlook as a supported data source.

The general Workspace Identity support page also does not list Outlook among the supported data sources.

Can Microsoft confirm whether Workspace Identity and Service Principal support for the Office 365 Outlook activity is fully GA, under staged rollout, or currently affected by a known issue?

Microsoft Learn references:

Office 365 Outlook activity

learn.microsoft.com/en-us/fabric/data-factory/outlook-activity

Service Principal support in Data Factory

learn.microsoft.com/en-us/fabric/data-factory/service-principals

Workspace Identity support in Data Factory

learn.microsoft.com/en-us/fabric/data-factory/workspace-identity

I can provide additional diagnostics or tenant details privately if required.

Thanks.

Free Exam Vouchers - DP-600, DP-700 or DP-800

philippaburgess — Tue, 15 Sep 2026 23:31:20 GMT

Following up on Haider's Discussion Post:

Free Exam Voucher Interest Form

https://forms.gle/ErqTGaRw3m43yoYq7

Hide a Page within APP

Pooja_Kumar — Tue, 15 Sep 2026 21:24:44 GMT

Hi,

I have two level of users where
1. set of Users should access page1,2,3
2. set of Users should access page 1, 2

Any suggestions on how to achieve this without replicating the report in the Power bi App