Category: Microsoft
Category Archives: Microsoft
Enable Office Diagnostic Data to unlock the power of Microsoft 365 Apps health.
In the Microsoft 365 Apps admin center you can monitor your Microsoft 365 Apps health as well as leverage update validation during your monthly patching rollout. Both of these powerful tools are available in the Apps Admin Center. The prerequisite for seeing this data is enabling Office Diagnostic Data (ODD) to allow us to collect your usage and patching signals and then return them to you in a way that allows you to really see what is happening in your environment from an Apps health perspective. Additionally, sending diagnostic data to Microsoft allows us to better track the quality of the builds we release, identify potential issues faster and deliver a better product to you.
What is Office Diagnostic Data?
Office Diagnostic Data (ODD) is a set of diagnostic signals that are collected by the Microsoft 365 Apps on your device and include details of how the M365 Apps are functioning, including signals related to App reliability, App performance, and versioning information, among other things. Microsoft can use this data to keep our applications updated, safe, and working well. Microsoft gives customers control over what type of ODD is sent to Microsoft, including the ability to turn it off almost completely.
How can I tell if I am sending Office Diagnostics Data to Microsoft
To ensure your devices in your tenant are sending diagnostic data you can check the tracker in the Apps Health section of the Apps admin center. Under the Overview page, in the Insights section, click on “See details” to show the flyout of how many devices are sending data. If you are not seeing the number of devices sending data you think you should, check to make sure you are configured to send data, your network is not blocking the traffic and that your devices are in support.
Why: Value of enabling ODD
We encourage customers to enable Office Diagnostic Data (ODD) to provide visibility into the health of their M365 Apps. With ODD enabled, both Microsoft and the customer’s tenant admins can proactively address issues that may impact the user experience. When Microsoft engineering receives detailed diagnostic signals from your devices, we are able to monitor for major issues and can take steps to mitigate reliability and performance problems—and even alert you to actions that you may need to take to resolve issues.
If ODD is disabled (set to the lowest level of “Neither”), Microsoft engineering has no visibility into your user’s experiences, and your tenant’s issues will not be considered when prioritizing bug fixes.
For customers, Microsoft has created a separate admin portal called the Apps Admin Center (config.office.com). If a tenant has ODD enabled, the admin can access M365 App health data and act on recommendations from Microsoft (through Config.office.com). Additionally, if Microsoft identifies an issue that is not within our control to resolve, we will often reach out to advise the customer on how to fix the problem.
To summarize, by sending ODD to Microsoft, you can benefit from the following:
Access health dashboards in the Microsoft 365 Apps admin center that show you the relevant app health data.
Influence the development and prioritization of new features and bug fixes.
Benefit from the latest security updates and patches that are intended to improve your user experience.
When relevant, receive proactive guidance and recommendations from Microsoft on how to improve the performance and reliability of your Microsoft 365 Apps.
Experience proactive resolution of issues and bugs.
We have customers from all over the world and from various industries, including government and security, who have enabled ODD (Office Diagnostics Data). This allows us to collaborate more effectively and keep a proactive eye on their health and experience. Enabling ODD can help us partner better and improve our customers’ experiences.
What is collected?
The level of diagnostics data you choose determines what type of data is collected by ODD. To enable us to process your app health trends and provide proactive support, we recommend that you set ODD to at least the Required level. This level collects the minimum amount of data needed to identify and fix issues. If you set ODD to Neither, you are essentially disabling it and preventing Microsoft from proactively improving your user experience. This means that you will be left alone in dealing with your tenant issues and user escalations reactively, without any proactive help from Microsoft engineering . Please refer to the following table for more information on the different levels of ODD.
Level
Description
Required
The minimum data necessary to help keep Office secure, up-to-date, and performing as expected on the device it’s installed on. Includes version of Office and information about crashes.
Optional
Required + Additional data that helps us make product improvements and provides enhanced information to help us detect, diagnose, and remediate issues. Includes performance info such as how long it takes to save a document.
Neither
No diagnostic data about Office client software running on the user’s device is collected and sent to us. This option, however, significantly limits our ability to detect, diagnose, and remediate problems your users may encounter using Office.
How to enable ODD?
There are a number of ways to configure Office Diagnostic Data on your devices, the method you use will depend on how you manage your devices. The following are the primary methods used by most customers.
Cloud Policy:
Use the “configure the level of client software diagnostics data sent by office to Microsoft” in the apps admin center(config.office.com)
Levels:
Optional
Required*
Neither
If policy is not configured, optional diagnostic data is sent to Microsoft.
*Minimum recommended
Control Setting via GPO (for Windows)
Configure the level of client software diagnostic data sent by Office to Microsoft (admx.help)
Control privacy settings by editing the registry.
Use the following information to configure privacy settings directly in the registry
[HKEY_CURRENT_USERSoftwarePoliciesMicrosoftofficecommonclienttelemetry] “sendtelemetry”=dword:00000002
How to view the Data sent to Microsoft
Use Diagnostic Data Viewer
Go to Start, select Settings>Office data settings
Enable toggle for Office diagnostic data viewing on
Diagnostic Data Viewer Overview (Windows 10 and Windows 11) – Windows Privacy | Microsoft Learn
How can an admin monitor M365 Apps health?
Microsoft 365 Apps health takes the diagnostic data you send to Microsoft and gives it right back to you in an easy to read and understand section within the M365 Apps admin center. Apps health tracks things like load time, crash rates and file open time to give you a holistic view of the health of the devices in your organization.
You can drill into each individual application, focus on a specific servicing channel or monitor the health of your add-ins all from Apps health inside the Apps admin center.
Privacy:
What is included in Office Diagnostic Data?
Depending on the level of control you have set up, the information that will be sent to Microsoft will be different. For Microsoft to help you keeping your tenant healthy proactively, we it is sufficient enabling ODD at the “Required” level. For a full list of Office Diagnostic data sent to Microsoft when “Required” level is set up, please refer to: Required diagnostic data for Office – Deploy Office | Microsoft Learn
How does Microsoft keep our data private?
Microsoft is the industry leader in protecting customer data and will only use your data to provide the services that you have purchased from Microsoft. Read more about how we protect & manage your data here.
How long diagnostic data stored?
For commercial customers, our typical engineering practice is to retain diagnostic data from Microsoft 365 Apps for up to 18 months. If an enterprise subscription expires or is terminated, Microsoft holds for 90 days and then deletes data within the next 90 days, as outlined in the DPA.
Is user data collected?
With Office Diagnostic data no user content or personal information (such as usernames or email addresses) is collected. Data that we received is pseudonymized. Diagnostic data also does not include any file content or information about apps unrelated to Office.
Where is data stored?
Office Diagnostics Data for EU customers is now stored within the EU, aligning with our commitment to regional data residency. The rest of the data continues to be securely stored in the United States, ensuring comprehensive data management and privacy.
Network
Office Diagnostics Data is transmitted to Microsoft through Office 365 endpoints, utilizing the devices’ network. This process typically involves a low volume of data, which is unlikely to impact network performance. Additionally, the data is secured both during transit and while stored, ensuring its confidentiality and integrity.
What is the impact in my Network?
The bandwidth consumed by Office Diagnostic Data varies as it depends on user interaction with Office Apps. While “Required” events typically upload once per session, user-driven events differ. To estimate data upload, enable diagnostics on a few devices and monitor connections to diagnostic endpoints via your firewall. For individual device data, use the Diagnostic Data Viewer on a ‘typical’ user’s device.
Microsoft Tech Community – Latest Blogs –Read More
“New Teams” in Windows 2019 RDSH environment with FSLogix profiles
Recently Microsoft released FSLogix hotfix 4 to address critical issues with “New Teams” in RDSH environments. This was super important to those of us that are affected by the upcoming June 30th deadline to implement “New Teams”.
I’ve noted some real issues that have yet to be resolved, and I have an open support case where I have clearly documented the issues we are facing. However, the support folks at LTIMindtree have for the past 6 weeks been ‘escalating’ the issue and ‘waiting for a resource to be assigned’ to the ticket. I keep telling them that we have a June 30th deadline, but they don’t seem able to help despite the looming deadline.
I’m curious as to whether or not Microsoft has been made aware of the ongoing issues with deploying “New Teams” on Windows 2019 using FSLogix profiles?
Noting that we are battling:
Teams occasionally does not start automatically, and in that circumstance Teams can’t be started by the user. The only resolution is to sign out, then sign in. This has become noticeably better with FSLogix hotfix 4, but it is not 100% yet. We are still affected by this although much less frequently than before hotfix 4 was released.Some user preferences are not captured and stored in the user’s FSLogix profile container. One specific example is the “Links open preference”. If a user selects a specific browser, that setting is not captured and stored in the profile. It is therefore reverted to default during the next session login. This is just a single example to demonstrate the issue, not a complete list.
I’m wondering whether or not anyone in the Microsoft Teams group is aware of the fact that there are MSP’s out there that have real, legit technical issues and are facing a Microsoft imposed deadline without any real ‘fixes’ or solutions.
At this point, we’ve been forced to communicate to our customers basically saying “Sorry, but Microsoft is forcing this upgrade and hasn’t yet addressed these issues that we are aware of”.
Is there anyone else in the same boat?
Recently Microsoft released FSLogix hotfix 4 to address critical issues with “New Teams” in RDSH environments. This was super important to those of us that are affected by the upcoming June 30th deadline to implement “New Teams”. I’ve noted some real issues that have yet to be resolved, and I have an open support case where I have clearly documented the issues we are facing. However, the support folks at LTIMindtree have for the past 6 weeks been ‘escalating’ the issue and ‘waiting for a resource to be assigned’ to the ticket. I keep telling them that we have a June 30th deadline, but they don’t seem able to help despite the looming deadline. I’m curious as to whether or not Microsoft has been made aware of the ongoing issues with deploying “New Teams” on Windows 2019 using FSLogix profiles? Noting that we are battling:Teams occasionally does not start automatically, and in that circumstance Teams can’t be started by the user. The only resolution is to sign out, then sign in. This has become noticeably better with FSLogix hotfix 4, but it is not 100% yet. We are still affected by this although much less frequently than before hotfix 4 was released.Some user preferences are not captured and stored in the user’s FSLogix profile container. One specific example is the “Links open preference”. If a user selects a specific browser, that setting is not captured and stored in the profile. It is therefore reverted to default during the next session login. This is just a single example to demonstrate the issue, not a complete list. I’m wondering whether or not anyone in the Microsoft Teams group is aware of the fact that there are MSP’s out there that have real, legit technical issues and are facing a Microsoft imposed deadline without any real ‘fixes’ or solutions. At this point, we’ve been forced to communicate to our customers basically saying “Sorry, but Microsoft is forcing this upgrade and hasn’t yet addressed these issues that we are aware of”. Is there anyone else in the same boat? Read More
HTTP 404 errors when accessing Purview portal (new and old)
Hi all,
I have the “contributor” role in a subscription, and I created a new purview account.
However, when I try accessing the Purview portal (both new and old) there are many missing buttons/functionality. I see there are several errors like the following one:
{
“error”: {
“code”: “ResourceNotFound”,
“message”: “Authorization error:[ResourceNotFound:Response content: {“Message”:”The Gls FFO Tenant Region was not found for the given tenant: ………….”}, full response: StatusCode: 404, ReasonPhrase: Not Found, Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:n{n Cache-Control: no-cachen Pragma: no-cachen Server: Microsoft-HTTPAPI/2.0n X-BEServer: ……n X-NanoProxy: 1n X-AspNet-Version: 4.0.30319n Request-Id: ……n Restrict-Access-Confirm: 1n X-BEPartition: …..n X-CalculatedBETarget: ……….OUTLOOK.COMn X-BackEndHttpStatus: 404n X-BeSku: WCS7n X-End2EndLatencyMs: 76n x-ms-appId: …..n X-Proxy-BackendServerStatus: 404n X-Proxy-RoutingCorrectness: 1n X-FEServer: …..n X-FirstHopCafeEFZ: PHXn Alt-Svc: h3=”:443″; ma=2592000n Alt-Svc: h3-29=”:443″; ma=2592000n Strict-Transport-Security: max-age=31536000; includeSubDomainsn MS-CV: ……1n Date: Mon, 17 Jun 2024 16:24:25 GMTn Content-Length: 112n Content-Type: application/json; charset=utf-8n Expires: -1n}]”
}
}
These 404 errors are returned when the UI makes requests like account?api-version=2023-10-01-preview, /accounts/features, /datagovernance/quality/business-domains/%7B%7BbusinessDomain%7D%7D/report, /catalog/api/atlas/v2/types/typedefs, etc.
The same 404 response is return for a request to /api/gateway/actions/collections/me with a list of roles in the request body such as [“Microsoft.Purview/accounts/data/read”,”Microsoft.Purview/accounts/data/write”,”Microsoft.Purview/accounts/source/read”,…….
I have the contributor role for the whole subscription and I am the one that created the purview account.
Am I missing any privileges?
Hi all,I have the “contributor” role in a subscription, and I created a new purview account. However, when I try accessing the Purview portal (both new and old) there are many missing buttons/functionality. I see there are several errors like the following one: {
“error”: {
“code”: “ResourceNotFound”,
“message”: “Authorization error:[ResourceNotFound:Response content: {“Message”:”The Gls FFO Tenant Region was not found for the given tenant: ………….”}, full response: StatusCode: 404, ReasonPhrase: Not Found, Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:n{n Cache-Control: no-cachen Pragma: no-cachen Server: Microsoft-HTTPAPI/2.0n X-BEServer: ……n X-NanoProxy: 1n X-AspNet-Version: 4.0.30319n Request-Id: ……n Restrict-Access-Confirm: 1n X-BEPartition: …..n X-CalculatedBETarget: ……….OUTLOOK.COMn X-BackEndHttpStatus: 404n X-BeSku: WCS7n X-End2EndLatencyMs: 76n x-ms-appId: …..n X-Proxy-BackendServerStatus: 404n X-Proxy-RoutingCorrectness: 1n X-FEServer: …..n X-FirstHopCafeEFZ: PHXn Alt-Svc: h3=”:443″; ma=2592000n Alt-Svc: h3-29=”:443″; ma=2592000n Strict-Transport-Security: max-age=31536000; includeSubDomainsn MS-CV: ……1n Date: Mon, 17 Jun 2024 16:24:25 GMTn Content-Length: 112n Content-Type: application/json; charset=utf-8n Expires: -1n}]”
}
} These 404 errors are returned when the UI makes requests like account?api-version=2023-10-01-preview, /accounts/features, /datagovernance/quality/business-domains/%7B%7BbusinessDomain%7D%7D/report, /catalog/api/atlas/v2/types/typedefs, etc. The same 404 response is return for a request to /api/gateway/actions/collections/me with a list of roles in the request body such as [“Microsoft.Purview/accounts/data/read”,”Microsoft.Purview/accounts/data/write”,”Microsoft.Purview/accounts/source/read”,……. I have the contributor role for the whole subscription and I am the one that created the purview account. Am I missing any privileges? Read More
Inability for External Presenters to Manage Breakouts is hurting our business in the L&D industry
I’ve raised this topic in various forums and at numerous conferences over the years, but I’m hoping we can initiate a productive dialogue here.
We operate in the L&D space, offering corporate training support for global clients across over a dozen platforms, and have been doing so since the days of Skype. Whether it’s WebEx, Adobe Connect, Zoom, or another platform, the process is generally straightforward. We receive host rights, and we’re set to go.
However, Microsoft Teams is an exception. From the beginning, conducting training sessions as an external vendor on Teams has been extremely challenging. Despite some improvements over the years, one critical piece of functionality is still missing: external users cannot manage breakout rooms.
This oversight is severely impacting our business, as well as many other small businesses like ours, as our corporate clients transition to Teams. Many organizations move to the Microsoft ecosystem partly due to their InfoSec policies, making the issuance of internal organization credentials difficult and often necessitating additional hardware.
It’s not just external vendors who are frustrated. Many of our clients, including the L&D departments of Fortune 500 companies, have actively opposed their companies’ transition to Teams.
We want to embrace these transitions and even endorse and encourage them. Is this functionality on the roadmap? Who do we need to speak to, or what actions are required to fully address this issue? We are eager to discuss the friction points of using Teams for training from the perspective of a company that has facilitated and supported hundreds of thousands of trainings across every major platform over the last decade.
Your thoughts and insights would be greatly appreciated.
I’ve raised this topic in various forums and at numerous conferences over the years, but I’m hoping we can initiate a productive dialogue here. We operate in the L&D space, offering corporate training support for global clients across over a dozen platforms, and have been doing so since the days of Skype. Whether it’s WebEx, Adobe Connect, Zoom, or another platform, the process is generally straightforward. We receive host rights, and we’re set to go. However, Microsoft Teams is an exception. From the beginning, conducting training sessions as an external vendor on Teams has been extremely challenging. Despite some improvements over the years, one critical piece of functionality is still missing: external users cannot manage breakout rooms.This oversight is severely impacting our business, as well as many other small businesses like ours, as our corporate clients transition to Teams. Many organizations move to the Microsoft ecosystem partly due to their InfoSec policies, making the issuance of internal organization credentials difficult and often necessitating additional hardware. It’s not just external vendors who are frustrated. Many of our clients, including the L&D departments of Fortune 500 companies, have actively opposed their companies’ transition to Teams.We want to embrace these transitions and even endorse and encourage them. Is this functionality on the roadmap? Who do we need to speak to, or what actions are required to fully address this issue? We are eager to discuss the friction points of using Teams for training from the perspective of a company that has facilitated and supported hundreds of thousands of trainings across every major platform over the last decade. Your thoughts and insights would be greatly appreciated. Read More
ntel Ethernet controller(3) I 225V issue
Hello,
I was having 2019 standard server, running, Added one SSD and Installed fresh new standard 2022 server. After installation, drivers are missing so exported from running 2019 server. All drivers are installed except one Network card. This card is Intel Ethernet controller(3) I 225V.. I tried all possible but did not find any luck. This 2022 server is not yet keyed, but I guess its good for next 180 days. what could be reason ?
Any help ?
Hello,I was having 2019 standard server, running, Added one SSD and Installed fresh new standard 2022 server. After installation, drivers are missing so exported from running 2019 server. All drivers are installed except one Network card. This card is Intel Ethernet controller(3) I 225V.. I tried all possible but did not find any luck. This 2022 server is not yet keyed, but I guess its good for next 180 days. what could be reason ? Any help ? Read More
Struggling with Vlookup / Index & Match
I need to match 2 columns of data to another sheet, then return another column of data only if they both match. I will attach a file in the reply.
Thank you,
Ambrosia
64-bit operating system, x64-based processor
Windows 10 Enterprise
Microsoft 365 Apps for enterprise
Version 2308
I need to match 2 columns of data to another sheet, then return another column of data only if they both match. I will attach a file in the reply. Thank you,Ambrosia 64-bit operating system, x64-based processorWindows 10 EnterpriseMicrosoft 365 Apps for enterpriseVersion 2308 Read More
Having SharePoint Search Bar search a specific site
Hi,
We are setting up a SharePoint site and would like to behavior of the SharePoint search to search that site collection, as well as a different site collection. I know it’s possible to change the search behavior for a site to either do that site, entire tenant or hub but we’d prefer to have it only search another site if possible.
Thanks.
Hi, We are setting up a SharePoint site and would like to behavior of the SharePoint search to search that site collection, as well as a different site collection. I know it’s possible to change the search behavior for a site to either do that site, entire tenant or hub but we’d prefer to have it only search another site if possible. Thanks. Read More
Audio module soft keys doesn’t work on Teams
Hi
I’m using this docking from HP which I think is great:
The only problem that I’m having is that the soft keys on the top and expecially:
mute
answer call
turn off call
doesn’t work with Team either old and new version of that.
Now I have seen this old discussion:
https://www.reddit.com/r/MicrosoftTeams/comments/k618e6/hp_thunderbolt_dock_integration/
where people where supposing that a firmware update from HP is needed to have them working with Teams and HP is never gonna release it. Now, frankly I don’t know but isn’t there a way to have them working without a firmware update?
Please note that these soft keys were working with old Skype For Business so I guess teams change some sort of protocol for that. Any hope to have them back working?
It’s kind of disappointing that the device is great and running but neither HP or Microsoft is gonna help doing a very minor update to have it fixed.
HiI’m using this docking from HP which I think is great:The only problem that I’m having is that the soft keys on the top and expecially:muteanswer callturn off calldoesn’t work with Team either old and new version of that.Now I have seen this old discussion:https://www.reddit.com/r/MicrosoftTeams/comments/k618e6/hp_thunderbolt_dock_integration/where people where supposing that a firmware update from HP is needed to have them working with Teams and HP is never gonna release it. Now, frankly I don’t know but isn’t there a way to have them working without a firmware update? Please note that these soft keys were working with old Skype For Business so I guess teams change some sort of protocol for that. Any hope to have them back working? It’s kind of disappointing that the device is great and running but neither HP or Microsoft is gonna help doing a very minor update to have it fixed. Read More
Formula Help: Count Unique Domains per Account ID
Hello Community!
I have an Excel file with two columns: Account ID and Domain Name. A single Account ID can have multiple Domain Names associated with it. In other words, the relationship between Account ID and Domain Name is one-to-many (1:N). What’s the best way to pull the number of UNIQUE domains associated with a specific account ID? Here is what the sample data might look like:
Account IDDomain Name1234f.com1234e.com1234g.com4321a.com4321b.com4321
b.com
5678z.com5678
y.com
For Account ID 1234, there are 3 unique domains. Similarly, there are 2 unique domains for account IDs 4321 and 5678. Can anyone please assist.
Hello Community! I have an Excel file with two columns: Account ID and Domain Name. A single Account ID can have multiple Domain Names associated with it. In other words, the relationship between Account ID and Domain Name is one-to-many (1:N). What’s the best way to pull the number of UNIQUE domains associated with a specific account ID? Here is what the sample data might look like: Account IDDomain Name1234f.com1234e.com1234g.com4321a.com4321b.com4321b.com5678z.com5678y.com For Account ID 1234, there are 3 unique domains. Similarly, there are 2 unique domains for account IDs 4321 and 5678. Can anyone please assist. Read More
AzureOpenAI doesn’t support parameter chunking_strategy while creating vector store.
OpenAI recently added a new feature to their library, which says we can customize the chunking strategy used to split and store files in vector stores using the new parameter “chunking_strategy” to be used while creating a vector store.
If I try creating a new vector store mentioning the custom chunking strategy using the OpenAI client, I am able to successfully create one.
But, if I try creating a new vector store mentioning the custom chunking strategy using the AzureOpenAI client, I get BadRequestError which says unknown parameter: chunking_strategy.
I have tried upgrading the openai python library, but that doesn’t solve the issue.
I request AzureOpenAI to update their module as per the changes done by openai library.
OpenAI recently added a new feature to their library, which says we can customize the chunking strategy used to split and store files in vector stores using the new parameter “chunking_strategy” to be used while creating a vector store.If I try creating a new vector store mentioning the custom chunking strategy using the OpenAI client, I am able to successfully create one.But, if I try creating a new vector store mentioning the custom chunking strategy using the AzureOpenAI client, I get BadRequestError which says unknown parameter: chunking_strategy.I have tried upgrading the openai python library, but that doesn’t solve the issue.I request AzureOpenAI to update their module as per the changes done by openai library. Read More
% Complete and % Work Complette do not update with Actual Start change.
Changing the date in Actual Start does not update the values in % Complete and % Work Complete columns, they stay at 0. If the Actual Finish date has any date at all, the percentages go to 100%.
Is Project supposed to be automatically calculating those % complete columns or am I missing steps?
Windows 11
Project Online Desktop Client v2405
Changing the date in Actual Start does not update the values in % Complete and % Work Complete columns, they stay at 0. If the Actual Finish date has any date at all, the percentages go to 100%. Is Project supposed to be automatically calculating those % complete columns or am I missing steps? Windows 11Project Online Desktop Client v2405 Read More
Edge reminded me to add the placeholder property to the file upload control.
Form elements must have labels: Element has no title attribute Element has no placeholder attribute [Error]
“`html
<input type=”file” name=”file” accept=”.*”>
“`
Form elements must have labels: Element has no title attribute Element has no placeholder attribute [Error]“`html<input type=”file” name=”file” accept=”.*”>“` Read More
Creating a Hyperlink to Trigger Conditional Formatting
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA?
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA? Read More
Copy data task in pipeline gives error “InternalServerError executing request”
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it?
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it? Read More
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Attention Azure users!
This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.
Both will be discontinued on August 31, 2024.
To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date.
Why the Change?
Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:
Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process.
Taking Action: Migrate to Azure Update Manager
To avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition:
Move from Automation Update Management to Azure Update Manager
https://learn.microsoft.com/en-us/azure/automation/update-management/overview
This guide details the migration process, ensuring a smooth transfer to the new platform.
Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent.
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement Attention Azure users!This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.Both will be discontinued on August 31, 2024.To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date. Why the Change?Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process. Taking Action: Migrate to Azure Update ManagerTo avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition: Move from Automation Update Management to Azure Update Managerhttps://learn.microsoft.com/en-us/azure/automation/update-management/overviewThis guide details the migration process, ensuring a smooth transfer to the new platform. Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent. Read More
RETIREMENT ANNOUCEMENT: AZ-1001: Deploy and manage containers using Azure Kubernetes Service
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
Combining Excel Files
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.
Each file contains different data but the headers in bold are the same.
I tried to combine these using power query but came across 2 main issues and didnt get very far:
1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder)
2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows.
Can anybody please advise me the best solution here?
(I am using a mac and will receive new data every month)
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.Each file contains different data but the headers in bold are the same. I tried to combine these using power query but came across 2 main issues and didnt get very far:1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder) 2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows. Can anybody please advise me the best solution here? (I am using a mac and will receive new data every month) Read More
generate a list of instances
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much!
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much! Read More
MS List no space for unique value
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:
Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique value
Does anyone know what is happening and/or has a solution?
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique valueDoes anyone know what is happening and/or has a solution? Read More
Help! – Excel formatting shifts columns after filtering
Hello,
I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal.
Hello, I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal. Read More