rss.livelink.threads-in-node

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

Configure Dataflow Gen2

UncleLewis — Tue, 15 Sep 2026 20:31:27 GMT

Hi,

Using DataFlow Gen2
I don't see a gear icon anywhere near default destination so I can configure

What am I missing?
Thanks,
w

RDL Subscription Errors When Saving to SharePoint

MarkPalmberg — Tue, 15 Sep 2026 20:23:06 GMT

Hi.

I have a paginated report in an app. The app is permissioned to a couple groups of users. Those users can run the report and export the output via the app.

Those users permissioned to the app can also set up a subscription that sends the report output to them via email.

What the users can't do is specify a SharePoint folder in their subscription for the output of the report, even though the same permissions groups on the app have access to the SharePoint site. Here's the error the users get when trying to save the subscription:

I'm able to specify the SharePoint folder in question and execute a subscription that exports the report output successfully. The only difference between me and the users who only have app-level access to the report is that I'm in a group that has member access to the workspace where the app and report reside. I'm baffled that that difference would prevent users from being able to export to a SharePoint site, but...here we are.

Expose Refresh Warnings and Informational Messages via Notifications and API

Jashwanth_K — Tue, 15 Sep 2026 20:03:13 GMT

When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention.

Please provide the ability to:

Notify semantic model owners/admins when a successful refresh contains warnings or informational messages.
Expose these refresh warnings and informational messages through REST APIs, so organizations can programmatically monitor them and implement automated alerting.

This would help teams proactively identify service-side refresh issues without manually reviewing refresh history for every semantic model.

Improves proactive monitoring and enables automated enterprise-level alerting for refresh issues that do not cause the refresh to fail.

🚀 Microsoft Fabric — KQL Databases no Microsoft Fabric

Ladislauandre — Tue, 15 Sep 2026 19:38:43 GMT

🚀 Microsoft Fabric — KQL Databases no Microsoft Fabric

📅 9 de outubro de 2026
🕗 20:00 — Hora de Portugal (Lisboa)
💻 Online — Microsoft Teams
🌍 Idioma: Português

Como podemos trabalhar com dados de eventos e grandes volumes de informação no Microsoft Fabric?

Neste encontro vamos explorar as KQL Databases, uma capacidade do Microsoft Fabric orientada para a análise de dados em cenários que exigem consultas rápidas e eficientes.

🔹 KQL (Kusto Query Language) — uma linguagem poderosa para explorar, analisar e obter insights a partir de grandes volumes de dados.

🔹 KQL Databases — bases de dados otimizadas para cenários de análise, especialmente úteis para dados de eventos, logs, telemetria e outros dados que

necessitam de exploração rápida.

Durante a sessão, vamos conhecer o conceito de KQL Databases, perceber onde se enquadram na arquitetura do Microsoft Fabric, explorar a utilização da KQL e analisar os principais cenários em que esta tecnologia pode ser utilizada.

🧪 Laboratório prático

A sessão será acompanhada por um laboratório baseado no artigo:

Kusto Query Language (KQL) Databases in Microsoft Fabric

🔗 Abrir laboratório no MSSQLTips

👥 Speakers

🎤 Shalom André

🎤 Fernanda Castro

🎤 Abel Wanda

Esta sessão faz parte da nossa sequência de laboratórios práticos de Data Warehouse, Data Engineering e Microsoft Fabric, com foco em conceitos e tecnologias importantes para quem trabalha ou pretende trabalhar na área de dados.

💡 Se queres conhecer melhor as KQL Databases e perceber como podem ser utilizadas no Microsoft Fabric, esta sessão é para ti.

#MicrosoftFabric #KQL #KustoQueryLanguage #KQLDatabase #DataEngineering #DataAnalytics #MicrosoftFabric #FabricLusófono

How to display images from Dataverse on Power Bi Report Builder

Fern_21 — Tue, 15 Sep 2026 19:10:57 GMT

Hi all!

On Power BI Report Builder I need to display images I have on Dataverse. What format should they be in? Base64? Also, I should be able to change the images based on the filters I select. Is it possible? Thank you so much

Moving off ODBC — A self-serve scanner for your ADBC migration

MichaelaIsaacs — Tue, 15 Sep 2026 19:00:00 GMT

If your Fabric workspace connects to an ODBC driver, and you haven’t already moved to the ADBC driver, you’re on the ODBC → ADBC migration path. The migration window is already open — the sooner you start, the more room you have to validate.

What’s happening

Power Query is transitioning from legacy embedded ODBC drivers to Apache Arrow Database Connectivity (ADBC) drivers across Power BI Desktop and the Microsoft Fabric service. ADBC keeps data in the Arrow columnar format end-to-end, which can improve performance and reduce memory overhead for many workloads.

The migration happens in two events per connector:

The default flip. ADBC becomes the default driver for new connections. Existing connections keep working on ODBC unless you touch them. This flip is what opens your validation window.
The cutover. ODBC is disabled in the service. Every connection — new and existing — routes to ADBC from that point on. Anything that hasn’t been validated by cutover risks refresh failure.

Per-connector dates for both events are available on the public migration guide. That’s the source of truth for timing and the document to read first.

An accelerator for the inventory step

The ADBC driver is available in Power BI Desktop today, and the per-item fix is usually a connector-refresh action with no republish or re-auth for most setups.

Enterprise environments with hundreds of semantic models, dataflows, and Data Pipelines take longer to inventory. Items pinned to Implementation="1.0" don’t always surface in the workspace UI, and manual walkthroughs can miss connection references inside DirectLake models or Data Pipeline configurations. To make that inventory step faster, we created an additional tool: pq-adbc-advisor.

Figure: The pq-adbc-advisor impact report rendered inline in a Fabric notebook. Two cells — the pip install and a single call to scan_workspace() — followed by the rendered impact report with connector-by-connector adoption pills, a per-item table with cutover risk classification (Will fail / Needs review / Ready), and a recommended action for each row.

The impact report rendered inline in a Fabric notebook after a single call to scan_workspace().

Your migration in four steps

The tool is designed to be the first step of a successful migration — not a scan you run and put away.

Scan your workspace. Run pq-adbc-advisor and get a per-item report showing which semantic models, dataflows, and Data Pipelines still pin the legacy ODBC driver, classified by cutover risk (Will fail / Needs review / Ready). Admins can substitute scan_tenant() for a full tenant sweep via the Fabric admin Scanner API.
Fix the Will fail items first. These are the items pinned to Implementation="1.0" with no gateway to fall back on. At cutover, their refreshes stop. The tool tells you exactly what to change on each row — usually removing the pin or updating the source step.
Validate on ADBC in a pilot workspace. Enable the tenant setting Users can connect to data sources by using Apache Arrow database connectivity (ADBC) in the Fabric Admin portal (Admin portal → Tenant settings), refresh your top-usage models on ADBC in a non-production workspace, and compare row counts, column types, and refresh duration against your ODBC baseline. Full details are available in the migration guide. This is your dress rehearsal for cutover.
Re-scan, confirm you’re clean, promote to production. Re-run the notebook after each pass of fixes. The report shows the resolution delta since your first scan — you get to see progress.

Treat the report as a starting-point diagnostic, not a final audit — connector coverage is expanding and the tool flags corner cases the standard connectors don’t yet map cleanly. To share corner cases, email adbcmigration@microsoft.com to help us prioritize what to build next.

What it does

Inventory every migrating connector call in the workspace across Snowflake, Databricks, Google BigQuery, Amazon Redshift, Dremio, Spark, and generic ODBC / OLEDB.
Classify each item by cutover risk — "Will fail", "Needs review", or "Ready". Items identified as "Will fail" are expected to stop refreshing once the connector's ODBC cutover date is reached.
Recommend a fix per row — the specific action to take, not a warning.
Track resolution across scans — every re-scan carries a first-run baseline and a current-run counter so you can see what’s been cleaned up since the first pass.

What it doesn’t do

Rewrite any M expressions
Trigger refreshes on its own
Send any M code, item names, endpoint URLs, credentials, or refresh error message bodies outside the workspace

Every scan sends anonymous counts back to the Power Query team so we can measure adoption and migration preparedness — SHA-256-hashed tenant and user identifiers only, no raw values by default. Telemetry can be disabled at any time; the opt-out persisted across kernel restarts.

Get started

Get the starter notebook: download from GitHub, import into a Fabric workspace, and run top-to-bottom.
Explore the migration guide (dates, per-connector detail): Transition from ODBC to ADBC drivers in Power BI and Fabric
Email us corner cases the tool flags, but the standard connector doesn’t cover: adbcmigration@microsoft.com

Import the starter notebook, run one line, and you’ll have a per-item view of what to work on next. Take a look at your workspace’s impact report today so you can plan your migration path with plenty of runway ahead of the per-connector dates outlined in the migration guide.

Global Aircraft✈️ Live Tracking with Microsoft Fabric Real-Time Intelligence

suparnababu8 — Tue, 15 Sep 2026 18:35:00 GMT

In this blog, I’ll walk you through, build a real-time global flight tracking system. We will ingest live flight data from the public OpenSky Network API using a Python polling script, stream it through Microsoft Fabric Eventstream into an Eventhouse (KQL Database), transform the dense raw arrays using KQL update policies and visualize the results on a Real-Time Dashboard complete with maps, KPIs and analytical charts.

Prerequisites:

Valid Fabric Capacity / Trail License
Knowledge on Python
Knowledge on KQL

Step1: Setup Workspace & Eventhouse (KQL Database)

Created a workspace “FlightTracking-[WS]”

Created an eventhouse “FLightTracking-EH”

Create a raw ingestion table “RawFlightbatc” in KQL Databse

Step 2: Setup a Fabric Eventstream

Created a Eventstream “GlobalFlightStream” and select ‘Use custom endpoint’

Click ‘Add’

Click on ‘Publish’

Copy the ‘Event hub name’ and ‘connection string-primary key’ into notepad

Step 3: Notebook Creation and Setup Python script

Created a notebook. Make sure select Python

Install azure eventhub package

Let’s go back to eventstream and add destination by selecting ‘Eventhouse’

Configure all details and click on save

Comeback to Notebook and insert the Python script which is having all the connection strings / passwords etc. Run the notebook

Now notebook started running and sending the data to eventstream

Data is loaded into eventstream and Click on Publish

Now eventstream is ‘Live’

Data is loading into KQL Database

Step 4: Regularizing Data with KQL & Update Policies

Create a cleaned table “FlightStates”

Create the parsing function and update policy

Alter table with updated policy

Step 5: Building Real-Time Dashboard

Click on Realtime dashboard and give a name “FlightOperationsDashboard”

Now click on edit

Run the below code to get total active flights count

Change the chart to Stat and rename, click on Apply

KPI added and click on Add visual and take new Stat visual

Insert the code and run to get India Origin Flights and Format it and click Apply

In the same way, I built other KPIs

Select Map Chart

Run the below code and Fill all details and Click on Apply. Here we’re calculating Flights trend

We can see chart added to Dashboard

Select a Bar chart

Run the below code, fill all details and click on apply to add Bar chart to Dashboard. Here we’re getting the top 10 countries by aircrafts

Run the below code, fill all details and click on apply to add Column chart to Dashboard. Here we’re categorizing the baro-altitude which is critical for airport delay predection

Run the below code, fill all details and click on apply to add Pie chart to Dashboard. It splits the aircraft parked versus those actively flying

Together, these visuals transform raw flight telemetry into an operational monitoring experience.

Key takeaways:

Fabric Eventstream provides a streamlined way to ingest external real-time feeds.
Eventhouse/KQL Database provides a real-time analytical environment for flight telemetry.
KQL mv-expand simplifies the processing of nested flight-state arrays.
Update Policies automate transformation from raw streaming data into structured analytical data.
KQL geospatial functions enable location-based flight analysis.
Real-Time Dashboards transform streaming telemetry into actionable operational insights.

Conclusion:

This project demonstrates how Microsoft Fabric Real-Time Intelligence can be used to build an end-to-end real-time aircraft tracking solution.

we can transform continuously arriving aircraft telemetry into meaningful real-time insights.

Do you want to replicate? Get Code file from my GitHub link

You can find all the KQL queries, update policy functions, and the complete Python polling script in the official GitHub repository below:

[Download from here]

Acknowledgements

I would like to express my sincere gratitude to @SuryaTejaJosyul , @minniwalia and @rajendraongole1 for their continuous guidance and support throughout this Real-Time Intelligence (RTI) implementation. Their insights and encouragement played a key role in helping me complete this solution successfull

Happy learning!

— Inturi Suparna Babu

[LinkedIn]

Mouse over effects for buttons

ibarrau — Tue, 15 Sep 2026 18:34:29 GMT

Before we begin, I'd like to clarify a golden rule for creating a great button experience: users should always have a clear indication of which button is currently selected compared to the others. It may sound simple, and many will argue that the Navigator visual available today already solves this problem. However, when we want to go further with custom effects, we will need a bit of retro creativity with our old friends, bookmarks.

NOTE: If you are not familiar with how to easily highlight a selected button by changing its background color, you can review that article first.

Next, we will look at two effects separately, although they could easily be combined.

Underlining Instead of Background Highlighting

When creating buttons, it is natural to focus on their background, both for the selected state and the hover state. However, if we pay attention to the web, we can see that a much lighter visual effect is often achieved with underlined titles.

With a simple underline, I can quickly identify which button is currently selected. I can also use the same effect when the cursor hovers over the other measures.

To build this, we will need two buttons (the active and inactive versions, just as in the previous article) and a shared horizontal line. The inactive button, in its normal state, has a solid background (0% transparency) that exactly matches the page background color, along with gray text. When the mouse hovers over it, the button changes to white text and a 100% transparent background, making the line behind it visible.

When we click the active button, meaning the one that represents the currently displayed state, it remains hidden until the button is clicked. After the click, we will make it visible using bookmarks. This button is positioned exactly on top of the inactive one. While the active button is visible, we will hide the inactive button. The active button will have the same properties in its Default state as the On Hover state of the inactive button, making the horizontal line visible and displaying the text in white. Let's see how the complete setup looks:

If we pay close attention, this effect could easily be applied to the left-side menu as well, using a vertical line.

Motion Spacing

Although Power BI does not provide many visual elements that allow us to experiment with motion effects, in some cases we can simulate them. In this example, we will create the illusion of the text moving slightly to the right when the cursor is placed over the button. To achieve this, we will once again use three elements: two buttons and a vertical line. The difference this time is that instead of simply covering the line as we did before, we will hide and show it. Why make it more complicated this way? Simply because the background has a gradient. In those situations, we cannot have the button in its default state hide the line, because reproducing the exact background effect on the button would be very difficult. Therefore, we will keep the lines hidden until the button is pressed, at which point they will be displayed.

To create this effect, we will set up the inactive button with gray text and no background. The trick will be in its On Hover state. In that state, we will add invisible characters.

What is an invisible character? Invisible text, or invisible characters, refers to special characters that cannot be seen on the screen but are treated like normal letters by the system.

When the mouse hovers over the text, it will begin with invisible characters, creating the effect that the text shifts slightly to the right. Something like this:

Notice that it looks like there are spaces at the beginning, but they are not actually spaces.

Here are the characters if you'd like to copy them:‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎← after the arrow. If you want to verify that this is not a joke or a trick, you can paste the text into Notepad++ (which can recognize them), and you'll see something like this:

The movement effect is now in place. So, how do we continue enhancing the user experience? By following the golden rule. When the user clicks, we will hide the inactive button to reveal the vertical line and the active button, which in this case has its text colored the same as the line.

Let's see the final result:

That's all for this article. I hope it gives you some new ideas for creating user experiences that feel more modern, friendly, and similar to the web applications we interact with every day.

Remember that these two effects can be combined. For example, you could have a vertical navigation menu that not only displays the vertical indicator line for the selected option, but also applies the movement effect when users hover over the items.

Original Post in spanshi