Tag Archives: microsoft
How will i add another value (e.g. TLOG_MMF_COR_0003) in the below
Hi,
How will i add another value (e.g. TLOG_MMF_COR_0003) in the below ‘Type:=xlCaptionDoesNotBeginWith’ where existing
value1 ‘ATLOG_MMF_0003’ is there already:
=======================================================
ActiveSheet.PivotTables(“PivotTable9”).PivotFields(“USSMG_File-list”). _
PivotFilters.Add2 Type:=xlCaptionDoesNotBeginWith, Value1:=”ATLOG_MMF_0003“
Hi, How will i add another value (e.g. TLOG_MMF_COR_0003) in the below ‘Type:=xlCaptionDoesNotBeginWith’ where existingvalue1 ‘ATLOG_MMF_0003’ is there already:=======================================================ActiveSheet.PivotTables(“PivotTable9”).PivotFields(“USSMG_File-list”). _PivotFilters.Add2 Type:=xlCaptionDoesNotBeginWith, Value1:=”ATLOG_MMF_0003″ Read More
Removing an attachment strips non-Microsoft X-* headers from a message
I’ve run into an odd behavior that doesn’t seem to be documented. When I delete an attachment from an email message via Remove-MgUserMessageAttachment, Graph appears to strip all non-Microsoft X-* Internet message headers from the message.
For example, an existing X-Spam header will disappear, but X-MS-Exchange* headers will remain.
Is this behavior documented anywhere either as a bug or a feature? Is it just me?
I’ve run into an odd behavior that doesn’t seem to be documented. When I delete an attachment from an email message via Remove-MgUserMessageAttachment, Graph appears to strip all non-Microsoft X-* Internet message headers from the message. For example, an existing X-Spam header will disappear, but X-MS-Exchange* headers will remain. Is this behavior documented anywhere either as a bug or a feature? Is it just me? Read More
This site is read only at the farm administrator’s request.
Share Point will not allow me to upload my reports
Share Point will not allow me to upload my reports Read More
If statement in SharePoint
Good Evening
I am trying to enter what I feel is a rather simple “IF” statement but I can’t figure it out.
I have a Field titled “Item Type” and one titled “FLW – Business Days Remaining” and want to return a “2” if the Item Type equal “Prospect” and “FLW – Business Days Remaining” is grater than 2.
This is what I have
=IF(AND([Item Type]=”Prospect”,[FLW – Business Days Remaining] >2,”2″)))
Any help would be greatly appreciated
Good EveningI am trying to enter what I feel is a rather simple “IF” statement but I can’t figure it out. I have a Field titled “Item Type” and one titled “FLW – Business Days Remaining” and want to return a “2” if the Item Type equal “Prospect” and “FLW – Business Days Remaining” is grater than 2. This is what I have=IF(AND([Item Type]=”Prospect”,[FLW – Business Days Remaining] >2,”2″))) Any help would be greatly appreciated Read More
Copilot Studio – Questions about Knowledge
Hello!
We’re testing copilot studio and we’re having questions about the knowledge we’re uploading.
We’re using it for employees to ask internal questions.
Is there anyone who is using it and performing well?
Do you have any recommendations on what the file should look like?
Pdf, Word, Excel, with or without topics
I would appreciate it if you could support us
Thank you for your attention
Hello!We’re testing copilot studio and we’re having questions about the knowledge we’re uploading.We’re using it for employees to ask internal questions.Is there anyone who is using it and performing well?Do you have any recommendations on what the file should look like?Pdf, Word, Excel, with or without topicsI would appreciate it if you could support usThank you for your attention Read More
Bell Notifications doesn’t work. Again.
and above link forwards on
But I definitely shall have them.
and above link forwards on
But I definitely shall have them. Read More
Leveraging phi-3 for an Enhanced Semantic Cache in RAG Applications
The field of Generative AI (GenAI) is rapidly evolving, with Large Language Models (LLMs) playing a central role. Building responsive and efficient applications using these models is crucial. Retrieval-Augmented Generation (RAG) applications, which combine retrieval and generation techniques, have emerged as a powerful solution for generating high-quality responses. However, a key challenge arises in handling repeat queries efficiently while maintaining contextually accurate and diverse responses. This blog post explores a solution that addresses this challenge. We propose a multi-layered approach that utilizes a semantic cache layer and phi-3, a Small Language Model (SLM) from Microsoft, to rewrite responses. This approach enhances both performance and user experience.
Demystifying RAG: Retrieval Meets Generation
Retrieval-Augmented Generation (RAG) is a cutting-edge framework that extends the capabilities of natural language generation models by incorporating information retrieval.
Here’s how it works:
User Query: This is the initial input from the user.
App service: Central component that orchestrates the entire RAG workflow, managing user queries, interacting with the cache and search service, and delivering final responses.
Vectorize Query: Leverage OpenAI Embedding models to vectorize the user query into numerical representations. These vectors, similar to fingerprints, allow for efficient comparison and retrieval of relevant information from the vector store and semantic cache.
Semantic Cache Store: This component acts as a storage unit for responses to previously encountered queries, and to check if the current user query aligns with any queries stored in the semantic cache. If a response is found in the cache (cache-hit), the response is fetched and sent to the user.
Vector Store: If no matching query is found in the cache (cache-miss), leverage Azure AI Search service to scour the vast corpus of text to identify relevant documents or snippets based on the user’s query.
Azure OpenAI LLM (GPT 3.5/4/4o): The retrieved documents from AI Search are fed to these LLMs to craft a response, in-context to the user’s query.
Logs: These are used to monitor and analyze system performance.
What is Semantic Cache?
Semantic caching plays a pivotal role in enhancing the efficiency and responsiveness of Retrieval-Augmented Generation (RAG) applications. This section delves into its significance and functionality within the broader architecture:
Understanding Semantic Cache
Storage and Retrieval: The semantic cache acts as a specialized storage unit that stores responses to previously encountered queries. It indexes these responses based on the semantic content of the queries, allowing for efficient retrieval when similar queries are encountered in the future.
Query Matching: When a user query is received, it undergoes vectorization using embedding models to create a numerical representation. This representation is compared against stored queries in the semantic cache. If a match is found (cache-hit), the corresponding response is fetched without the need for additional computation.
Benefits of Semantic Cache:
Speed: Responses retrieved from the semantic cache are delivered almost instantaneously, significantly reducing latency compared to generating responses from scratch.
Resource Efficiency: By reusing pre-computed responses, semantic caching optimizes resource utilization, allowing computational resources to be allocated more effectively.
Consistency: Cached responses ensure consistency in answers to frequently asked questions or similar queries, maintaining a coherent user experience.
Scalability: As the volume of queries increases, semantic caching scales efficiently by storing and retrieving responses based on semantic similarities rather than raw text matching.
Implementing Semantic Cache in RAG
Integration with RAG Workflow: The semantic cache is seamlessly integrated into the RAG workflow, typically managed by the application service. Upon receiving a user query, the application service first checks the semantic cache for a matching response.
Update and Refresh: Regular updates and maintenance of the semantic cache are essential to ensure that responses remain relevant and up to date. This may involve periodic pruning of outdated entries and adding new responses based on recent user interactions.
Performance Monitoring: Monitoring tools track the performance of the semantic cache, providing insights into cache-hit rates, response retrieval times, and overall system efficiency. These metrics guide optimization efforts and ensure continuous improvement.
Challenges in RAG with Semantic Caching
While RAG models are undeniably powerful, they encounter some hurdles:
Repetitive Queries: When users pose similar or identical queries repeatedly, it can lead to redundant processing, resulting in slower response times.
Response Consistency: Ensuring responses maintain contextual accuracy and relevance, especially for similar queries, is crucial.
Computational Burden: Generating responses from scratch for every query can be computationally expensive, impacting resource utilization.
Improving the Semantic Cache with phi-3
To address these challenges, we propose a multi-layered approach built on top of RAG architecture with semantic caching that leverages phi-3, a Small Language Model (SLM) from Microsoft, to dynamically rewrite cached responses retrieved from the semantic cache for similar repeat queries. This ensures responses remain contextually relevant and varied, even when served from the cache.
Major change in the architeture above is addition of phi-3, When a matching query is found in the cache, the retrieved cached response is routed through phi-3. This SLM analyzes the cached response and the current user query, dynamically rewriting the cached response to better suit the nuances of the new query.
By integrating phi-3 into the semantic cache layer, we can achieve the following:
Dynamic Rewriting: When a query matching a cached response is received, phi-3 steps in. It analyses the cached response and the user’s current query, identifying nuances and differences. Subsequently, phi-3 rewrites the cached response to seamlessly incorporate the specific context of the new query while preserving the core meaning. This ensures that even cached responses feel fresh, relevant, and up to date.
Reduced Computational Load: By leveraging phi-3 for rewriting cached responses, we significantly reduce the burden on the larger, computationally expensive LLMs (like GPT-3). This frees up resources for the LLM to handle complex or novel queries that require its full generative power.
Improved Response Diversity: Even for repetitive queries, phi-3 injects variation into the responses through rewriting. This prevents users from encountering identical responses repeatedly, enhancing the overall user experience.
Implementation Considerations
Integrating phi-3 into your RAG application requires careful planning and execution:
Semantic Cache Management: Efficient management of the semantic cache is crucial to ensure quick access to relevant cached responses. Regular updates and pruning of the cache can help maintain its effectiveness.
Fine-Tuning phi-3: Fine-tuning phi-3 to handle specific rewriting tasks can further enhance its performance and ensure it aligns well with the context of your application.
Monitoring and Analytics: Continuous monitoring and analytics can help identify patterns in user queries and optimize the caching strategy. Logs play a crucial role in this aspect, providing insights into the system’s performance and areas for improvement.
Conclusion
The integration of phi-3 into the semantic cache layer of a RAG application represents a significant advancement in handling repeat queries efficiently while maintaining contextually accurate and diverse responses. By leveraging the dynamic rewriting capabilities of phi-3, we can enhance both the performance and user experience of RAG applications.
This multi-layered approach not only addresses the challenges of repetitive queries and computational burden but also ensures that responses remain fresh and relevant, even when served from the cache. As Generative AI continues to evolve, such innovations will play a crucial role in building responsive and efficient applications that can meet the diverse needs of users.
Incorporating these strategies into your RAG application can help you stay ahead in the rapidly evolving field of Generative AI, delivering high-quality and contextually accurate responses that enhance user satisfaction and engagement.
Microsoft Tech Community – Latest Blogs –Read More
Entra ID Connect Download Issue
Good afternoon,
I’ve been trying all day to download the latest version of Entra ID Connect and it seems the download link is failing due to a server error. I’ve tried on different machines on different networks with the same result. Is anyone else seeing this or know the best way to open a ticket to let them know? Or is there another Microsoft mirror I could use?
Sends you to the redirect URL of:
https://go.microsoft.com/fwlink/?LinkId=615771
Which ultimately just sends you to the last URL I’ll post below.
This one, however:
https://learn.microsoft.com/en-us/entra/identity/hybrid/connect/reference-connect-version-history#looking-for-the-latest-versions
Sends you directly to the actual download link of:
https://www.microsoft.com/en-us/download/details.aspx?id=47594
Which results in a server error.
Any help is greatly appreciated. Thank you so much.
Good afternoon, I’ve been trying all day to download the latest version of Entra ID Connect and it seems the download link is failing due to a server error. I’ve tried on different machines on different networks with the same result. Is anyone else seeing this or know the best way to open a ticket to let them know? Or is there another Microsoft mirror I could use? This link:https://learn.microsoft.com/en-us/entra/identity/hybrid/connect/how-to-connect-install-roadmap#install-microsoft-entra-connectSends you to the redirect URL of:https://go.microsoft.com/fwlink/?LinkId=615771Which ultimately just sends you to the last URL I’ll post below.This one, however:https://learn.microsoft.com/en-us/entra/identity/hybrid/connect/reference-connect-version-history#looking-for-the-latest-versionsSends you directly to the actual download link of:https://www.microsoft.com/en-us/download/details.aspx?id=47594Which results in a server error. Any help is greatly appreciated. Thank you so much. Read More
Subforms in Tabs: Can They Be Dragged-and-Dropped In, or Cut-and-Pasted?
Hello, I have a question or two about using tab controls and subforms. I am using Access 2021, and am a novice at database design.
I am designing a movie collection database, and I currently have three subforms. I’d like to have them in tabs, rather than all on one form.
My question: Is it possible to drag and drop the subforms into the tabs, or cut-and-paste them? Or do I have to build the subforms over again, from scratch?
Which method of placing subforms in the tabs do you prefer? Thank you!
Hello, I have a question or two about using tab controls and subforms. I am using Access 2021, and am a novice at database design. I am designing a movie collection database, and I currently have three subforms. I’d like to have them in tabs, rather than all on one form. My question: Is it possible to drag and drop the subforms into the tabs, or cut-and-paste them? Or do I have to build the subforms over again, from scratch? Which method of placing subforms in the tabs do you prefer? Thank you! Read More
Stacked Bar Chart as Office Timeline
I am using Microsoft 365, but I do not have access to Power BI.
I am trying to create a stacked bar chart as a replacement for our firm’s Office Timeline, which currently exists on our outdated, slowly dying intranet site. What I’m looking for is something similar to this:
Projects will be on the Y axis, with a perpetual calendar on the X axis – the color changes represent the end of each project phase, and the black boxes represent milestone dates within the phase.
I have brought in the data, added a perpetual calendar and formatted the dates as numbers. I established a ‘base date’, but I’m not sure that I need it. The resulting stacked bar chart is not even close to what I’m trying to do, and I think the reason is that I need to incorporate a formula to match the ending phase dates to the perpetual calendar (see the data example below).
Do any of you know of a tutorial I could study or a general method to do what I’m trying to accomplish? I have looked at dozens of articles and YouTube videos and I can’t find anything that addresses this.
Thanks,
Traci
I am using Microsoft 365, but I do not have access to Power BI.I am trying to create a stacked bar chart as a replacement for our firm’s Office Timeline, which currently exists on our outdated, slowly dying intranet site. What I’m looking for is something similar to this:Projects will be on the Y axis, with a perpetual calendar on the X axis – the color changes represent the end of each project phase, and the black boxes represent milestone dates within the phase. I have brought in the data, added a perpetual calendar and formatted the dates as numbers. I established a ‘base date’, but I’m not sure that I need it. The resulting stacked bar chart is not even close to what I’m trying to do, and I think the reason is that I need to incorporate a formula to match the ending phase dates to the perpetual calendar (see the data example below). Do any of you know of a tutorial I could study or a general method to do what I’m trying to accomplish? I have looked at dozens of articles and YouTube videos and I can’t find anything that addresses this. Thanks,Traci Read More
Search in Outlook 16.8 does not work on Mac Book Air Ventura 13.2.1
Hi there,
bought the a new mac and the search in Outlook does not work, is not existing. I work in Outlook 16.86 on Mac Book Air Ventura 13.2.1
I de-installed MS and re-installed = followed all steps from MS. Emptied the trash and shut my mac. Re- started it and started again with re-installing. I bought the MS package and thought, I am good. But I am not.
On my old Mac 15.8, all is working in Outlook.
Can you pls advise…. I tried to download the older version of Outlook, but failed here, too.
Thanks, Sabine
Hi there, bought the a new mac and the search in Outlook does not work, is not existing. I work in Outlook 16.86 on Mac Book Air Ventura 13.2.1I de-installed MS and re-installed = followed all steps from MS. Emptied the trash and shut my mac. Re- started it and started again with re-installing. I bought the MS package and thought, I am good. But I am not.On my old Mac 15.8, all is working in Outlook. Can you pls advise…. I tried to download the older version of Outlook, but failed here, too. Thanks, Sabine Read More
Want breaks in line graph
I’m trying to follow this to see gaps in my line graph, but the gaps option is grayed out. What to do?
Display empty cells, null (#N/A) values, and hidden worksheet data in a chart – Microsoft Support
Note: This is fake data, just testing out the line graph formatting.
I’m trying to follow this to see gaps in my line graph, but the gaps option is grayed out. What to do? Display empty cells, null (#N/A) values, and hidden worksheet data in a chart – Microsoft Support Note: This is fake data, just testing out the line graph formatting. Read More
Export all Tenant Team Chats
I have read several postings here and on other sites but its still not clear if it is possible or how to do get a list of all team chats.
Our CEO is asking and not providing much information to why or what the purpose is, what they are looking for. Not sure if they are looking for the group chat titles, I assume 1to1 chats are not required as there could be hundreds/thousands of these.
Some of the reading suggests there may be a way to see;
all the chats a specific person belongs to.eDiscovery might be able to be used but seems to imply this is more about reconstruction of a chat rather than just a simple list. But this would require a Premium license and I am not sure it actually gives a list.
It also not clear how external “Chats” from a meeting would play in to this, it seems a bit more complicated than what our CEO understands.
Can anyone confirm if we can pull a list of Team chat?
I have read several postings here and on other sites but its still not clear if it is possible or how to do get a list of all team chats.Our CEO is asking and not providing much information to why or what the purpose is, what they are looking for. Not sure if they are looking for the group chat titles, I assume 1to1 chats are not required as there could be hundreds/thousands of these. Some of the reading suggests there may be a way to see;all the chats a specific person belongs to.eDiscovery might be able to be used but seems to imply this is more about reconstruction of a chat rather than just a simple list. But this would require a Premium license and I am not sure it actually gives a list.It also not clear how external “Chats” from a meeting would play in to this, it seems a bit more complicated than what our CEO understands. Can anyone confirm if we can pull a list of Team chat? Read More
Tell us about yourself! What do you want to see in the community?
We want to know more about you, to make sure we are providing the right content and bringing in experts that you are looking for. Tell us a bit more about you and what is important. Post in the comments or fill out a short survey for what you would like to see more of in this community!
We want to know more about you, to make sure we are providing the right content and bringing in experts that you are looking for. Tell us a bit more about you and what is important. Post in the comments or fill out a short survey for what you would like to see more of in this community!
Read More
Creating a sharepoint list programatically
Hi,
I have an excel file with 100~ columns which was exported from another SharePoint list (that I don’t have access to). I would like to create a list on my SharePoint site from this file but the simple ‘create list from xlsx’ doesn’t allow me to use many of the column types that I need (lookup, choice etc.).
Initially I tried using the PowerShell connector for SharePoint but my org doesn’t have permissions enabled for it. So I would I like to explore alternative solutions.
The one I have in mind is to acquire an .stp template from somewhere (my org has also disabled built-in templates so I cant seem to download a copy) and modify its JSON definition to add columns with python. Another option is to modify the xml of a list and add the columns that way.
Any help would be appreciated.
Hi, I have an excel file with 100~ columns which was exported from another SharePoint list (that I don’t have access to). I would like to create a list on my SharePoint site from this file but the simple ‘create list from xlsx’ doesn’t allow me to use many of the column types that I need (lookup, choice etc.). Initially I tried using the PowerShell connector for SharePoint but my org doesn’t have permissions enabled for it. So I would I like to explore alternative solutions. The one I have in mind is to acquire an .stp template from somewhere (my org has also disabled built-in templates so I cant seem to download a copy) and modify its JSON definition to add columns with python. Another option is to modify the xml of a list and add the columns that way. Any help would be appreciated. Read More
Introducing the podcast – No Slides Attached: AI Stories with Microsoft Partners
On July 10, we launched an exciting new podcast series crafted for Microsoft partners who are eager to gain insights, learnings, and inspiration from industry leaders and peers. Click here to learn more!
Why tune in?
No Slides Attached features meaningful conversations that combine the expertise of Microsoft leaders and inspiring stories from our partners.
Explore the latest technologies. Season 1 is all about Microsoft Copilot—your everyday AI companion.
Listen to success stories directly from other Microsoft partners.
Join the conversation through our LinkedIn Community.
Take a break
Need a breather from all the emails, meetings, and presentations? Our hosts, Helane Cohen and Fede Pacheco, will look to connect with you on the go.
Subscribe today to listen wherever you get your favorite podcasts:
YouTube* | Spotify | Apple Podcasts | Amazon Music | RSS
*With closed captions in Spanish, Portuguese, and French.
On July 10, we launched an exciting new podcast series crafted for Microsoft partners who are eager to gain insights, learnings, and inspiration from industry leaders and peers. Click here to learn more!
Why tune in?
No Slides Attached features meaningful conversations that combine the expertise of Microsoft leaders and inspiring stories from our partners.
Explore the latest technologies. Season 1 is all about Microsoft Copilot—your everyday AI companion.
Listen to success stories directly from other Microsoft partners.
Join the conversation through our LinkedIn Community.
Take a break
Need a breather from all the emails, meetings, and presentations? Our hosts, Helane Cohen and Fede Pacheco, will look to connect with you on the go.
Subscribe today to listen wherever you get your favorite podcasts:
YouTube* | Spotify | Apple Podcasts | Amazon Music | RSS
*With closed captions in Spanish, Portuguese, and French. Read More
Using GitHub Copilot for Microsoft 365 PowerShell Development
GitHub Copilot costs $10/month. At that price level, anyone working with PowerShell should try out the AI assistance to see if it helps. But will GitHub Copilot work well with Microsoft 365 PowerShell modules like Exchange Online and the Microsoft Graph PowerShell SDK. That’s what we tested and report on here.
https://practical365.com/github-copilot-powershell/
GitHub Copilot costs $10/month. At that price level, anyone working with PowerShell should try out the AI assistance to see if it helps. But will GitHub Copilot work well with Microsoft 365 PowerShell modules like Exchange Online and the Microsoft Graph PowerShell SDK. That’s what we tested and report on here.
https://practical365.com/github-copilot-powershell/ Read More
Creating a Data Package Tier List
Hi, I’m trying to build a model in Excel that displays different data sets. The data sets in Column A (1,2,3 etc.) each have different levels (A,B,C etc.). If I were to choose 1E I would obtain all the other levels (ABCD).
I want to find a way that if the user selects 1A, 4D & 3F it would automatically calculate cost of the highest tier selected for each data set (1,2,3) and also list which ones they did.
Happy to insert columns to the left of each price tag and the user can simply place an X in the cell to identify which data set they are choosing. If I can do this with checkboxes it would be great.
Picture below, apologies for the poor quality.
Hi, I’m trying to build a model in Excel that displays different data sets. The data sets in Column A (1,2,3 etc.) each have different levels (A,B,C etc.). If I were to choose 1E I would obtain all the other levels (ABCD).I want to find a way that if the user selects 1A, 4D & 3F it would automatically calculate cost of the highest tier selected for each data set (1,2,3) and also list which ones they did. Happy to insert columns to the left of each price tag and the user can simply place an X in the cell to identify which data set they are choosing. If I can do this with checkboxes it would be great. Picture below, apologies for the poor quality. Read More
How to stop outlook from archiving with backspace button
Why is Outlook archiving my emails when I hit the backspace button while using the editor functions? How do I turn off that setting? I’m wasting too much time. Switching back to the older outlook.
Why is Outlook archiving my emails when I hit the backspace button while using the editor functions? How do I turn off that setting? I’m wasting too much time. Switching back to the older outlook. Read More
Outlook 2019 Pro will not start
My system rebooted and when it came back up, Outlook won’t start.
I’ve tried starting it in safe mode as well. No change.
The last time it did this it said my license key was already used (DUH!) and I had to contact support…which is a colossal pain in the butt.
Any other methods to get this software back up and running?
System is WIN11 all the latest updates…
My system rebooted and when it came back up, Outlook won’t start.I’ve tried starting it in safe mode as well. No change.The last time it did this it said my license key was already used (DUH!) and I had to contact support…which is a colossal pain in the butt.Any other methods to get this software back up and running?System is WIN11 all the latest updates… Read More