Category: Microsoft
Category Archives: Microsoft
The same document looks different in SharePoint than the desktop App (word)
In SharePoint online word view number bullets start like 1.0,1.1,1.2,…. But in desktop view, it’s like 1.1,1.2,1.3,….
I have tried the below troubleshooting steps.
1. Modified the site’s permission hierarchy to specific user. When the bullets that begin with 1.0, 1.1, 1.2, and so on are granted access to the site by the owner, member, and site administrator. The document is correct in both the desktop and SharePoint views when I remove all site permissions and grant read access.
2. Used a new browser(We are normally use Microsoft Edge browser) to visit this same SharePoint location. An identical problem was encountered.
3. Attempted to use the identical file on a different SharePoint site. However, the problem persisted.
Can someone please help me to fix this issue?
In SharePoint online word view number bullets start like 1.0,1.1,1.2,…. But in desktop view, it’s like 1.1,1.2,1.3,…. I have tried the below troubleshooting steps. 1. Modified the site’s permission hierarchy to specific user. When the bullets that begin with 1.0, 1.1, 1.2, and so on are granted access to the site by the owner, member, and site administrator. The document is correct in both the desktop and SharePoint views when I remove all site permissions and grant read access.2. Used a new browser(We are normally use Microsoft Edge browser) to visit this same SharePoint location. An identical problem was encountered.3. Attempted to use the identical file on a different SharePoint site. However, the problem persisted. Can someone please help me to fix this issue? Read More
Steps to Security hardening in Windows server
Hello everyone,
I am experience on the Active Directory and others, but I am quite new on server hardening. I am not sure where should I start with, what kind of actions I need to take, what thing I should prepare to let the server done with hardening.
My company is running Windows 2019 servers in major. We have also GPO running in our AD like password expiry, complexity, map network drive, printer, etc. We are going to deploy some new servers as Windows 2022. What I am thinking is I want to harden the server, but just not sure what kind of procedure I can get ready
Regards,
Timothy
Hello everyone,I am experience on the Active Directory and others, but I am quite new on server hardening. I am not sure where should I start with, what kind of actions I need to take, what thing I should prepare to let the server done with hardening.My company is running Windows 2019 servers in major. We have also GPO running in our AD like password expiry, complexity, map network drive, printer, etc. We are going to deploy some new servers as Windows 2022. What I am thinking is I want to harden the server, but just not sure what kind of procedure I can get ready Regards, Timothy Read More
Using SSIS Expression to build query to run on Oracle source
I am trying to build a query to run on oracle source by putting it in a variable, I am pulling max of date into a variable varChildpkgMaxDt(e.g. 2024-08-10 17:21:04.670 ) from SQL server target table.
I need to build a query to run on oracle source. I have used datetime as datatype for varChildpkgMaxDt to fetch from sqlserver in parent pkg and passing this as a parameter to child pkg.
I created a varCpkgQuery variable as string and I am getting syntax err when I build this.
I also want to ensure that the varChildpkgMaxDt is properly compared in oracle with NVL(REVIEWDATE,CREATED) as this two fields in oracle are date with time stamp up till 3mill sec (2024-08-10 17:21:04.670)
“SELECT *
FROM dbo.virDocument
WHERE NVL(REVIEWDATE,CREATED) > “+ (DT_DBTIMESTAMP2,3)@[User::varChildPkgMaxDt]
Using oracle 19 C source, VS 2017 SSDT & SQL Server 2016
I am trying to build a query to run on oracle source by putting it in a variable, I am pulling max of date into a variable varChildpkgMaxDt(e.g. 2024-08-10 17:21:04.670 ) from SQL server target table. I need to build a query to run on oracle source. I have used datetime as datatype for varChildpkgMaxDt to fetch from sqlserver in parent pkg and passing this as a parameter to child pkg. I created a varCpkgQuery variable as string and I am getting syntax err when I build this. I also want to ensure that the varChildpkgMaxDt is properly compared in oracle with NVL(REVIEWDATE,CREATED) as this two fields in oracle are date with time stamp up till 3mill sec (2024-08-10 17:21:04.670) “SELECT *
FROM dbo.virDocument
WHERE NVL(REVIEWDATE,CREATED) > “+ (DT_DBTIMESTAMP2,3)@[User::varChildPkgMaxDt] Using oracle 19 C source, VS 2017 SSDT & SQL Server 2016 Read More
Renew Azure Data Engineer Associate certification
Hi there experts,
I received a renewal email the other day for “Azure Data Engineer Associate” stating:
“Your Microsoft Certified: Azure Data Engineer Associate certification is now eligible for renewal. You have until November 2, 2024 (UTC) to pass the renewal assessment.”
However when I follow the link in the email and log in to my Learn profile the “Take the renewal assessment” link is inactive.
and when I check the Certifications area under my profile there are none listed.
Can someone help?
Cheers
Hi there experts, I received a renewal email the other day for “Azure Data Engineer Associate” stating: “Your Microsoft Certified: Azure Data Engineer Associate certification is now eligible for renewal. You have until November 2, 2024 (UTC) to pass the renewal assessment.” However when I follow the link in the email and log in to my Learn profile the “Take the renewal assessment” link is inactive. and when I check the Certifications area under my profile there are none listed. Can someone help? Cheers Read More
Web development
Hi I am interested in learning how to make websites. What should I do in college?
Hi I am interested in learning how to make websites. What should I do in college? Read More
Step by Step: Integrate Advanced RAG Service with Your Own Data into Copilot Studio
This post is going to explain how to use Advanced RAG Service easily verify proper RAG tech performance for your own data, and integrate it as a service endpoint into Copilot Studio.
This time we use CSV as a sample. CSV is text structure data, when we use basic RAG to process a multiple pages CSV file as Vector Index and perform similarity search using Nature Language on it, the grounded data is always chunked and hardly make LLM to understand the whole data picture.
For example, if we have 10,000 rows in a CSV file, when we ask “how many rows does the data contain and what’s the mean value of the visits column”, usually general semantic search service cannot give exact right answers if it just handles the data as unstructured. We need to use different advanced RAG method to handle the CSV data here.
Thanks to LLamaIndex Pandas Query Engine, which provides a good idea of understanding data frame data through natural language way. However to verify its performance among others and integrate to existing Enterprise environment, such as Copilot Studio or other user facing services, it definitely needs AI service developing experience and takes certain learning curve and time efforts from POC to Production.
Advanced RAG Service supports 6 latest advanced indexing techs including CSV Query Eninge, with it developers can leverage it to shorten development POC stage, and achieve Production purpose. Here is detail step to step guideline:
text-embedding-3-small
a. In Docker environment, run this command to clone the dockerfile and related config sample:
b. In the AdvancedRAG folder, rename .env.sample to .env
mv .env.sample .env
c. In the .env file, configure necessary environment variables. In this tutorial, let’s configure:
AZURE_OPENAI_API_KEY=
AZURE_OPENAI_Deployment=gpt-4o-mini
AZURE_OPENAI_EMBEDDING_Deployment=text-embedding-3-small
AZURE_OPENAI_ENDPOINT=https://[name].openai.azure.com/
# Azure Document Intellenigence
DOC_AI_BASE=https://[name].cognitiveservices.azure.com/
DOC_AI_KEY=
NOTE:
d. Build your own docker image:
e. Run this docker:
f. Access http://localhost:8000/
a. Click the CSV Query Engine tab, upload a test CSV file, click Submit
b. Click the Chat Mode tab, now we can use Natural Language to test how good the CSV Query Engine at understanding CSV content:
The Advanced RAG Service is built with Gradio and FAST API. It opens necessary API Endpoints by default. We can turn off any of them in the .env settings.
The Chat endpoint can be used for different index types query/search. Since we are using “CSV Query Engine”, now it is:
content-type: application/json
{
“data”: [
“how many records does it have”,
“”,
“CSV Query Engine”,
“/tmp/gradio/86262b8036b56db1a2ed40087bbc772f619d0df4/titanic_train.csv”,
“You are a friendly AI Assistant” ,
false
]
}
The response is:
“data”: [
“The dataset contains a total of 891 records. If you have any more questions about the data, feel free to ask!”,
null
],
“is_generating”: true,
“duration”: 3.148253917694092,
“average_duration”: 3.148253917694092,
“render_config”: null,
“changed_state_ids”: []
}
Using this method, we can easily integrate the specific RAG capability to our own service, such as Copilot Studio. Before that, let’s publish the service first.
We have different methods to release docker as an app service. Here are the generate steps when we use Azure Contain Registry and Azure Container App.
a. Create Azure Container Registry resource [ACRNAME], upload your tested docker image to it. The command is:
az account set -s [your subscription]
az acr login -n [ACRNAME]
docker push [ACRNAME].azurecr.io/dockerimage:tag
b. Create an Azure Container App, deploy this docker image, and deploy it. Don’t forget enable Session Affinity for the Container App.
To automate the Azure Container App deployment, I provided deploy_acr_app.sh in the repo.
set -e
if [ $# -eq 0 ]
then
echo “No SUF_FIX supplied, it should be an integer or a short string”
docker image list
exit 1
fi
SUF_FIX=$1
RESOURCE_GROUP=”rg-demo-${SUF_FIX}”
LOCATION=”eastus”
ENVIRONMENT=”env-demo-containerapps”
API_NAME=”advrag-demo-${SUF_FIX}”
FRONTEND_NAME=”advrag-ui-${SUF_FIX}”
TARGET_PORT=8000
ACR_NAME=”advragdemo${SUF_FIX}”
az group create –name $RESOURCE_GROUP –location “$LOCATION”
az acr create –resource-group $RESOURCE_GROUP –name $ACR_NAME –sku Basic –admin-enabled true
az acr build –registry $ACR_NAME –image $API_NAME .
az containerapp env create –name $ENVIRONMENT –resource-group $RESOURCE_GROUP –location “$LOCATION”
az containerapp create –name $API_NAME –resource-group $RESOURCE_GROUP –environment $ENVIRONMENT –image $ACR_NAME.azurecr.io/$API_NAME –target-port $TARGET_PORT –ingress external –registry-server $ACR_NAME.azurecr.io –query properties.configuration.ingress.fqdn
az containerapp ingress sticky-sessions set -n $API_NAME -g $RESOURCE_GROUP –affinity sticky
To use it:
./deploy_acr_azure.sh [suffix number]
Note: for more details about this sh, can refer to this guideline.
After around 7~8 minutes, the Azure Container App will be ready. You can check the output and access it directly:
To protect your container app, can follow this guide to enable authentication on it.
Enable authentication and authorization in Azure Container Apps with Microsoft Entra ID
By default, we need to upload a CSV to the AdvRAG service before analysis. The service always saves the uploaded file to its local temp folder on server side. And then we can use temp file path to start the analysis query.
To skip this step, we can save common files in subfolder rules of the AdvancedRAG folder, and then build your docker image. The files will be copy to the docker itself. As a demo, I can put a CSV file in AdvancedRAG/rules/files, and then pubish the docker to Azure.
a. Open Copilot Studio, create a new Topic, use “CSV Query” to trigger it.
b. For demo purpose, I upload a test CSV file and got its path, then put it into a variable:
c. Now let’s add a Question step to ask what question the user want to ask:
d. Click “+”, “Add an Action”, “Create a flow”. We will use this new flow to call AdvancedRAG service endpoint.
e. We need Query, File_Path, System_Message as input variables.
e. In the flow Editor, let’s add an HTTP step. In the step, post the request to the AdvancedRAG endpoint as below:
Save the flow as ADVRAGSVC_CSV, and publish it.
f. Back to Copilot Studio topic, we will add the action as below, and set input variables as need:
g. Publish and open this Custom Copilot in Teams Channel based on this guide.
h. Now we can test this topic lit this, as we see, even I used gpt-4o-mini here, the response accuracy is very good:
From above, it shows how to quickly verify potential useful RAG techs (Pandas Query Engine) in the AdvancedRAG service studio, expose and publish it as REST API endpoint which can be used by other service, such as Copilot Studio.
The AdvancedRAG service focuses on key logic and stability of different important index types, the efficiency to be landed into M365 AI use cases. For any feature improvement ideas, feel free to visit below repos to create issues, fork projects and create PRs.
Docker Deploy Repo: https://github.com/freistli/AdvancedRAG
Source Code Repo: https://github.com/freistli/AdvancedRAG_SVC
Exploring the Advanced RAG (Retrieval Augmented Generation) Service
Microsoft Tech Community – Latest Blogs –Read More
Sharing a Teams URL
Hi all,
I am hoping you can help.
We are using a Tap IP and Huddle Bar for online meetings. Normally we would receive a meeting invite from an external party and then forward it to the meeting room, and then launch the meeting from there.
Recently we are receiving meeting requests from third parties who are sending a just a copy-paste of the Teams link URL only (i.e., it is not a typical teams meeting invite email with the teams logo etc…).
We have not been able to successfully forward the URL to the Tap IP/Huddle Bar to launch the meeting. Is this a limitation of this setup or is there a specific way these invites should be handled?
Hi all, I am hoping you can help. We are using a Tap IP and Huddle Bar for online meetings. Normally we would receive a meeting invite from an external party and then forward it to the meeting room, and then launch the meeting from there. Recently we are receiving meeting requests from third parties who are sending a just a copy-paste of the Teams link URL only (i.e., it is not a typical teams meeting invite email with the teams logo etc…). We have not been able to successfully forward the URL to the Tap IP/Huddle Bar to launch the meeting. Is this a limitation of this setup or is there a specific way these invites should be handled? Read More
Super user AIP
Hi All,
I have question relate to AIP user.
Few of our users have assigned MIPP protection on excel files and send it over to internal users via an email (not saved on sharepoint nor file share). Users are no more working for the organisation. I would like to know if i would save the file to local PC and open the file as super user (as per the below article) to view the content or reassign protection settings?
https://learn.microsoft.com/en-us/azure/information-protection/configure-super-users
Hi All, I have question relate to AIP user. Few of our users have assigned MIPP protection on excel files and send it over to internal users via an email (not saved on sharepoint nor file share). Users are no more working for the organisation. I would like to know if i would save the file to local PC and open the file as super user (as per the below article) to view the content or reassign protection settings? https://learn.microsoft.com/en-us/azure/information-protection/configure-super-users Read More
Remote Desktop on Win11 Pro toggle unable to turn on
Hello all,
I noticed that the feature of “Remote Desktop” in Settings on Windows 11 Pro edition (version 23H2), is not staying in the “ON” position after trying to toggle it. It displays a message I can confirm it and it switches back to the “OFF” position.
Troubleshooting steps done:
Reset the NIC (which is not the issue)
Taken the workstation off the domain to confirm if it was a domain restriction but will not turn on even as a local admin account (which is not the issue)
I have disabled third-party AV (which is not the issue)
I have disabled the Windows firewall (which is not the issue)
I have allowed the port 3389 (which is not the issue)
And last, there is no GPO policy
It was working before and three days ago unable to RDP to my workstation.
Anybody has run into this issue before and fixed it?
Thanks
Hello all,I noticed that the feature of “Remote Desktop” in Settings on Windows 11 Pro edition (version 23H2), is not staying in the “ON” position after trying to toggle it. It displays a message I can confirm it and it switches back to the “OFF” position.Troubleshooting steps done:Reset the NIC (which is not the issue)Taken the workstation off the domain to confirm if it was a domain restriction but will not turn on even as a local admin account (which is not the issue)I have disabled third-party AV (which is not the issue)I have disabled the Windows firewall (which is not the issue)I have allowed the port 3389 (which is not the issue)And last, there is no GPO policyIt was working before and three days ago unable to RDP to my workstation.Anybody has run into this issue before and fixed it?Thanks Read More
VLOOKUP Issue
Hi,
My apologies as this is a very basic VLOOKUP question but I can’t figure it out. I have data where every person has a research partner. I’m trying to create a Partner_ID variable that contains the ID of the person the participant is partnered with. I’m pretty sure VLOOKUP is the best way to do this but it isn’t working for me. I have put an example with fake data in the screenshot below. Essentially, I want VLOOKUP to search for the name “Cox” in the Table and find the name under the LastName column, then print the ID that is next to it (in this case, cell D2 should print a 3, indicating that Perry’s Partner is ID#3). As you can see, however, Excel is returning error messages that it can’t find the expected value. I’ve looked at various tutorials and I can’t figure out what I’m doing wrong. Thank you!
The formula I’m using is =VLOOKUP(C2,$A$2:$B$7,1,FALSE)
Hi, My apologies as this is a very basic VLOOKUP question but I can’t figure it out. I have data where every person has a research partner. I’m trying to create a Partner_ID variable that contains the ID of the person the participant is partnered with. I’m pretty sure VLOOKUP is the best way to do this but it isn’t working for me. I have put an example with fake data in the screenshot below. Essentially, I want VLOOKUP to search for the name “Cox” in the Table and find the name under the LastName column, then print the ID that is next to it (in this case, cell D2 should print a 3, indicating that Perry’s Partner is ID#3). As you can see, however, Excel is returning error messages that it can’t find the expected value. I’ve looked at various tutorials and I can’t figure out what I’m doing wrong. Thank you! The formula I’m using is =VLOOKUP(C2,$A$2:$B$7,1,FALSE) Read More
Why do I have to have AI?
I want the latest speed and memory of the latest surface pro, but I don’t want anything to do with AI. can I purchase a surface pro without AI?
I want the latest speed and memory of the latest surface pro, but I don’t want anything to do with AI. can I purchase a surface pro without AI? Read More
Cannot add a gmail account as a POP account to Outlook Pro Plus 2021
I am trying to get my 6 email accounts into one inbox by having them all be POP accounts. One of my oldest gmail accounts will not recognize my gmail password. I’ve gone into my Gmail and enabled POP, saved it to no avail. It will only add the account as an IMAP account which separates the inbox and defeats my purpose. TIA for your assistance!
I am trying to get my 6 email accounts into one inbox by having them all be POP accounts. One of my oldest gmail accounts will not recognize my gmail password. I’ve gone into my Gmail and enabled POP, saved it to no avail. It will only add the account as an IMAP account which separates the inbox and defeats my purpose. TIA for your assistance! Read More
Sharing with unlicensed members of my team
I’m a new MS Project user. I’m attempting to share a roadmap with other members of my team, who do not have access to MS Projects. How do I do this?
I’m a new MS Project user. I’m attempting to share a roadmap with other members of my team, who do not have access to MS Projects. How do I do this? Read More
we couldnot save your tab settings.
Hi All
i am using M365 E5 license. I am unable to add the “Planner” app as a new tab in a channel. i am the owner of the teams. i am getting error we couldn’t save your tab settings. please try again.
Hi Alli am using M365 E5 license. I am unable to add the “Planner” app as a new tab in a channel. i am the owner of the teams. i am getting error we couldn’t save your tab settings. please try again. Read More
I lost all my documents and images stored on my one drive account
Hello,
I lost all my documents and images stored on my one drive account at email address removed for privacy reasons.
It is a school alumni account.
I would hereby appreciate your help in retrieving this as quickly as possible, as many of these documents have professional use and personal value. You can contact me by email.
Kind regards,
Hong Ducruet
Hello, I lost all my documents and images stored on my one drive account at email address removed for privacy reasons. It is a school alumni account. I would hereby appreciate your help in retrieving this as quickly as possible, as many of these documents have professional use and personal value. You can contact me by email. Kind regards, Hong Ducruet Read More
Chapter page formatting for novel
I’m formatting a manuscript (my novel) in Word V 16.8 and need to have each new chapter start in the middle of the page without using the enter key or returns. I’m ignorant about most of Word. I only enough to start typing. Can you help?
I’m formatting a manuscript (my novel) in Word V 16.8 and need to have each new chapter start in the middle of the page without using the enter key or returns. I’m ignorant about most of Word. I only enough to start typing. Can you help? Read More
tally scores over several sheets
I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes.
I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor… Is there a way to sort that out?
I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes. I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor… Is there a way to sort that out? Read More
Dissertation Footnotes
I need the numerical footnote reference to be a size 12 font in the body of the text and a size 10 font in the footnote at the bottom of the page. Right now, I insert the footnote at the end of the sentence and have to change each individual one to size 12. I am about to combine all of my individual chapters with over 1,000 footnotes. When I cut and paste it, I am concerned that I will need to go back and individually change every one of the numbers in the body back to size 12.
Since I will continue to produce scholarly work, I would like to know how to do set this up where these will display correctly. I am working in CMS/Turabian for the formatting of the dissertation.
I need the numerical footnote reference to be a size 12 font in the body of the text and a size 10 font in the footnote at the bottom of the page. Right now, I insert the footnote at the end of the sentence and have to change each individual one to size 12. I am about to combine all of my individual chapters with over 1,000 footnotes. When I cut and paste it, I am concerned that I will need to go back and individually change every one of the numbers in the body back to size 12. Since I will continue to produce scholarly work, I would like to know how to do set this up where these will display correctly. I am working in CMS/Turabian for the formatting of the dissertation. Read More