Tag Archives: microsoft
Custom App requests authentication on Teams Mobile (iOS)
Hello everyone,
I have a legacy web app that is hosted locally and published via Entra ID App Proxy, ensuring it is secured by conditional access policies. I wanted to test its integration in Teams, and it works fine as a custom app. When I call the “Entra ID App Proxy” app within a custom Teams app, it functions seamlessly with SSO on the Teams app for Windows and in MS Edge.
However, I encounter an issue with SSO when I open the custom app in Microsoft Teams (version 6.18.2) on iOS (version 18.0.1). It always prompts for credentials (username, password, and MFA code), which is different from my experience on Windows and in the browser.
Has anyone else tried something similar to make a legacy app available within Microsoft Teams? Any insights or solutions would be greatly appreciated.
Thank you!
Hello everyone,I have a legacy web app that is hosted locally and published via Entra ID App Proxy, ensuring it is secured by conditional access policies. I wanted to test its integration in Teams, and it works fine as a custom app. When I call the “Entra ID App Proxy” app within a custom Teams app, it functions seamlessly with SSO on the Teams app for Windows and in MS Edge. However, I encounter an issue with SSO when I open the custom app in Microsoft Teams (version 6.18.2) on iOS (version 18.0.1). It always prompts for credentials (username, password, and MFA code), which is different from my experience on Windows and in the browser. Has anyone else tried something similar to make a legacy app available within Microsoft Teams? Any insights or solutions would be greatly appreciated. Thank you! Read More
Problem with a full day booking
Hello,
I have a problem with the full day booking. My outlook calendar range is “out of the office” or “busy” but MS Bookings still purpose the range. It’s like Full day option don’t work with Bookings.
If someone have a solution.
Hello,I have a problem with the full day booking. My outlook calendar range is “out of the office” or “busy” but MS Bookings still purpose the range. It’s like Full day option don’t work with Bookings.If someone have a solution. Read More
Automation from Project Center?
Hi Community.
By any chance: is there a way to trigger automations, custom workflows or any other kind of logic via / through the Project Center or the Project Details?
Background: MS Project tasks are managed by 3rd-party-App. States and efforts need to by synced to MS Project. So before a Project Manager opens (or checkouts) a project, we need to make sure all states and efforst are synchronized.
Is there a way to manually perform this syncing action via Project Center?
Thanks, a lot guys!
Hi Community. By any chance: is there a way to trigger automations, custom workflows or any other kind of logic via / through the Project Center or the Project Details? Background: MS Project tasks are managed by 3rd-party-App. States and efforts need to by synced to MS Project. So before a Project Manager opens (or checkouts) a project, we need to make sure all states and efforst are synchronized. Is there a way to manually perform this syncing action via Project Center? Thanks, a lot guys! Read More
EntraID account on Windows 11 being started under a TEMP user profile
I have a EntraID user on Windows 11 (Intune Managed). User is the “primary user”. The user started experiencing login issues where “user name or password not recognized”. Password was reset in EntraID. PC recognized the new password and allows the user to login BUT the account profile is mapped to C:UsersTEMP and not to their normal C:Users<UserName> profile. How do I reconnect the user with their profile?
I have a EntraID user on Windows 11 (Intune Managed). User is the “primary user”. The user started experiencing login issues where “user name or password not recognized”. Password was reset in EntraID. PC recognized the new password and allows the user to login BUT the account profile is mapped to C:UsersTEMP and not to their normal C:Users<UserName> profile. How do I reconnect the user with their profile? Read More
Join the Fabric Partner Community for this Week’s Fabric Engineering Connection!
Join us this Wednesday, October 30, from 8-9 AM PT for the weekly partner community call, Fabric Engineering Connection! This week’s call will feature presentations on Admin & Security from Varun Jain and Rick Xu, followed by Data Protection with Anton Fritz.
The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback.
To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form at https://aka.ms/JoinFabricPartnerCommunity.
Join us this Wednesday, October 30, from 8-9 AM PT for the weekly partner community call, Fabric Engineering Connection! This week’s call will feature presentations on Admin & Security from Varun Jain and Rick Xu, followed by Data Protection with Anton Fritz.
The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback.
To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form at https://aka.ms/JoinFabricPartnerCommunity. Read More
Autopilot Hybrid Environment
Hi All,
Does anyone know the a rough time scale from a Windows 11 laptop being built up to the login screen, for the SCCM apps/polices etc to be pushed to the laptop?
And is it best the leave the laptop at the login screen or login? user or admin?
Thanks
Hi All, Does anyone know the a rough time scale from a Windows 11 laptop being built up to the login screen, for the SCCM apps/polices etc to be pushed to the laptop? And is it best the leave the laptop at the login screen or login? user or admin? Thanks Read More
Duplicate alerts generated when unsanctioned app is accessed
We use defender for endpoint and also sanction/unsanction cloud applications in defender.
When unsanctioned application is blocked we get two alerts generated for it. One titled “Connection to a custom network indicator” and second “Unsanctioned cloud app access was blocked”
We expect and want only one of these alerts, but can’t seem to find correct area to edit policy for “Unsanctioned cloud app access was blocked” and editing “Connection to a custom network indicator” seems to require editing alert settings for each indicator. Maybe there is better way for latter one.
Connection to a custom network indicator
When application is unsanctioned, it creates a custom indicator which is further vieweable at Defender > System > Settings > Endpoints > Rules > Indicators URLs/Domains.
Application column is displaying cloud app which was sanctioned and alert with title “Unsanctioned cloud app access was blocked” for each indicator can be furter edited from this area. This would be one place we can turn off these alerts, but hoping there is bulk edit or a global setting to not create these alerts when cloud app is unsanctioned.
This is the alert policy/rule we would like to turn off and not have created automatically for each unsanctioned cloud app. Is there a setting to disable autoamtic creating of these alerts with each new unsanctioned cloud app?
Unsanctioned cloud app access was blocked
Only severity can be changed for these alerts as far as I can find under Settings > Cloud apps > Cloud Discovery > Microsoft Defender for Endpoint.
That is okay as this is the preffered alert that would like to retain
We use defender for endpoint and also sanction/unsanction cloud applications in defender.When unsanctioned application is blocked we get two alerts generated for it. One titled “Connection to a custom network indicator” and second “Unsanctioned cloud app access was blocked”We expect and want only one of these alerts, but can’t seem to find correct area to edit policy for “Unsanctioned cloud app access was blocked” and editing “Connection to a custom network indicator” seems to require editing alert settings for each indicator. Maybe there is better way for latter one. Connection to a custom network indicatorWhen application is unsanctioned, it creates a custom indicator which is further vieweable at Defender > System > Settings > Endpoints > Rules > Indicators URLs/Domains.Application column is displaying cloud app which was sanctioned and alert with title “Unsanctioned cloud app access was blocked” for each indicator can be furter edited from this area. This would be one place we can turn off these alerts, but hoping there is bulk edit or a global setting to not create these alerts when cloud app is unsanctioned.This is the alert policy/rule we would like to turn off and not have created automatically for each unsanctioned cloud app. Is there a setting to disable autoamtic creating of these alerts with each new unsanctioned cloud app? Unsanctioned cloud app access was blockedOnly severity can be changed for these alerts as far as I can find under Settings > Cloud apps > Cloud Discovery > Microsoft Defender for Endpoint.That is okay as this is the preffered alert that would like to retain Read More
Benchmarking 6th gen. Intel-based Dv6 (preview) VM SKUs for HPC Workloads in Financial Services
Introduction
In the fast-paced world of Financial Services, High-Performance Computing (HPC) systems in the cloud have become indispensable. From instrument pricing and risk evaluations to portfolio optimizations and regulatory workloads like CVA and FRTB, the flexibility and scalability of cloud deployments are transforming the industry. Unlike traditional HPC systems that require complex parallelization frameworks (e.g. depending on MPI and InfiniBand networking), many financial calculations can be efficiently executed on general-purpose SKUs in Azure.
Depending on the codes used to perform the calculations, many implementations leverage vendor-specific optimizations such as AVX-512 from Intel. With the recent announcement of the public preview of the 6th generation of Intel-based Dv6 VMs (see here), this article will explore the performance evolution across three generations of D32ds – from D32dsv4 to D32dsv6.
We will follow the testing methodology similar to the article from January 2023 – “Benchmarking on Azure HPC SKUs for Financial Services Workloads” (link here).
Overview of D-Series VM in focus:
In the official announcement it was mentioned, that the upcoming Dv6 series (currently in preview) offers significant improvements over the previous Dv5 generation. Key highlights include:
Up to 27% higher vCPU performance and a threefold increase in L3 cache compared to the previous generation Intel Dl/D/Ev5 VMs.
Support for up to 192 vCPUs and more than 18 GiB of memory.
Azure Boost, which provides:
Up to 400,000 IOPS and 12 GB/s remote storage throughput.
Up to 200 Gbps VM network bandwidth.
A 46% increase in local SSD capacity and more than three times the read IOPS.
NVMe interface for both local and remote disks.
Note: Enhanced security through Total Memory Encryption (TME) technology is not activated in the preview deployment and will be benchmarked once available.
Technical Specifications for 3 generations of D32ds SKUs
VM Name
D32ds_v4
D32ds_v5
D32ds_v6
Number of vCPUs
32
32
32
InfiniBand
N/A
N/A
N/A
Processor
Intel® Xeon® Platinum 8370C (Ice Lake) or Intel® Xeon® Platinum 8272CL (Cascade Lake)
Intel® Xeon® Platinum 8370C (Ice Lake)
Intel® Xeon® Platinum 8573C (Emerald Rapids) processor
Peak CPU Frequency
3.4 GHz
3.5 GHz
3.0 GHz
RAM per VM
128 GB
128 GB
128 GB
RAM per core
4 GB
4 GB
4 GB
Attached Disk
1200 SSD
1200 SSD
440 SSD
Benchmarking Setup
For our benchmarking setup, we utilised the user-friendly, open-source test suite from Phoronix (link) to run 2 tests from OpenBenchmarking.org test suite, specifically targeting quantitative finance workloads.
The tests in the “finance suite” are divided into two groups, each running independent benchmarks. In addition to the finance test suite, we also ran the AI-Benchmark to evaluate the evolution of AI inferencing capabilities across three VM generations.
Finance Bench
QuantLib
AI Benchmark
Bonds OpenMP
Size XXS
Device Inference Score
Repo OpenMP
Size X
Device AI Score
Monte-Carlo OpenMP
Device Training Score
Software dependencies
Component
Version
OS Image
Ubuntu marketplace image: 24_04-lts
Phoronix Test Suite
10.8.5
Quantlib Benchmark
1.35-dev
Finance Bench Benchmark
2016-07-25
AI Benchmark Alpha
0.1.2
Python
3.12.3
To run the benchmark on a freshly created D-Series VM, execute the following commands (after updating the installed packages to the latest version):
git clone https://github.com/phoronix-test-suite/phoronix-test-suite.git
sudo apt-get install php-cli php-xml cmake
sudo ./install-sh
phoronix-test-suite benchmark finance
For the AI Benchmark tests, a few additional steps are required. For example, creating a virtual environment for additional python packages and the installation of the tensorflow and ai-benchmark packages are required:
sudo apt install python3 python3-pip python3-virtualenv
mkdir ai-benchmark && cd ai-benchmark
virtualenv virtualenv
source virtualenv/bin/activate
pip install tensorflow
pip install ai-benchmark
phoronix-test-suite benchmark ai-benchmark
Benchmarking Runtimes and Results
The purpose of this article is to share the results of a set of benchmarks that closely align with the use cases mentioned in the introduction. Most of these use cases are predominantly CPU-bound, which is why we have limited the benchmark to D-Series VMs. For memory-bound codes that would benefit from a higher memory-to-core ratio, the new Ev6 SKU could be a suitable option.
In the picture below, you can see a representative benchmarking run on a Dv6 VM, where nearly 100% of the CPUs were utilised during execution. The individual runs of the Phoronix test suite, starting with Finance Bench and followed by QuantLib, are clearly visible.
Runtimes
Figure 1: CPU Utilization for a full Finance Benchmark Run
Benchmark
VM Size
Start Time
End Time
Duration
Minutes
Finance Benchmark
Standard D32ds v4
12:08
15:29
03:21
201.00
Finance Benchmark
Standard D32ds v5
11:38
14:12
02:34
154.00
Finance Benchmark
Standard D32ds v6
11:39
13:27
01:48
108.00
Finance Bench Results
QuantLib Results
AI Benchmark Alpha Results
Discussion of the results
The results show significant performance improvements in QuantLib across the D32v4, D32v5, and D32v6 versions. Specifically, the tasks per second for Size S increased by 47.18% from D32v5 to D32v6, while Size XXS saw an increase of 45.55%.
Benchmark times for ‘Repo OpenMP’ and ‘Bonds OpenMP’ also decreased, indicating better performance. ‘Repo OpenMP’ times were reduced by 18.72% from D32v4 to D32v5 and by 20.46% from D32v5 to D32v6. Similarly, ‘Bonds OpenMP’ times decreased by 11.98% from D32v4 to D32v5 and by 18.61% from D32v5 to D32v6.
In terms of Monte-Carlo OpenMP performance, the D32v6 showed the best results with a time of 51,927.04 ms, followed by the D32v5 at 56,443.91 ms, and the D32v4 at 57,093.94 ms. The improvements were -1.14% from D32v4 to D32v5 and -8.00% from D32v5 to D32v6.
AI Benchmark Alpha scores for device inference and training also improved significantly. Inference scores increased by 15.22% from D32v4 to D32v5 and by 42.41% from D32v5 to D32v6. Training scores saw an increase of 21.82% from D32v4 to D32v5 and 43.49% from D32v5 to D32v6.
Finally, Device AI scores improved across the versions, with D32v4 scoring 6726, D32v5 scoring 7996, and D32v6 scoring 11436. The percentage increases were 18.88% from D32v4 to D32v5 and 43.02% from D32v5 to D32v6.
Next Steps & Final Comments
The public preview of the new Intel SKUs have already shown very promising benchmarking results, indicating a significant performance improvement compared to the previous D-series generations, which are still widely used in FSI scenarios.
It’s important to note that your custom code or purchased libraries might exhibit different characteristics than the benchmarks selected. Therefore, we recommend validating the performance indicators with your own setup.
In this benchmarking setup, we have not disabled Hyper-Threading on the CPUs, so the available cores are exposed as virtual cores. If this scenario is of interest to you, please reach out to the authors for more information.
Additionally, Azure offers a wide range of VM families to suit various needs, including F, FX, Fa, D, Da, E, Ea, and specialized HPC SKUs like HC and HB VMs.
A dedicated validation, based on your individual code / workload, is recommended here as well, to ensure the best suited SKU is selected for the task at hand.
Microsoft Tech Community – Latest Blogs –Read More
Introducing the new Microsoft Teams chat and channels experience
Today we announced a new chat and channels experience that will roll out to public preview in November.
Our customers are our greatest source of inspiration, and over the years we have evolved Teams with the goal of helping them achieve more. Today we are taking the next big step in our journey with a new chat and channels experience designed to help you collaborate more efficiently and effectively in the hybrid AI-infused workplace. It is simple by default, enabling everyone to stay on top of what matters, and powerful on-demand, allowing you to organize information and communicate your way. Let’s take a look:
Stay on top of your chats and channels, all in one place
The pace of work has increased exponentially, making it more challenging to keep up with the high volume of conversations, manage messages scattered across different locations, and find information. We’ve redesigned the chat and channels experience to simplify your digital workspace by bringing chats, teams, and channels into one place under Chat. Now, you can easily navigate and prioritize all your conversations without the hassle of switching contexts.
At launch, a self-service, guided onboarding flow within the product will help users discover the new experience and configure it to their preferences. Users who prefer to keep chat and channels separate can easily do so during the onboarding process or at any time later, without needing IT assistance.
Efficiently triage your messages
One of the biggest challenges in managing a high volume of conversations is focusing on the information that matters most to you now. To help you effectively triage your messages, we’ve introduced new filters such as “Unread,” “Chat,” “Channels,” “Meetings,” and “Muted”. For example, with a single click on the “Unread” filter, you can now catch up in one convenient place on all your unread conversations across chats, channels and meetings. If you are looking for a specific type of conversation, like channels, select the relevant filter to further narrow your search and quickly locate the most relevant results.
@Mentions are used to call your attention to essential messages and ensure that these messages don’t slip through the cracks. The new @mention view gathers all messages directed at you into a single interactive list. Now, you can quicky access all conversations that include @mentions without having to search through multiple conversations. With this view, you can quickly identify where your attention is most needed, select a message, and respond directly from your flow of work.
Organize conversations your way
The new chat and channels experience in Teams empowers you to personalize your work environment to fit your needs and organize your conversations the way you prefer to work. The new favorites section is available for everyone by default, bringing together all your pinned chats and channels from the previous experience, so you have one easy-to-access place of your top priority conversations. With custom sections, you can bring all relevant conversations on a project or topic together into one place, be it in chats, channels, meetings, Teams bots or AI agents. With up to 50 sections and 50 items per section, you can efficiently manage even the most complex projects.
Stay on top of new messages and prioritize essential information by organizing your sections. Rearrange your conversation list to keep key discussions at the forefront using drag and drop. Alternatively, sort your conversation list by most recent message or choose to show unread messages only. This will help you address new communications promptly.
Save time when communicating
We are making it easier to send a new message in channels and promoting the use of existing channels. This integrates both chat and channels into your critical workflows, so you can Initiate a chat or channel post from the same place – eliminating the need to navigate to the specific channel first—with a streamlined new message feature. This update is also reflected in the keyboard shortcut for creating a new message, Ctrl+N (Cmd+N on Mac), for faster communication.
Go to helps you navigate Teams effectively without context switching. Quickly navigate to your frequently used conversation across your chat and channels with a new keyboard shortcut Ctrl+G (Cmd+G on Mac).
Customize the experience to your preferences
Every user has a unique way of working. Now, you can customize Teams chat and channels to align with your personal workflow and preferred information consumption style. With new controls, you can choose to view chat and channels separately, see message previews, or display all channels in a single list. This way, you create a digital workspace that truly helps you soar.
And if you want to stay on top of the most recent channel messages quickly, switch your teams and channels section to display all your channels in a single list, eliminating the need to expand and collapse team sections.
If you are on the go, customize your experience with mobile-specific settings, such as choosing between viewing messages organized by sections or by most recent. The new experience is optimized for different screen sizes, helping you read and respond to messages efficiently no matter where you are.
Availability
Your work isn’t limited to just a desktop, so we’re excited to bring the new chat and channels experience to all devices for seamless productivity. This is coming to public preview in November to desktop, mobile, iOS, and Android, ensuring you can stay connected and efficient wherever you are.
The new chat and channels experience on mobile, for seamless productivity on every device
What’s next
We are just getting started, and we are committed to making Teams more streamlined and simpler with enhancements like threaded conversations. We are beginning to test threaded conversations with customers this quarter and will expand testing in early 2025, with broad availability expected in mid-2025.
Embark on your journey with the new chat and channels experience today and transform the way you connect, focus, and collaborate. Customers with access to Microsoft public preview will be able to try out the new interface starting in November. To activate, choose “Get started” when you see the welcome screen for the new chat and channels experience.
Welcome screen to the new chat and channels experience
Streamline your users onboarding experience and learn more via our hub adoption.microsoft.com. Learn more from Teams product leaders on the vision for the new chat and channel experience on our Meet the Makers episode and get started today:
Microsoft Tech Community – Latest Blogs –Read More
Item creator name not being reflected in SharePoint form
I am trying to create a custom form and need to a field which displays the name of the user who has created an entry in the list.
I have tried multiple things however unable to reach to the desired outcome, can you please suggest what I might be not doing right.
TIA
I am trying to create a custom form and need to a field which displays the name of the user who has created an entry in the list.I have tried multiple things however unable to reach to the desired outcome, can you please suggest what I might be not doing right.TIA Read More
Trashcan to Archive
In my industry, I should never delete emails, only archive. I would like to change the trashcan icon to the archive icon in my inbox. When I hover over a message, my options are FLAG or DELETE. How can I make this FLAG or ARCHIVE? I would also like to add the archive option to the reading pane. I currently have EMOJI, REPLY, REPLY ALL, FORWARD, TEAMS and …
In my industry, I should never delete emails, only archive. I would like to change the trashcan icon to the archive icon in my inbox. When I hover over a message, my options are FLAG or DELETE. How can I make this FLAG or ARCHIVE? I would also like to add the archive option to the reading pane. I currently have EMOJI, REPLY, REPLY ALL, FORWARD, TEAMS and … Read More
Enhance Azure Maps with Overture Maps Data using PMTiles!
Supercharge Azure Maps with Overture Maps Data using PMTiles
We’ve got some exciting news. Azure Maps now supports PMTiles! This means you can overlay massive geospatial datasets on Azure Maps with incredible efficiency and ease. PMTiles lets your data-intensive mapping applications access large datasets seamlessly, without the need to load the entire dataset on the client side. The result? Faster performance and more powerful, responsive mapping applications on Azure Maps.
What exactly are PMTiles?
Think of PMTiles as a supercharged ZIP file for tiled data. It’s a single-file archive format that consolidates numerous individual tiles into one neat package. This makes storage a breeze and managing your data way simpler compared to juggling thousands of small files.
PMTiles are perfect for cloud-native deployments and can be hosted on Azure Blob Storage. This means you can build low-cost, serverless map applications without needing a custom backend or third-party tile provider. With PMTiles, you can directly request data from the file over HTTP, accessing specific map tiles without any intermediaries. Whether you’re dealing with vector data, raster data, or terrain mesh data, PMTiles has got you covered.
How to create PMTiles
If you’re looking to create PMTiles for vector data, Tippecanoe is your go-to tool. It produces optimized vector tiles for visualization, simplifying or removing small features at low zoom levels to keep the tiles compact and manageable. This ensures a smooth user experience on the client side.
Displaying and Using PMTiles on Azure Maps
Azure Maps now supports custom protocols like pmtiles:// for referencing PMTiles archives. By using this custom protocol, Azure Maps can access tiles within a PMTiles archive using HTTP range requests, fetching only the data you need when you need it. To get started with PMTiles, the Azure Maps Web SDK offers the addProtocol function. This registers a callback that intercepts and modifies requests, allowing PMTiles data to be processed dynamically for rendering on the map.
Here’s a quick guide to setting up PMTiles support:
Reference the PMTiles Library:
<script src=“https://unpkg.com/pmtiles@3.0.5/dist/pmtiles.js”></script>
Initialize the PMTiles Protocol:
const protocol = new pmtiles.Protocol();
atlas.addProtocol(“pmtiles”, (request) => {
return new Promise((resolve, reject) => {
protocol.tile(request, (err, data) => {
if (err) reject(err);
else resolve({ data });
});
});
});
This setup registers the pmtiles:// schema, enabling Azure Maps to process requests specifically for PMTiles sources.
Add and Configure PMTiles Data Source: Use the following example to overlay Overture Maps’ building data on top of the Azure Maps basemap:
const PMTILES_URL = “https://overturemaps-tiles-us-west-2-beta.s3.amazonaws.com/2024-07-22/buildings.pmtiles”;
protocol.add(new pmtiles.PMTiles(PMTILES_URL));
map.sources.add(new atlas.source.VectorTileSource(“pmtiles”, {
type: “vector”,
url: `pmtiles://${PMTILES_URL}`,
}));
This code defines a vector tile source that uses the PMTiles URL. The map then dynamically fetches only the tiles that the user’s view requires, improving both performance and data usage.
What is Overture Maps?
Overture Maps is an open data project launched in 2022 by a coalition led by the Linux Foundation. Supported by Meta, Microsoft, AWS, and TomTom, this initiative aims to provide reliable, interoperable geospatial data for the public. The Overture Maps Foundation aggregates open and commercial datasets, offering a unified schema that makes it easier to work with geospatial data across different platforms and applications.
Each dataset in Overture Maps is organized by themes that classify different types of geospatial information, like building footprints, roads, water bodies, and points of interest. This thematic organization ensures a structured approach to incorporating diverse types of location data, making it accessible for developers across various projects.
With PMTiles support in Azure Maps, we can’t wait to see how you’ll use this capability to power dynamic and data-rich applications. Stay tuned for more updates, and start integrating PMTiles into your Azure Maps applications to unlock new potential with Overture Maps data today!
Microsoft Tech Community – Latest Blogs –Read More
Summarise matrix diagonally
Hi All,
Consider a scenario where a group of people take a holiday, over the course of which, they each spend money on behalf of the group. When they get home, they need to repay others.
We end up with a (simplified) matrix like the one below.
Example – Person A owes Person B $85, Person B doesn’t owe Person A any money.
Problem:
Person B and C owe each other money, and Person A and C owe each other money. How would I consolidate the amounts such that only one person from each pair transfers money to balance the bills?
I took the approach of multiplying all values below the diagonal line (where person A owes person A) by -1, then attempting to rotate the top diagonal half by 180deg (double transpose) to add the negative values to the bottom diagonal half.
But… this doesn’t work – and if it did, it’s clunky…
Any suggestions?
Hi All,Consider a scenario where a group of people take a holiday, over the course of which, they each spend money on behalf of the group. When they get home, they need to repay others. We end up with a (simplified) matrix like the one below. Example – Person A owes Person B $85, Person B doesn’t owe Person A any money. Problem:Person B and C owe each other money, and Person A and C owe each other money. How would I consolidate the amounts such that only one person from each pair transfers money to balance the bills? I took the approach of multiplying all values below the diagonal line (where person A owes person A) by -1, then attempting to rotate the top diagonal half by 180deg (double transpose) to add the negative values to the bottom diagonal half.But… this doesn’t work – and if it did, it’s clunky… Any suggestions? Read More
D365 Customer Serivce Per device and Add-on
Hello
Can we add the add-on Dynamics 365 Contact Center Digital or Dynamics 365 Contact Center Voice to a D365 Customer Service Per device?
Thank you
Pierre-Olivier
Hello Can we add the add-on Dynamics 365 Contact Center Digital or Dynamics 365 Contact Center Voice to a D365 Customer Service Per device?Thank you Pierre-Olivier Read More
Problem with Microphone after Mac Update to 15.0.1
Hello,
I am using the following:
– M1 Mac Book Pro
– MacOS 15.0.1
– Speaker device: FiiO K5 Pro
– Microphone: Shure SM7B / Focusrite 2i2
Since updating the MacOS version I have a very strange effect:
– Shortly after joining a call everything works fine, after some seconds my Microphone stops working / peers do not hear me anymore
– I can resolve this by opening the microphone settings tab. It has to stay open during the whole call.
– The test call always works fine, I can hear the robot and my recording. I guess because the call is too short for the problem to appear.
What I tried:
– Unsetting/resetting the “microphone” permission in MacOS
– Reinstalling teams multiple times
– Updated the Focusrite Drivers
Do you have any ideas how to fix the issue?
Hello, I am using the following:- M1 Mac Book Pro- MacOS 15.0.1- Speaker device: FiiO K5 Pro- Microphone: Shure SM7B / Focusrite 2i2 Since updating the MacOS version I have a very strange effect:- Shortly after joining a call everything works fine, after some seconds my Microphone stops working / peers do not hear me anymore- I can resolve this by opening the microphone settings tab. It has to stay open during the whole call.- The test call always works fine, I can hear the robot and my recording. I guess because the call is too short for the problem to appear. What I tried:- Unsetting/resetting the “microphone” permission in MacOS- Reinstalling teams multiple times- Updated the Focusrite Drivers Do you have any ideas how to fix the issue? Read More
Announcing Clean Data with Copilot in Excel
Hi everyone, this is part 10 in a series of posts to show you some of the things that are possible to do with Copilot in Excel.
We’re thrilled to introduce a new AI-powered feature in Excel – Clean Data. With Copilot in Excel, you can clean data with just one click. Clean Data detects and offers solutions for text inconsistencies, number format issues, and extra spaces. This feature is now available to Excel for the web users and will be rolling out to Windows desktop users in the coming months.
Simply select the Clean Data option in the Data tab of the ribbon or interact with the pop-up banner to get started.
Excel window showing business bar with the text: “Copilot detected 4 data inconsistencies and formatting issues. Fix them to avoid wrong calculations and messy workbook”
Text inconsistencies in cells of the same value
This feature seeks to identify unnoticed variations across similar values that could cause subsequent problems. For example, a column with a mix of uppercase and lowercase text in the cells; or cells in a column containing differences in punctuation or diacritics.
Clean Data will locate these inconsistencies and will help you to easily correct them.
Inconsistent text suggestion card showing an example of mixed cases to the word “Excel”, including “Excel”, “EXCEL”, and “Excel.”
Number format inconsistency in a column
This feature seeks to identify columns with a mix of both Text and Number formatted cells that could result in incorrect calculations. Clean Data will locate these inconsistencies and will help you convert the ‘Text’ formatted cells to a number format.
Inconsistent number format suggestion card showing an example of mixed Number and Text cells
Extra space removal suggestions
Clean Data will also detect and suggest the removal of unnecessary spaces in the highlighted table – such as extra leading spaces, trailing spaces, and between-value spaces.
Extra spaces suggestion card suggesting removing the extra spaces in the Table
Example of between-values extra spaces between the word “Microsoft” and “Excel”.
Practical tips
Here are some helpful pointers for getting the most out of Clean Data:
Clean Data works best with tabular data of up to 100 columns and 50,000 rows.
Clean Data works best with data that is formatted as an Excel table. To create an Excel table, click anywhere in your data and then select Home > Tables > Format as Table.
While not limited to English, Clean Data is initially going to perform best in English.
Functionality and Feedback
This is just the initial release; we’re always improving Clean Data. It may or may not behave as you anticipate. If you don’t get any expected Clean Data suggestions, get non-accurate suggestions or have any sort of feedback, please contact us via File > Feedback or by clicking the dedicated button at the bottom of the side-pane: Tell us what you think about Clean Data.
Stay tuned,
Microsoft Excel Team
Microsoft Tech Community – Latest Blogs –Read More
Learn about StealthMail’s Microsoft 365 partner solution in Microsoft AppSource
Microsoft 365 lets you create, share, and collaborate all in one place with your favorite apps. Learn about this offer from high-performing Microsoft 365 partner StealthMail on Microsoft AppSource:
R2 Copilot: Private ChatGPT for Outlook: Make quick, well-informed decisions and automate tasks to simplify routine workflows with the R2 Copilot add-in for Microsoft Outlook. R2 Copilot never exposes the contents of your communications to the public internet, using data encryption to comply with a range of privacy regulations, including GDPR, HIPAA, and CCPA.
Microsoft Tech Community – Latest Blogs –Read More
Migrating Test Artifacts from IBM Rational Quality Manager to Azure DevOps
Good Day,
I would like to find out if there is a way or tools in place that can be used to migrate test artifacts (Test Cases, Test Scripts, etc.) from IBM Rational Quality Management to Azure DevOps.
Thank you.
Good Day, I would like to find out if there is a way or tools in place that can be used to migrate test artifacts (Test Cases, Test Scripts, etc.) from IBM Rational Quality Management to Azure DevOps. Thank you. Read More
Issue with storage
Hallo
Ik heb een probleem waarbij mijn opslagruimte op de Windows Onedrive app 0GB is. Op de webapp staat dat ik 10.5GB heb (5GB gratis en 5.5GB verwijzingsbonus). Wanneer ik een nieuw bestand probeer te uploaden naar OneDrive krijg ik de melding dat mijn OneDrive opslagruimte vol is, terwijl ik slechts 29% ervan gebruik oftewel 3,1GB / 10,5GB.
Ik heb onlangs (vorige week) mijn betaalde abonnement op OneDrive opgezegd, dus ik val terug op de gratis 10.5GB (wat genoeg is). Ook de verwijzingsbonus verschijnt niet van tijd tot tijd. Mijn totale opslag blijft 10.5GB, maar soms staat er dat mijn doorverwijsbonus 0GB is en soms staat er de juiste 5.5GB.
Ik neem aan dat dit wordt veroorzaakt door een bug? Weet iemand wat ik kan doen?
HalloIk heb een probleem waarbij mijn opslagruimte op de Windows Onedrive app 0GB is. Op de webapp staat dat ik 10.5GB heb (5GB gratis en 5.5GB verwijzingsbonus). Wanneer ik een nieuw bestand probeer te uploaden naar OneDrive krijg ik de melding dat mijn OneDrive opslagruimte vol is, terwijl ik slechts 29% ervan gebruik oftewel 3,1GB / 10,5GB.Ik heb onlangs (vorige week) mijn betaalde abonnement op OneDrive opgezegd, dus ik val terug op de gratis 10.5GB (wat genoeg is). Ook de verwijzingsbonus verschijnt niet van tijd tot tijd. Mijn totale opslag blijft 10.5GB, maar soms staat er dat mijn doorverwijsbonus 0GB is en soms staat er de juiste 5.5GB.Ik neem aan dat dit wordt veroorzaakt door een bug? Weet iemand wat ik kan doen? Read More
