Category: Microsoft
Category Archives: Microsoft
I installed SSMS 2022 express and when I am trying to import data its throwing errors
TITLE: SQL Server Import and Export Wizard
——————————
The operation could not be completed.
——————————
ADDITIONAL INFORMATION:
External component has thrown an exception. (System.Data)
——————————
BUTTONS:
OK
——————————
this is the error
and some more errors also came and I resolved with too much hectic but this error I am not able to with this error
can you anybody help me with this
TITLE: SQL Server Import and Export Wizard——————————The operation could not be completed.——————————ADDITIONAL INFORMATION:External component has thrown an exception. (System.Data)——————————BUTTONS:OK——————————this is the error and some more errors also came and I resolved with too much hectic but this error I am not able to with this error can you anybody help me with this Read More
Migrating our local Active Directory servers to the cloud
Hello
Please i need your help on this issue.
Please what’s involved in migrating our local Active Directory servers to the cloud? Does Microsoft Fast Track assist with AD migration?
Hello Please i need your help on this issue. Please what’s involved in migrating our local Active Directory servers to the cloud? Does Microsoft Fast Track assist with AD migration? Read More
Print queue won’t display active print jobs sometimes on the local Win 11 PC,
We have deployed a Lexmark printer over the network via a Print Server. Users sometimes won’t see the active print jobs when they need to reprint from their local computer which is Windows 11. We tested it on a Win 10 computer and it seems to work fine.
We have deployed a Lexmark printer over the network via a Print Server. Users sometimes won’t see the active print jobs when they need to reprint from their local computer which is Windows 11. We tested it on a Win 10 computer and it seems to work fine. Read More
Lesson Learned #499: HikariCP Retry Policy – The connection is closed
Today, I worked on a service request that our customer got the following error message:
19:28:43.232 [main] WARN com.zaxxer.hikari.pool.PoolBase – AppExample-ConnectionPooling – Failed to validate connection ConnectionID:3 ClientConnectionId: 8351bddc-acbb-4669-xxxx-xxxxxxxxxxxx (The connection is closed.). Possibly consider using a shorter maxLifetime value.
19:28:43.234 [AppExample-ConnectionPooling connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase – DotNetExample-ConnectionPooling – Closing connection ConnectionID:3 ClientConnectionId: 8351bddc-acbb–xxxx-xxxxxxxxxxxx: (connection is dead). Following I would like to share my experience with this error.
This error indicates that the connection was closed unexpectedly and cannot be reused. In this situation, HikariCP will evict the connection from the pool and open a new one according to its Retry Logic policy.
Let me explain the Retry Logic with an example. Before providing a valid connection to the application or returning it to the HikariCP pool, the software validates the connection by checking the port and running a validation query, such as SELECT 1.
As we can see below, when a dead connection is detected, a new connection is immediately opened or reused to provide a valid connection to the application. In my case, working from home and connecting to the West Europe region, establishing a connection took around 46 ms. Running the client machine from Azure would reduce this time.
19:41:34.359 [SingleThread] Connecting to Database
19:41:34.362 [main] WARN com.zaxxer.hikari.pool.PoolBase – AppExample-ConnectionPooling – Failed to validate connection ConnectionID:1 ClientConnectionId: d0f3613f-47d6 (The connection is closed.). Possibly consider using a shorter maxLifetime value.
19:41:34.365 [AppName-ConnectionPooling connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase – AppNameExample-ConnectionPooling – Closing connection ConnectionID:1 ClientConnectionId: d0f3613f-47d6: (connection is dead)
19:41:34.405 [SingleThread] Connected to Database
19:41:34.412 [SingleThread] Connection Time (ms) 46
19:41:34.450 [SingleThread] Reading Data exec testconn
Other lesson learned is what happens if the connection is established but the validation query (SELECT 1) gives an error or takes more time than the validation timeout is specified, we are going to have another error like this one: [main] ERROR com.zaxxer.hikari.pool.PoolBase – AppExample-ConnectionPooling – Failed to execute connection test query (Read timed out).
Microsoft Tech Community – Latest Blogs –Read More
Pushing fonts to desktop
How can we push our brand fonts out to the desktop version of every employee account instead of having them individually installed them?
How can we push our brand fonts out to the desktop version of every employee account instead of having them individually installed them? Read More
Best practise for create sites based on template include folders/files
I have a site with lot of folders and subfolders, and some template documents.
Bases on this site I want to create project sites from a Power App.
I have created a Power App which trigger a Power Automate that trigger a Azure Automation Runbook.
It works, but:
Takes long time to run the runbook. Any optimizing that can be done?
What is the best Powershell cmdlet to create folder/subfolder/files?
And most important question….am I on the right path? In some way it feels like overengineering.
I have a site with lot of folders and subfolders, and some template documents. Bases on this site I want to create project sites from a Power App. I have created a Power App which trigger a Power Automate that trigger a Azure Automation Runbook. It works, but:Takes long time to run the runbook. Any optimizing that can be done?What is the best Powershell cmdlet to create folder/subfolder/files? And most important question….am I on the right path? In some way it feels like overengineering. Read More
Assess and improve your digital skills with the Digital Skills Compass
Do you ever wonder how well you are using technology? Do you want to learn new skills and stay updated in the digital age? Do you need guidance on what training activities to pursue and where to find them?
If you answered yes to any of these questions, then you might be interested in the Digital Skills Compass, a free and easy-to-use tool that helps you assess and improve your digital skills across seven areas: data fluency, effective communication and collaboration, content creation and management, cybersecurity, personal wellbeing, energy use and environment impact, computational thinking and continuous learning.
For anyone who wants to learn new skills, the Digital Skills Compass can help you achieve your goals. Try it today and see for yourself!
Do you ever wonder how well you are using technology? Do you want to learn new skills and stay updated in the digital age? Do you need guidance on what training activities to pursue and where to find them?
If you answered yes to any of these questions, then you might be interested in the Digital Skills Compass, a free and easy-to-use tool that helps you assess and improve your digital skills across seven areas: data fluency, effective communication and collaboration, content creation and management, cybersecurity, personal wellbeing, energy use and environment impact, computational thinking and continuous learning.
For anyone who wants to learn new skills, the Digital Skills Compass can help you achieve your goals. Try it today and see for yourself!
Read More
Unable to Access Microsoft Fabric Trial for Microsoft Build Challenge
Dear Microsoft Team,
I hope this message finds you well.
I am currently participating in the Microsoft Build: Microsoft Fabric challenge collection. Unfortunately, I have been unable to access the Fabric trial version, which is essential for completing the course.
Could you please assist me in resolving this issue? Any guidance or support to help me gain access to the trial version would be greatly appreciated.
Thank you for your attention and assistance.
Best regards,
Tharra Reema
Dear Microsoft Team,I hope this message finds you well.I am currently participating in the Microsoft Build: Microsoft Fabric challenge collection. Unfortunately, I have been unable to access the Fabric trial version, which is essential for completing the course.Could you please assist me in resolving this issue? Any guidance or support to help me gain access to the trial version would be greatly appreciated.Thank you for your attention and assistance.Best regards,Tharra Reema Read More
Microsoft UI Automation and Edge v125+
We are using the C++ UIA library to run Automations in Edge and we have noticed a rather large performance slowdown since updating to Edge version 125.
The major offender seems to be a call to IUIAutomationElement::FindAll, although never the speediest of requests, this was working fine with version 124 and below.
We have also tested the beta release of 126 and the Dev version of 127 and are seeing the same issue.
UIA performance when interacting with Chrome, and other desktop applications is unaffected, it is only when interacting with the latest Edge releases we are seeing a problem.
We are using the C++ UIA library to run Automations in Edge and we have noticed a rather large performance slowdown since updating to Edge version 125. The major offender seems to be a call to IUIAutomationElement::FindAll, although never the speediest of requests, this was working fine with version 124 and below. We have also tested the beta release of 126 and the Dev version of 127 and are seeing the same issue. UIA performance when interacting with Chrome, and other desktop applications is unaffected, it is only when interacting with the latest Edge releases we are seeing a problem. Read More
How to import PST to Gmail Without Outlook?
Basically you will need to install Advik PST to Gmail Converter. This software will transfer emails from PST to Gmail account. With this application, you can import PST to Gmail without Outlook in bulk. All the emails and folders will be transfered successfuly.
Steps to import PST to Gmail without Outlook
Run Advik PST to Gmail Converter in your PC.Click Add File and Outlook.pst file.Select mailbox folders and click Next.Choose Gmail as saving option.Enter Gmail credentials and Click Convert.
Done! This is how you can import PST to Gmail without Outlook.
Basically you will need to install Advik PST to Gmail Converter. This software will transfer emails from PST to Gmail account. With this application, you can import PST to Gmail without Outlook in bulk. All the emails and folders will be transfered successfuly. Steps to import PST to Gmail without OutlookRun Advik PST to Gmail Converter in your PC.Click Add File and Outlook.pst file.Select mailbox folders and click Next.Choose Gmail as saving option.Enter Gmail credentials and Click Convert.Done! This is how you can import PST to Gmail without Outlook. Read More
My onedrive when I Google my old photos ,videos,albums ,files get lost ,which is I don’t get it why?
onedrive never backup my photos ,files anyway is failing why? Try the best as you can please Microsoft.
onedrive never backup my photos ,files anyway is failing why? Try the best as you can please Microsoft. Read More
How to Convert OST to PST in 2024?
Download the Advik OST to PST Converter software in your PC. This is the best tool to convert OST file to PST format. The software considered amoung the top leading application to export emails, contacts and calendar data from Outlook data file into PST file. You can convert multiple OST files to PST in one single attempt. Try the demo version which is completely free.
Steps to Convert OST to PST free
Launch Advik OST to PST Converter in your PC.Click Select Files and add Outlook.ost file.Select mailbox folders and click Next.Choose PST as saving option.Click Convert button.
Finished! The software will imideatly start converting OST file to PST format.
Download the Advik OST to PST Converter software in your PC. This is the best tool to convert OST file to PST format. The software considered amoung the top leading application to export emails, contacts and calendar data from Outlook data file into PST file. You can convert multiple OST files to PST in one single attempt. Try the demo version which is completely free. Steps to Convert OST to PST freeLaunch Advik OST to PST Converter in your PC.Click Select Files and add Outlook.ost file.Select mailbox folders and click Next.Choose PST as saving option.Click Convert button.Finished! The software will imideatly start converting OST file to PST format. Read More
How to Open/Import OST file in Outlook?
Microsoft doesn’t provide any option to open OST file in Outlook. However you can try the alternate solution. Actually you can import data in .pst file in Outlook. So you have to convert OST to PST format. For that you will need to download and install Advik OST to PST Converter from official website of Advik Software.
With this software you can convert OST into PST format. After that import PST file in Outlook 2016, 2019 or 2021 version.
Microsoft doesn’t provide any option to open OST file in Outlook. However you can try the alternate solution. Actually you can import data in .pst file in Outlook. So you have to convert OST to PST format. For that you will need to download and install Advik OST to PST Converter from official website of Advik Software. With this software you can convert OST into PST format. After that import PST file in Outlook 2016, 2019 or 2021 version. Read More
AUTHENTICATION IN AZURE LOAD TESTING SERIES: GENERATE AND REFRESH ACCESS TOKENS WITH JMeter
Whenever you run load tests on your endpoints in Azure Load Testing, there might be a situation where your endpoints require an access token. We have seen that before load testing these endpoints, most users generate an access token and store it in the Azure Key Vault. They then pass this token as a variable in the Header of the request as a bearer token to authenticate at the endpoint. But there might be a few problems with this approach:
Sometime has elapsed between the act of storing the token in the key vault and the start of execution of the test. There can be a case where the token might expire during the test run and the request at the endpoints start throwing errors.
Only one static token is stored in the key vault and is used for all the requests. When we are load testing with multiple Virtual Users, we want a situation where all users have a unique access token while making the requests, as it will mimic a real-life scenario. Currently scaling is there, but the authenticity is lost.
Most access tokens have a lifetime of around 60-75 minutes on an average. When we are running load tests for longer durations (E.g.- Soak Tests), it is almost certain that the access token will get expired during the execution of the test. We would like to have some sort of control where the service intelligently identifies when a token is going to get expired, and renews it, so that the test can carry on as usual.
This blog covers how you can create a JMeter Test plan, where you can implement a mechanism to generate and refresh access tokens which are unique for every user and run it at scale in Azure Load Testing.
PREREQUISITES
An Azure Load Testing Resource
Azure Key Vault for storing secrets
JMeter
Azure Load Testing Resource configured to fetch secrets during runtime
CREATING THE TEST PLAN IN THE JMETER GUI
Test Plan
Create a Test Plan in JMeter. Add your variables in the “User defined variable section.” If you are testing an Azure endpoint, you may need to use the GetSecret function to store the client_ID, client_secret, tenant_ID etc. Proceed to the config elements and add a HTTP Cookie Manager and HTTP Cache Manager. Make sure to select the option to clear cache and cookies on each iteration.
Thread Group
Create a Thread Group and provide the required inputs. Enable the “Start Next Thread Loop” Option. Set the Loop Count to infinite and set the test duration.
Token Loop
Inside the Thread Group, create a Loop Controller and set the loop count to infinite. Further, inside the loop controller, add two more controllers: The transaction controller, which will generate the token and the runtime controller, which will refresh the token.
Access Token Generation
Inside the Transaction Controller, add an HTTP Sampler and setup a POST request to the token endpoint to fetch the access token. Set “grant type” as “client credentials” and “ignore Cache” as “true”. Add a HTTP Header Manager to the sampler and add the Content-Type as “application/x-www-form-urlencoded” and set the Authorization depending upon the configuration done at the token endpoint.
Access Token Extraction
Add a JSON extractor to extract the access token and set it in a variable which will be used going forward.
Access Token Refresh
Proceed to the runtime controller. In the Runtime section, specify the time after which you want the token to be refreshed. Usually token lasts for 60 minutes. Make sure to include some buffer time before token expiry. You can also extract the expiry time of the token, store it in a variable and pass it here.
Target Endpoint
Add another HTTP Sampler, this time sending a GET request to the target endpoint. In the HTTP Header Manager, set Authorization to Bearer ${token}.
Add some listeners like View Results tree, Summary Report etc to analyse the results locally. Results should look something like this.
Now the JMeter script is complete and can be used in Azure Load Testing to run it at scale.
Creating and Running the Load Test
Upload the JMeter Script in the Test plan tab.
Configure the Secrets section under the Parameters tab. Now, we are all set to launch the test.
CONCLUSION
Now you can run your load tests for an even longer duration without having to worry about the expiry of access tokens.
Try this this out and let us know if this works for you. Please use the comments section or use our feedback forum.
HAPPY LOAD TESTING!!
Microsoft Tech Community – Latest Blogs –Read More
Changes coming to the Azure Update Delivery service tag
Azure Update Delivery service tag is being deprecated starting July 1, 2024. If your Azure Firewall is configured to receive Windows updates using this service tag, you’ll need to migrate away from the service tag and use Azure Firewall application rules instead.
In this article, let’s talk about the Azure Update Delivery service tag, what’s changing, and specific actions to take today.
What is the Azure Update Delivery service tag?
Azure Firewall service tags are collections of IP addresses and ranges associated with a named resource. They simplify the process of configuring your firewall. The tags are automatically updated to reflect changes to IP addresses. This means that you don’t need to monitor or manually adjust your firewall rules with such address changes.
Tip: Read an overview of Azure Firewall service tags.
The AzureUpdateDelivery service tag has been used to enable Windows devices to scan for Windows updates. The process of scanning connects a Windows device to Microsoft Windows Update services, checking for any necessary operating system updates, drivers, firmware, and applications.
The AzureUpdateDelivery service tag allows the Azure Firewall to recognize the specific IP addresses used by Microsoft Windows Update scanning. This helps ensure that your Windows devices are securely connecting to the correct Microsoft services with confidence.
After your Windows device completes a Windows Update scan, it identifies the needed content updates. Then, the device downloads and verifies the content using the URLs that it learned during the scan. Installation follows.
To enable Azure Firewall to authorize these downloads, you may have used the “AzureFrontDoor.FirstParty” service tag. This service tag represents a list of trusted IP addresses from which you can download update content. After download, the content is validated for security and integrity before it’s installed on your device.
What is changing?
Due to changes in the workflow, content downloads may now come from trusted third-party Content Delivery Networks (CDN) outside of the Azure network. However, these aren’t addressable through a service tag. Therefore, while scanning for updates, the secondary stage of content download might fail.
We recommend switching from using service tags (like AzureUpdateDelivery and AzureFrontDoor.FirstParty) to application firewall rules. Keep in mind that third-party CDNs can’t create Azure Firewall service tags that contain their IP addresses. When you shift to using Azure Firewall application rules with Fully Qualified Domain Name (FQDN) filtering tags, you’ll perform the same task using DNS hosts.
Continue reading to learn more about this recommended process.
How do I know if I’m using the Azure Update Delivery service tag?
The AzureUpdateDelivery and AzureFrontDoor.FirstParty service tags are not automatically applied. A network administrator, possibly you, or someone before you, must have explicitly applied them as Azure Firewall rules.
If you’re not sure whether these tags are in use, check your Azure Firewall policy network rules for these specific destination service tags. For more information on firewall rules, refer to the Azure Firewall Basic features documentation.
What should I do if I use the Azure Update Delivery service tag?
Please move away from using the AzureUpdateDelivery and AzureFrontDoor.FirstParty service tags. Instead, follow these recommendations for enterprise scenarios:
Azure Firewall application rule with the Windows Update fully qualified domain name (FQDN) tag. Set your Azure Firewall policy with an application rule configured for the Windows Update FQDN tag. This tells the firewall exactly which Windows Update-related hosts to trust when scanning and downloading content. Use this strategy for both Windows desktop and server devices.
Use published Microsoft guidance for your firewall or proxy. Microsoft publishes guidance on how you can configure your enterprise firewall and proxy services to enable proper access to Windows Update services.
Use Windows Service Update Services (WSUS). This enterprise solution provides a service inside your network permitter. That’s where your Windows devices can scan and download update content.
Creating Windows Update application firewall rules
We recommend that you use the Windows Update FQDN tag to configure your Azure Firewall to permit Windows updates for your Windows devices. Azure manages the FQDNs associated with Windows Update for both scanning and content download.
You can do this by adding an application rule to your Azure Firewall policy resource. Note that you can create these application FQDN filtering rules in any Azure Firewall (from basic to premium). See an example in Application FQDN filtering rules.
When you create the application rule, configure it with the following:
From the Destination Types options, choose FQDN Tag.
In the FQDN Tags option, select the pre-defined FQDN tag called WindowsUpdate.
For the Protocol option, enter “HTTP:80,HTTPS:443.”
Leave any TLS inspection option unselected if your firewall offers it.
After saving this application rule and allowing it to be deployed, your Windows devices will properly scan, download, and install updates.
Using Microsoft guidance for enterprise firewalls and proxies
If you use your own firewall or proxy services, then configure them per the official Microsoft guidelines:
Manage connection endpoints for Windows 11 Enterprise
Manage connection endpoints for Windows 10 Enterprise
This documentation applies to both Windows client and server devices.
Using Windows Server Update Services
Another option is to keep all Windows updates limited inside your network. That way, your devices never connect to the internet for scanning or downloading. You can achieve this using WSUS.
In this case, a Windows Server is configured with the WSUS feature, and Windows devices are configured to use this server for both scanning and content download.
Follow guidance on deploying and using WSUS here:
Deploy Windows Server Update Services
Plan deployment for updating Windows VMs in Azure
Azure Update Delivery service tags have been marked for deprecation for some time now (find it in Azure service tags overview). Deprecation isn’t just a part of a product’s lifecycle but an essential part of your larger security strategy as you keep your environment up to date. Thankfully, you have two possible solutions to choose from. Let’s get you ready for July 1st!
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X/Twitter. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Custom Classification Not Assigning – Unable to verify Classification Rule – System Error
Hello, I am experiencing an issue when trying to scan and apply custome classifications. I am the Collection Admin (and inherited for Data Source Admin and Data Curator). I am using the new Purview portal.
I am able to create the Classifications, the Classification Rules and when I run the scans none of my (15) custome classifications get assigned. The rule is basic to locate a series of ‘INV001’ for Invoice, ‘OWN001’ for Owner, etc. I create the classification Data Pattern via uploading a sample file to get the Purview recommended pattern (^[0-9]+[a-zA-Z]$). But when I run the scan I get zero custom matches for my files.
When I go back into the Classification Rule and run a Test Classification Rule, I upload a sample file of the simple rules i am trying to validate (INV001 or OWN001 etc. ) – using the same file that proposed the pattern, I get an error ‘A system error occurred. Unable to verify classification rule’.
I have seen the requirements to be the following:
Check if you have the correct permissions to apply custom classifications and classification rules. You need to have data curator or data source administrator permissions on any collection to be able to create a custom classification. //YES, I have these roles.//Check if the scan rule set is configured correctly. The scan rule set determines which classifications will be compared and applied to your data. For more information, see how Microsoft Purview classifies assets in the provided document.//Yes, this is the file used to create the pattern in the rule//Check if there are any issues with the data source itself. You can try rescanning the data source and see if the issue persists.//The files tested are simple 10 row files created for this purpose//
I have retried several times and keep getting zero custom classifications applied. Any guidance from successful custom classifications in the new portal is appreciated.
Hello, I am experiencing an issue when trying to scan and apply custome classifications. I am the Collection Admin (and inherited for Data Source Admin and Data Curator). I am using the new Purview portal. I am able to create the Classifications, the Classification Rules and when I run the scans none of my (15) custome classifications get assigned. The rule is basic to locate a series of ‘INV001’ for Invoice, ‘OWN001’ for Owner, etc. I create the classification Data Pattern via uploading a sample file to get the Purview recommended pattern (^[0-9]+[a-zA-Z]$). But when I run the scan I get zero custom matches for my files. When I go back into the Classification Rule and run a Test Classification Rule, I upload a sample file of the simple rules i am trying to validate (INV001 or OWN001 etc. ) – using the same file that proposed the pattern, I get an error ‘A system error occurred. Unable to verify classification rule’. I have seen the requirements to be the following:Check if you have the correct permissions to apply custom classifications and classification rules. You need to have data curator or data source administrator permissions on any collection to be able to create a custom classification. //YES, I have these roles.//Check if the scan rule set is configured correctly. The scan rule set determines which classifications will be compared and applied to your data. For more information, see how Microsoft Purview classifies assets in the provided document.//Yes, this is the file used to create the pattern in the rule//Check if there are any issues with the data source itself. You can try rescanning the data source and see if the issue persists.//The files tested are simple 10 row files created for this purpose//I have retried several times and keep getting zero custom classifications applied. Any guidance from successful custom classifications in the new portal is appreciated. Read More
Additional Group Policy Objects in AD than expected
There is 1 additional Policy Object in the Active Directory (DOMAINSystemPolicies) that does not have a matching Group Policy Object in the nor \DomainSysvolDomainPolicies
What is the appropriate method to remove the object from the AD? I suspect this object may be an issue creating minor problems on my domain.
There is 1 additional Policy Object in the Active Directory (DOMAINSystemPolicies) that does not have a matching Group Policy Object in the nor \DomainSysvolDomainPolicies What is the appropriate method to remove the object from the AD? I suspect this object may be an issue creating minor problems on my domain. Read More
What’s New in Copilot | May 2024
Welcome to the May 2024 edition of What’s New in Copilot for Microsoft 365. Every month, we highlight new end-user and admin features in Copilot for Microsoft 365, enabling you to better prepare, plan, and roll out Copilot features that help your users be more productive and efficient in the apps you use every day. This month, we’re excited to share how admins can manage risk and compliance requirements for AI apps in the new Microsoft Purview AI Hub, automate tasks across the organization using Copilot extensions, and more. We’re also adding exciting new capabilities that enable you to act on employee suggestions quickly using Copilot in Glint, use Copilot in Planner to transform teamwork, expand new prompt collections for industry roles, and much more!
And make sure to catch up on our recent Work Trend Index report, as well as Grow with Copilot, a new series where we curate relevant news, insights, and resources to help small and medium organizations harness the power of Copilot.
Now let’s take a look at this month’s updates:
Admin and management capabilities:
Discover how your organization is using AI with Microsoft Purview AI Hub
Automate tasks across your enterprise with Copilot extensions
Review and audit site permissions with Restricted SharePoint Search
Integrate and innovate with new Copilot connectors
End-user capabilities:
Act on employee comments and suggestions instantly with Copilot in Viva Glint
Transform the way your team works with Copilot in Planner
Explore new prompts unique to roles and industries in Copilot Lab
Discover catch-up in Copilot chat
Improve the way you draft and refine your Word documents
Collaborate without switching context with Copilot in Loop components
Boost response rates with Copilot in Forms
Discover how your organization is using AI with Microsoft Purview AI Hub
Now in Public Preview, AI Hub in Microsoft Purview helps support your organization’s risk and compliance requirements for AI apps such as Copilot for Microsoft 365 and third-party apps and provides ready-to-use policies to protect data. In the AI Hub, you can gain visibility into insights like sensitive data shared with Copilot, total number of users interacting with Copilot, and their associated risk level.
Insights into unlabeled files and SharePoint sites referenced by Copilot for Microsoft 365 will also be included in the Public Preview release of the AI Hub. This helps you prioritize the most critical data risks and put protection policies in place to prevent potential oversharing of sensitive data. Additionally, AI Hub provides visibility into non-compliant use of AI interactions to help you quickly gain insight into unethical use, such as regulatory collusion, money laundering, targeted harassment, and more. Lastly, guided assistance for emerging AI regulations like EU AI Act, NIST AI RMF, ISO/IEC 23894:2023 and ISO/IEC 42001 will be surfaced in the AI Hub to help you assess, implement, and strengthen compliance controls to meet AI regulatory requirements and standards. Learn more about AI Hub in Microsoft Purview.
Automate tasks across your enterprise with Copilot extensions
Last week at Build, we announced Copilot extensions that make it easier than ever to extend and customize Microsoft Copilot for your unique business needs and processes. Extensions within Copilot enable new actions and customized knowledge for grounding and can be built using Copilot connectors, plugins, and your own copilots.
Soon, admins will be able to create Copilot extensions using Microsoft Graph connectors from Microsoft 365 admin center, so users can perform targeted searches, natural language queries, and custom communications on semantically indexed third-party data in Microsoft Graph using predefined prompts, all within the familiar Copilot for Microsoft 365 interface. This feature will begin rolling out in July. Reach out to MicrosoftGraphConnectorsFeedback@service.microsoft.com for more details.
Review and audit site permissions with Restricted SharePoint Search
Restricted SharePoint Search is now generally available for Copilot for Microsoft 365, enabling admins to review content management and data governance practices without losing momentum with Copilot deployment. Microsoft 365 admins can turn off organization-wide search and restrict both Enterprise Search and Copilot experiences to a curated set of SharePoint sites, so they can review and audit site permissions in parallel with the Copilot rollout. Users in the organization can continue to interact with files and content they own or that they have previously accessed in Copilot. Please view the Microsoft Learn article for more information and check the public roadmap for rollout status.
Integrate and innovate with new Copilot connectors
Copilot Studio is introducing Copilot connectors to enable an enterprise to connect their business, collaboration, and analytical data to their copilots. Copilot connectors include Microsoft Power Platform connectors, Microsoft Graph connectors, and Power Query connectors—with Microsoft Fabric integrations coming soon. This makes it possible to ground copilots in specific data sources, including public websites, Microsoft SharePoint, Microsoft OneDrive, Microsoft Dataverse tables, Microsoft Fabric OneLake, and Microsoft Graph, as well as leading third-party apps. Starting in June 2024, admins can access the preview to curate and manage available Copilot connectors to ensure their developers are using a trusted catalog.
Act on employee comments and suggestions instantly with Copilot in Viva Glint
Understanding the voice of the employee through all types of surveys (i.e. engagement, onboarding, exit, and others) is critical to improving employee engagement, productivity, and retention. For organizations and large teams, these surveys generate thousands of employee comments that must be analyzed manually.
Using Copilot in Viva Glint, leaders can get key insights instantly from the thousands of comments. This helps organizations save hundreds of hours spent manually analyzing the feedback. With Copilot, Viva Glint can summarize, explore, and act on suggestions with quicker time to action.
Copilot in Viva Glint will be available for Public Preview in June. Check out how customers are benefiting from this quicker time to action, such as Phillips 66 – they saved two months of analysis with Copilot in Viva Glint. For a deeper understanding, you can read this blog and view a demo of Copilot in Viva Glint.
Transform the way your team works with Copilot in Planner
Copilot in Planner helps teams transform the way they work and collaborate on projects together. With the power of generative AI, Copilot in Planner streamlines the planning, management, and execution of your work, keeping you informed as you achieve your goals:
Get started with a plan – Copilot can take a natural language prompt and generate a plan for you, including goals, tasks and subtasks, and buckets.
Manage your plan – As your plan evolves, Copilot can suggest new tasks for you based on your new goals and keep you organized with new buckets where needed. Copilot can even help you add goals to your plan and generate tasks to achieve those goals.
Track progress – Copilot can answer questions about your plan and help you stay informed about the latest developments.
Learn more about Copilot in Planner in this blog. Copilot in Planner (preview) is currently rolling out to the new Microsoft Planner in Teams.
Explore new prompts unique to roles and industries in Copilot Lab
Earlier this month, we announced new prompt publishing capabilities coming to Copilot Lab that enable you to create, publish, and manage prompts within your organization. Now we are building on that value by introducing suggested prompts to inspire and guide you on your prompt creation journey. These prompts not only help you get started quickly but can be customized with role or industry specific details, best practices, and context to reduce trial and error and ensure high-quality output.
Visit Copilot Lab today to discover new prompt collections for HR and Marketing roles. You can also explore industry-specific prompts spanning across financial services, retail, and manufacturing. Additional prompts for additional roles and industries will be added to Copilot Lab in the coming weeks and months, so check back often.
Discover catch-up in Copilot chat
Catch-up in Copilot chat is your go-to resource for staying on top of your workday. Whether you’re preparing, reviewing, or striving to stay ahead, Copilot has you covered with proactive suggestions in the flow of work. Effortlessly navigate through recent updates and activity to gain the clarity and control you need to make every day more productive. Catch-up in Copilot chat is rolling out this month.
Improve the way you draft and refine your Word documents
Often, it’s easier to start on a new piece of work if you can reference or build upon existing content. That’s why we’ve added the ability to draft with Copilot based on a specific selection in your Word doc. This will help to:
Refine, rewrite, or paraphrase an existing selection
Elaborate on, expand upon, or explain your selected content in more detail
Enhance your content with statistics and additional information
Whether you are referencing selected text, a list, or a table, Copilot in Word provides a rich and interactive experience that will make your job easier. This feature started rolling out in April.
Collaborate without switching context with Copilot in Loop components
Microsoft Loop enables you and your team members to work together with Copilot. In the Loop app, you can co-prompt with Copilot, building off each other’s ideas and Copilot’s suggestions to maximize your creativity and collaboration. Copilot in Loop components is rolling out now, so you can experience this collaboration without switching context. Simply start a Loop component in Teams, Outlook, or Collaborative Meeting Notes and use Copilot to create or update content in the Loop component. When you share the Loop component in other apps, your Copilot conversation carries over so you can continue refining your prompts until everyone is happy with the results.
Boost response rates with Copilot in Forms
Copilot in Forms will now email response rates to a form’s owner and offer proactive recommendations for follow-up actions. For example, if the response rate is low, the form owner can use Copilot to quickly write and send reminders. Additionally, when a form has received sufficient responses, Copilot prompts the owner to review the form’s insights for informed decision-making. This feature is rolling out now.
Did you know? The Microsoft 365 Roadmap is where you can get the latest updates on productivity apps and intelligent cloud services. Check back regularly to see what features are in development or coming soon.
Please note that the dates mentioned in this article are tentative and subject to change. For the most accurate and up-to-date information, we encourage you to regularly check the Microsoft 365 Roadmap.
Microsoft Tech Community – Latest Blogs –Read More
How Generative AI Can Power Knowledge Management for Your Business
As a business leader, you know the value of having access to the right information at the right time. Whether you need to make strategic decisions, solve problems, or answer customer queries, you want to leverage the knowledge that is stored in your documents and databases. But how can you find the most relevant and accurate answers from the vast amount of unstructured data that you have?
One possible solution is to use generative AI, a type of artificial intelligence that can create new content based on existing data. Generative AI can help you transform your unstructured data into a searchable and interactive knowledge base that can power natural language conversations with your end users. In this blog post, we will show you how you can use Azure OpenAI and Cognitive Search to create chat bots that can answer challenging questions from your documents.
What is Azure OpenAI and Cognitive Search?
Azure OpenAI is a cloud service that provides access to powerful language models, such as GPT-3, that can generate natural language responses based on user inputs. These models can understand the context and intent of the user’s query and provide relevant and coherent answers. Azure OpenAI can also help you create prompts, which are the instructions that tell the model what to do with the user’s input.
Azure Cognitive Search is a cloud search service that can index, understand, and retrieve the right information across your enterprise content. It can also enable semantic search, which is a collection of query-related capabilities that bring semantic relevance and language understanding to textual search results. Azure Cognitive Search can help you extract text, tables, structure, and key-value pairs from your documents using Form Recognizer, and enrich your search index with natural language processing capabilities.
How can you use Azure OpenAI and Cognitive Search to create chat bots?
The basic idea is to use Azure OpenAI to interact with the user in natural language and to use Azure Cognitive Search to retrieve the most likely answers from your documents. The solution has the following steps:
Data ingestion: You upload your documents, such as PDFs, into Azure Blob Storage. A function gets triggered on new file upload, which processes the files and performs document chunking, content parsing, and indexing using Azure Cognitive Search.
Data embedding: You generate embeddings for all items in your search index using one of the language models from Azure OpenAI. Embeddings are information-dense representations of the semantic meaning of a piece of text, that can be easily utilized by machine learning models and algorithms. You store the embeddings in your search index.
Query processing: You write a prompt or a question in a chat UI, such as a web app, a chat bot, or a Teams app. The chat UI sends the prompt to Azure OpenAI Completions API, which generates a prompt response to be displayed in the chat UI. The prompt response may also include a query embedding, which is the embedding of the user’s input generated by the same language model.
Answer retrieval: You find the most likely answers by performing a vector similarity search of the query embedding on the search index. This is done by calculating the cosine similarity between the query vector and each of the vectors in the index and selecting the items with the highest similarity values. You may also use semantic ranking, hit highlighting, or summarization techniques to improve the precision and readability of the results.
Answer presentation: You display the answers to the user in the chat UI, along with the source document and the confidence score. You may also provide feedback mechanisms, such as thumbs up or down, to improve the model’s performance over time.
What are the benefits of using Azure OpenAI and Cognitive Search for knowledge management?
By using Azure OpenAI and Cognitive Search for knowledge management, you can achieve the following benefits:
Improve user experience: You can provide your end users with a natural and engaging way to find answers to their questions, without having to browse through multiple documents or use complex search queries.
Increase productivity and efficiency: You can reduce the time and effort required to access the information you need, and focus on the tasks that matter most to your business.
Leverage existing data: You can make use of the data that you already have, without having to create new content or structure it manually.
Scale and customize: You can scale your solution to handle large volumes of data and queries, and customize it to fit your specific use case and domain.
How can you get started with Azure OpenAI and Cognitive Search for knowledge management?
If you are interested in using Azure OpenAI and Cognitive Search for knowledge management, you can request to get started with a pilot of a chatbot inside teams. Before getting started, you will want to consider:
The business problem that you want to solve with knowledge management
The type and number of documents that you want to use for knowledge management
The type of data in those documents. For instance, are you dealing with any regulated data like controlled unclassified information (CUI).
The Azure subscription that you want to use for the pilot deployment
The business and technical decision makers and SMEs that will be involved in the pilot
The pilot should include the following phases:
Initiation and solution definition: Conduct an initial workshop to understand your data and your use case and define the solution scope and architecture.
Implementation and testing: Deploy the components of the solution, build the knowledge base, and test the chat UI.
Deployment and handover: Demo the solution to you, and hand over the source code and the deployment steps.
Example: Chatbot using Azure OpenAI in GCCH
The Defense Industrial Base (DIB) is going through significant changes due to regulatory changes and market incentives. Many are adopting Industry 4.0 by bringing systems online to improve efficiency and operational performance. The DIB want to empower end users to be find the answers they need when they need it. One way to do this is use a chatbot embedded into Microsoft Teams so end users can ask questions in a natural language and receive relevant answers to their questions. Since the DIB uses Microsoft’s GCCH platform, we will share how to build this in GCCH.
Download the latest version of Visual Studio and Install it
Launch Visual Studio
Navigate to the left side where it says extensions
Search for “Teams Toolkit” and install it
Search for “Azure App Service” and install it
Search for “Azure Resources” and install it
Search for “Azure Account” and install it
Go into Azure
Right click and go to “settings”
Find Azure Settings
Find the setting for your current cloud and switch to AzureUSGovernment (if you want to do this in a commercial cloud leave this setting as is)
Log into the extensions with the correct azure and M365 accounts for automated deployment. (Optional)
If not logged in, you cannot use Teams Toolkit for automated deployment, but you can still build your solution and upload/provision it manually with other methods.
Click on Teams Toolkit
Navigate to view samples.
Click on Teams Chef Bot
Follow directions to create chat bot.
Link to Azure OpenAI in Gov. You will need to go through the eligibility process.
Click play
You now have a baseline for a Chatbot operational. From here you can start considering large language models, branding, etc.
To learn more about building a custom copilot teams integration using AzureOpenAI in Azure Government watch our recent Microsoft Build Session: Custom copilot Teams Integration in Government applications.
Conclusion
Knowledge management is a powerful way to unlock the insights hidden in your data and provide them to your end users in a natural and conversational way. By using Azure OpenAI and Cognitive Search, you can create chat bots in Microsoft Teams that can answer complex questions from your documents, and improve your user experience, productivity, efficiency, and scalability. If you need help building out your knowledge management chatbot reach out to your Microsoft Account Team and/or Microsoft Partner to help get started.
Additional Resources
Teams AI library – Teams | Microsoft Learn
Request Access to Azure OpenAI Service for Azure Government Cloud (microsoft.com)
teams-ai/python/samples at main · microsoft/teams-ai · GitHub
Build Microsoft Teams bots with Bot Framework SDK – Bot Service | Microsoft Learn
Enhance productivity with Microsoft Copilot
Deploy Bots to Azure Government and Office 365 GCC High – Bot Service | Microsoft Learn
Accelerate Business Growth With AI
Azure AI Studio – Generative AI Development Hub | Microsoft Azure
Microsoft Collaboration Framework for the US Defense Industrial Base – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More