Category: Microsoft
Category Archives: Microsoft
New Purview Portal Does Not Allow Glossary Import?
In the New Purview Portal, I am not seeing the ability to Import Terms for Glossary. Did they get away from bulk importing of glossary terms? That would be unfortunate. Its a very helpful feature to ensure accuracy on the numerous terms.
In the New Purview Portal, I am not seeing the ability to Import Terms for Glossary. Did they get away from bulk importing of glossary terms? That would be unfortunate. Its a very helpful feature to ensure accuracy on the numerous terms. Read More
TSI Partner Community Update | May 2024
Hello Partners,
Short on time? Open the May Community Update and bookmark the links inside.
We have curated for you: Copilot for M365, Azure, Business Applications resources plus important NIS2 for our EMEA partners and a link to Submittable, a Digital Natives Partner Program participant.
Download the May 2024 TSI Community Update
Hello Partners,
Short on time? Open the May Community Update and bookmark the links inside.
We have curated for you: Copilot for M365, Azure, Business Applications resources plus important NIS2 for our EMEA partners and a link to Submittable, a Digital Natives Partner Program participant.
Download the May 2024 TSI Community Update
Issue with multiple Index data field mapping in Azure AI Studio
I’m working on integrating my own data into a deployed GPT-4 model using an Azure SQL database. The database connection is working perfectly, and I’m able to perform searches in the Azure portal using Azure AI Search without any issues.
However, I’m running into a problem in Azure AI Studio. When setting up the content mapping, I’m able to add a single column without any issues. But each time I try to add multiple columns, I receive the following error message:
An error occurred when calling Azure Cognitive Search: AzureSearch: Wrong content columns provided. Please ensure your content columns are retrievable. Cannot find the following columns in result set: Description, CustomerName.
{ “search”: “*”, “select”: “Description,CustomerName”, “top”: 10 }
I tested this query in the Search explorer, and it successfully returned the expected results, which confirms that the columns are present and retrievable in the index. I’ve also checked that all fields are retrievable and searchable in the index.
What am I missing here? Has anyone else faced this issue or have any ideas on what might be going wrong with the content mapping in Azure AI Studio when specifying multiple columns?
Thanks in advance for your help!
I’m working on integrating my own data into a deployed GPT-4 model using an Azure SQL database. The database connection is working perfectly, and I’m able to perform searches in the Azure portal using Azure AI Search without any issues. However, I’m running into a problem in Azure AI Studio. When setting up the content mapping, I’m able to add a single column without any issues. But each time I try to add multiple columns, I receive the following error message:An error occurred when calling Azure Cognitive Search: AzureSearch: Wrong content columns provided. Please ensure your content columns are retrievable. Cannot find the following columns in result set: Description, CustomerName.{ “search”: “*”, “select”: “Description,CustomerName”, “top”: 10 } I tested this query in the Search explorer, and it successfully returned the expected results, which confirms that the columns are present and retrievable in the index. I’ve also checked that all fields are retrievable and searchable in the index.What am I missing here? Has anyone else faced this issue or have any ideas on what might be going wrong with the content mapping in Azure AI Studio when specifying multiple columns? Thanks in advance for your help! Read More
Weird button behaviour on Excel worksheet – does not do anything the first time pushed
I created a button on the worksheet (activex) and wrote some VBA code which generates a random number and adds a “Q” to the end of it.
What I noticed is that when I press the button the first time, it does nothing and the second time I click the button, the code gets executed. this is consistent with both buttons. Any idea what I have misconfigured?
I created a button on the worksheet (activex) and wrote some VBA code which generates a random number and adds a “Q” to the end of it. What I noticed is that when I press the button the first time, it does nothing and the second time I click the button, the code gets executed. this is consistent with both buttons. Any idea what I have misconfigured? Read More
Copilot for Sales Adoption Tracking & Success KPIs
As my organization rolls out Copilot for Sales starting with a champions cohort first and then team by team across our sales organization, we’re planning what and how to track our success. There are OOTB reports for M365 Copilot adoption and great reports for D365 Sales usage, but we’re not seeing any unique reports for Copilot for Sales. Has anyone developed best practices or repeatable patterns that could be used for this?
In addition to simple DAU and MAU, we’re planning to track more general RevOps metrics like deal velocity, win rate, lead to opportunity conversion rate, and qualification speed.
As my organization rolls out Copilot for Sales starting with a champions cohort first and then team by team across our sales organization, we’re planning what and how to track our success. There are OOTB reports for M365 Copilot adoption and great reports for D365 Sales usage, but we’re not seeing any unique reports for Copilot for Sales. Has anyone developed best practices or repeatable patterns that could be used for this?
In addition to simple DAU and MAU, we’re planning to track more general RevOps metrics like deal velocity, win rate, lead to opportunity conversion rate, and qualification speed. Read More
Create Email Template with easy filling
Hello everyone!
I have a unique situation that I need help with.
Our salon has regular phone calls with clients and after our phone call we open up an .oft template to send them a confirmation of the procedures they accepted to do and declined to do.
Right now a 2×4 table that holds the questions we are required to ask and we manually type “Accepted or Declined” beside each question.
for example:
Hair Extensions | Declined
Hair Colouring | Accepted
Hair Treatment | Declined
Optimally my vision is that we would have some kind of button system on the right column where the technician would press a button such as “Accepted” or “Declined” and then the field would automatically show only the text.
I uploaded a photo of what I mean. If it started off with showing the multiple options and once an option is selected, that field will display the text for the option.
thank you in advance for all the help!
Hello everyone! I have a unique situation that I need help with.Our salon has regular phone calls with clients and after our phone call we open up an .oft template to send them a confirmation of the procedures they accepted to do and declined to do.Right now a 2×4 table that holds the questions we are required to ask and we manually type “Accepted or Declined” beside each question. for example: Hair Extensions | DeclinedHair Colouring | AcceptedHair Treatment | Declined Optimally my vision is that we would have some kind of button system on the right column where the technician would press a button such as “Accepted” or “Declined” and then the field would automatically show only the text.I uploaded a photo of what I mean. If it started off with showing the multiple options and once an option is selected, that field will display the text for the option. thank you in advance for all the help! Read More
Microsoft lists – data input restrictions based on user permissions
Hello,
I need to create a platform using Microsoft Lists to manage tickets.
The tickets will come from multiple countries, and each user group should only be able to view tickets related to their own country (e.g., users in the UK group should only see tickets related to UK). I understand that I can achieve this using user permissions and Power Automate flows, leveraging a column with the country information.
The issue arises with ticket creation. Only staff from the UK should be able to create tickets with the country set to UK. I need to find a way to prevent users in specific groups from using certain values in a column when entering records.
I have searched for a solution but I am still in the dark.
Can you please suggest a solution?
Hello,I need to create a platform using Microsoft Lists to manage tickets.The tickets will come from multiple countries, and each user group should only be able to view tickets related to their own country (e.g., users in the UK group should only see tickets related to UK). I understand that I can achieve this using user permissions and Power Automate flows, leveraging a column with the country information. The issue arises with ticket creation. Only staff from the UK should be able to create tickets with the country set to UK. I need to find a way to prevent users in specific groups from using certain values in a column when entering records. I have searched for a solution but I am still in the dark.Can you please suggest a solution? Read More
Credentials not recognized.
I’m logged into Azure, I’m logged into O365/M365, I can see my Windows 365 VM, and I can open it (Only in windows, not in the browser) but it fails authentication over and over again.
The ONLY thing I can think of is that we’re using MFA for Azure and Office etc. Am I just up a creek?
I’m logged into Azure, I’m logged into O365/M365, I can see my Windows 365 VM, and I can open it (Only in windows, not in the browser) but it fails authentication over and over again.The ONLY thing I can think of is that we’re using MFA for Azure and Office etc. Am I just up a creek? Read More
Lesson Learned #500: Connection Leaks and Query Execution using HikariCP
Other lesson learned about HikariCP has been when we enabled setLeakDetectionThreshold working on a service request was receiving the following error message: 20:21:42.089 [AppExample-ConnectionPooling housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask – Connection leak detection triggered for ConnectionID:1 ClientConnectionId: b9b5344d-f970-XXX-xxxxxxxxxx on thread main, stack trace follows java.lang.Exception: Apparent connection leak detected at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
The learned lesson here was, that, in the context of connection leak detection in HikariCP, it is not only the closing of the connection that matters but also the execution of the query and the handling of associated resources. A connection leak occurs when a connection is acquired from the pool but not returned, which can include not properly closing ResultSet and PreparedStatement objects as well as the connection itself. In this case, I found a query that took more than that this setting.
Considerations for Leak Detection
1. Query Execution:
If a query takes a long time to execute, it can appear as a leak if the execution time exceeds the configured leak detection threshold (leak-detection-threshold).
It is important to optimize queries to ensure they complete in a reasonable time frame.
2. Closing the Connection:
Ensuring the connection is closed after its use is complete, regardless of whether the query was successful or failed.
Microsoft Tech Community – Latest Blogs –Read More
Create a Jenkins pipeline to deploy Desktop Apps as MSIX – Part 2: Packaging a Visual Studio solutio
Parts:
Setup the Jenkins environment: install Jenkins and the required tools.
Packaging a Visual Studio solution: for applications that use Visual Studio IDE, like Windows Forms and WPF.
Packaging a solution developed outside Visual Studio: for applications developed outside VS, i.e., in others IDEs like Eclipse or Visual Studio Code, for Java GUI application.
Packaging using the VB6RegistryTool: despite of the name, the tool can be used by any technology.
1. Visual Studio Solution
In this section it will be demonstrated how to create the Visual Studio solution with a Windows Forms application and the Windows Application Packaging Project project used to generate the MSIX file.
In case you prefer, you can skip this step, since the solution is already available on jenkins_msix repo.
Create the Windows Form application
On Visual Studio 2019, select Create a new project, select the Windows Forms app project template and click Next:
Provide the project name WinForms.App and click Next:
I am choosing the .NET 6.0 framework, but feel free to use any other version. Click on Create:
This is the WinForms project structure. I am using only a PictureBox and a button, but it could be an empty project, as the idea is just to show how to package a WinForm application:
Follows the code-behind:
namespace WinForms.App
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Close();
}
}
}
So far, the WinForm project is a .NET 6.0 application that depends of the .NET runtime available in the client machine. To remove this dependency, it is possible to publish the project as self-contained where the .NET runtime and runtime libraries are bundled together with the application and third-party assemblies.
Add the following lines to the SelfContained and RuntimeIdentifier to the WinForms.App project file:
<PropertyGroup>
<OutputType>WinExe</OutputType>
<TargetFramework>net6.0-windows</TargetFramework>
<Nullable>enable</Nullable>
<UseWindowsForms>true</UseWindowsForms>
<ImplicitUsings>enable</ImplicitUsings>
<SelfContained>true</SelfContained>
<RuntimeIdentifier>win-x64</RuntimeIdentifier>
</PropertyGroup>
More details at: Trim self-contained deployments and executables
Build the application to ensure that no errors appear.
Create the the Windows Application Packaging project
The next step is adding the Windows Application Packaging Project to the solution.
Right-click on the solution, select Add and click on New Project…:
Select the Windows Application Packaging Project and click Next:
Provide the project name WinForms.Packaging and click Create:
The next step is to provide the target and minimum platform version supported by your application. I am selecting both versions to 19041 to keep it simple, as I need to install the same SDKs on my Jenkins server environment:
In the WinForms.Packaging project, right-click on Dependencies node and click Add Project Reference…:
Select the Windows Application Packaging Project and click Next:
Observe that the WinForms.App project was added to the WinForms.Packaging project:
The Windows Application Packaging Project don’t accept the target Any CPU. Therefore, we need to change the processor target to x86 or x64 for both projects.
Open Configuration Manager, change the Active solution platform to x86, change the WinForms.App and WinForms.Packaging projects to x86:
Build the application to ensure that no errors appear.
Build the application using MSBuild command line
Before creating a Jenkins pipeline, let’s make sure that the MSBuild command line that will be used to build our application is working.
Open the Package Manager Console (you can press CTRL+Q and type package manager console):
Before running the following command, make sure to provide the MSBuild.exe PATH available in your environment:
&”C:Program FilesMicrosoft Visual Studio2022EnterpriseMSBuildCurrentBinMSBuild.exe” /p:AppxBundlePlatforms=X86 /p:AppxBundle=Never /p:UapAppxPackageBuildMode=Sideloading /p:AppxPackageSigningEnabled=false
In my case, the msix package file was generated on:
C:githubmsixdemos1_VisualStudioWinForms.AppWinForms.PackagingAppPackagesWinForms.Packaging_1.0.0.0_AnyCPU_Debug_Test
In the next section, it will demonstrate how to build a Jenkins Pipeline for this project.
2. Jenkins Pipeline
Pipeline is a series of tasks required to build, test, and deploy an application.
Create a new job
In the Jenkins Dashboard, click on the Create a job option:
Provide a name for the job, check the Pipeline type of job and click on OK to proceed.
In the pipeline configuration page, check the GitHub Project to specify that this is a GitHub project and provide a GitHub URL:
Scroll down under the Pipeline section and change the definition to Pipeline script from SCM
Provide the Repository URL as well. Because this is a public project, we can skip the credentials:
Scroll-down to the Branches to build section, change the branch name to */main, the Jenkins script path to Jenkinsfile01 and click on Save:
Those actions were needed as we want to use the Jenkins pipeline file available in the main branch of the following repo:
Jenkins Pipeline File
In the previous section it was demonstrated how to setup the Jenkins pipeline to use a Jenkins script file available on our GitHub repository.
Follows the Jenkinsfile01 content:
pipeline {
agent any
environment {
MSBUILD = “C:\Program Files\Microsoft Visual Studio\2022\Community\Msbuild\Current\Bin\MSBuild.exe”
CONFIG = ‘Release’
PLATFORM = ‘x86’
}
stages {
stage(‘Update manifest version’) {
steps {
powershell ”’
$manifest = “01_VisualStudio\WinForms.App\WinForms.Packaging\Package.appxmanifest”
[xml]$xmlDoc = Get-Content $manifest
$version = $xmlDoc.Package.Identity.Version
$trimmedVersion = $version -replace ‘.[0-9]+$’, ‘.’
$xmlDoc.Package.Identity.Version = $trimmedVersion + ${env:BUILD_NUMBER}
$xmlDoc.Save($manifest)
”’
}
}
stage(‘Build’) {
steps {
bat “dotnet restore 01_VisualStudio\WinForms.App\WinForms.App\WinForms.App.csproj”
bat “”${MSBUILD}” 01_VisualStudio\WinForms.App\WinForms.app.sln /p:Configuration=${env.CONFIG} /p:AppxBundlePlatforms=${env.PLATFORM} /p:AppxBundle=Never /p:UapAppxPackageBuildMode=Sideloading /p:AppxPackageSigningEnabled=false”
}
post{
always {
archiveArtifacts artifacts: ‘**/*.msix’, followSymlinks: false
}
}
}
}
}
The pipeline directive is the complete script from beginning to end.
The agent directive instructs Jenkins to allocate an executor and workspace for the entire Pipeline. In our case, we are justing saying it can run on any agent. For example, it could be specified that it could run in a Docker container or run on a specific node.
The environment directive specifies a sequence of key-value pairs which will be defined as environment variables for all steps, or stage-specific steps, depending on where the environment directive is located within the Pipeline.
In our case, it is defined the variables MSBUILD that contains the MSBUILD path, the CONFIG with the value Release and PLATFORM with the value x86. Those variables will be used in the command line used to build our application.
The stages block contains on or more stage block, and each stage is going to have one or more steps. In our case, we have only one stage named Build, that has two steps to restore the dotnet WinForms.App project and to build the solution.
The post section defines the additional step needed to keep the msix file artifact available in our build, as workspace is a temporary directory.
You can find more details about the Jenkins pipeline syntax in the post Getting started with Pipeline.
In addition, there is a great post about how to Creating a Jenkins pipeline for a .NET Core application.
Switch back to Jenkins, click on Dashboard and click on the Visual Studio Solution pipeline:
Click on Build Now to start the build:
The job starts by checking out the source code to next restore and build our solution as defined in the Jenkinsfile01.
After the build is done, the build icon will be green and the msix artifact will be available:
The next post demonstrate how to package an application that not uses the Visual Studio IDE, but that uses the Windows Application Packaging Project to generate the MSIX file.
Microsoft Tech Community – Latest Blogs –Read More
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
