New board topics in Microsoft Fabric Community

Post is taken down after ~ 1 minute.

dcrow5378 — Wed, 16 Sep 2026 16:40:46 GMT

I have a question about Power BI desktop canvas default layout that has somehow gotten changed. Every time I post my question it is taken down within about a minute.

How to submit a support ticket for Power BI issues.

dcrow5378 — Wed, 16 Sep 2026 16:37:07 GMT

Can anyone please advise how to submit a support ticket for issues with Power BI desktop?
Previously I went through the Power Platform admin center, but this is not working currently.

Employee Internal Communication Analytics | DataFlip

dataflip — Wed, 16 Sep 2026 16:12:05 GMT

Poor internal communication can create information gaps, disconnected teams, and slower decisions. When communication data is spread across different reports, leaders often struggle to understand how teams engage and collaborate. This dashboard brings internal communication data into one clear view, helping organizations improve engagement and workplace collaboration.

Business Impact:

This dashboard helps organizations:

Track email engagement, open rates, and sentiment
Understand communication patterns across departments and seniority levels
Identify communication trends by department, topic, and day
Monitor after-hours and weekend communication activity
Identify communication gaps and collaboration silos
Support better employee engagement and workforce decisions
Reduce manual reporting with centralized communication KPIs

It helps leaders understand communication patterns and build a more connected, engaged, and productive workplace.

Who Can Use This Template:

HR and People Operations Teams
Internal Communications Leaders
Department Heads and Senior Managers
Employee Experience Teams
Executive Leadership Teams

Discover more insight-driven templates built for real business decisions. Visit DataFlip

Heat or contour map visual

am_nr — Wed, 16 Sep 2026 16:06:53 GMT

Anyone have a nice solution for a heat map visual in Power BI? I find the heatmap settings on the default Azure Maps to be a bit lacking as it doesn't really reflect the density of points in an area. There used to be a very nice free visual literally called "Heatmap" but now you've to pay for a Bing Maps Enterprise key to use it. The "Data Map" visual also has a nice enough heatmap setting which I used to use with an Open Street Map base layer but now OSM keeps blocking access in PowerBI citing the tile usage policy.

Looking for suggestions, ideally free, or any indication that there's plans to improve the Azure map heatmap option.

Unable to Access Microsoft Fabric Trial

surajnimse — Wed, 16 Sep 2026 15:18:23 GMT

Hello Support Team,

I am facing an issue with the Microsoft Fabric trial on my tenant (ZOHOMAIL.IN).

- **Issue faced:**

I created a new account and attempted to start the Fabric trial. However, instead of the Fabric trial capacity being provisioned, only a **Power BI Pro trial** was activated. My goal was to use the Fabric trial to create and test Lakehouse functionality.

- **Steps taken to fix:**

1. I tried creating a Lakehouse, but received an error message related to trial capacity.

2. I attempted multiple troubleshooting steps, including checking the Admin Portal and workspace assignment options, but none resolved the issue.

3. Finally, I cancelled the free trial, hoping to restart it correctly.

- **Current issue still existing:**

After cancellation, I am unable to restart the trial. The **Start trial** option is no longer visible in the Account Manager panel. At present, neither the Fabric trial nor the Power BI Pro trial is available for my tenant. This prevents me from testing Fabric features such as Lakehouse creation.

Could you please help reinstate the Fabric trial for my tenant, or confirm if the only option is to create a new tenant to access the trial again?

Thank you for your assistance.

Best regards,

Suraj Nimse

Matrix with stacked bar chart and with column measures

ldwf — Wed, 16 Sep 2026 15:18:19 GMT

I am trying to build a matrix that will have a stacked bar chart as a column, together with two other columns (i.e, measures). See screenshot. The red/yellow/green colors are defined by a category field that is already defined in the model. Is a matrix like this even possible? Do I need to use svg codes inside of DAX measures?

Can I get confirmation from a PBI Admin that this is up to date?

grayscg — Wed, 16 Sep 2026 15:06:14 GMT

I have been given Power BI admin access recently by my organization. I am trying to find out how to create apps and pipelines from workspaces. I see this documention by microsoft:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

But I do not see those "create app" and "create pipeline" buttons shown. Is this documentation out of date and there is another way to do this? Or do I maybe not actually have the needed access yet?

Thank you

FABRIC REST API Connections - Create Connection

Charline_74 — Wed, 16 Sep 2026 14:29:45 GMT

Does anyone know how to run this API via a PowerShell script to create a SQL Server cloud connection for a semantic model using Service Principal authentication?

Here's what I have so far:

Invoke-PowerBIRestMethod -Url "https://api.fabric.microsoft.com/v1/connections" -Method Post -Body $body

But I don't understand how to construct the body

Thanks in Advance,

Charline

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

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.

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?

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.

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.\