Category: News
Filter working and then only partially working
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc.
I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again.
I am not sure what is happening.
I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc. I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again. I am not sure what is happening. I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK Read More
Using Query Store to Capture PostgreSQL Performance in Azure Database | Data Exposed: MVP Edition
Capturing query metrics in PostgreSQL can be a challenge. Add in running that PostgreSQL database on Azure and things get even more challenging. However, Microsoft has a great addition to PostgreSQL when running in Azure Database, Query Store. This session will show the great query information available within the Query Store and how to query it.
Resources:
Query Store – Azure Database for PostgreSQL – Flexible Server
Using Azure Query Store to Understand PostgreSQL Performance
Query Store best practices – Azure Database for PostgreSQL – Flexible Server
About Grant Fritchey:
Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant has written many books including “SQL Server 2022 Query Performance Tuning”. Grant teaches classes on data management and databases to the smallest user groups and largest events, all around the world.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others – that’s what sets them apart. Learn more.
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft Tech Community – Latest Blogs –Read More
Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams
We are excited to share that Copilot in Planner (preview) is now rolled out to 100% of users with a Project Plan 3 or Project Plan 5 license* in Microsoft Planner in Teams. 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.
Over the last few weeks as we started rolling out Copilot in Planner we’ve received tremendous feedback from early users. Thank you! We value your feedback and have been incorporating it into product improvements. Recent updates include:
• The ability to return to previous chats and improved reliability in answering questions about progress, due dates, and assignments
• Enhancements in adding subtasks and linking tasks to buckets and goals
• New suggested prompts to highlight question and answer capabilities
In the coming weeks, users can expect the ability to build a plan – including goals, buckets, and a work breakdown – with a single prompt.
Explore Copilot in Planner (preview) for planning, managing, and tracking projects:
• Planning: Copilot assists teams in setting goals, breaking down work, and generating tasks, goals, and buckets based on user prompts, facilitating the creation of a comprehensive project plan.
• Effective Execution: Copilot helps streamline processes, identify next steps, and break down large tasks. It manages collaboration, tracks new goals, and identifies workload issues among team members.
• Tracking Progress: Copilot aids in tracking complex plans by quickly surfacing necessary information about progress, priorities, and workload, ensuring teams stay informed and on track.
Get started
If you already have a Project Plan 3 or Project Plan 5 license, you can preview Copilot in Planner capabilities*.
If you do not have a Project license, you can request a free 30-day trial. Simply click on the diamond icon within the Planner app in Teams where you can begin your free 30-day trial of advanced capabilities of Planner including Copilot in Planner or proceed with requesting a premium license.
Share your feedback
You can share feedback through the new Planner app in Teams directly. You can also send us your feedback via the Planner Feedback Portal.
Here is how you can share your feedback directly from within the new Planner app.
Resources
• Explore the new Day in the Life guides to use Planner and Copilot for individual task management, collaborative work management and project management.
• Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Teams.
• Bookmark the new Planner adoption website
• We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
• For Planner feature updates, visit the Microsoft 365 roadmap here
• Learn about Planner and Project plans and pricing here
• Read the FAQs here
Requirements
In general, Copilot supports the following languages for prompts: Chinese (Simplified), English, French, German, Italian, Japanese, Portuguese (Brazil), Spanish. We plan on to add more languages to Copilot and will update as additional languages are supported.
* While final pricing for Copilot in Planner has not been announced, users with a Project Plan 3 or Project Plan 5 license can preview Copilot in Planner capabilities.
Microsoft Tech Community – Latest Blogs –Read More
How to plot cross quantile correltaion heatmap
How do I plot similar cross quantile correlation plotHow do I plot similar cross quantile correlation plot How do I plot similar cross quantile correlation plot heatmap, quantile, correlat MATLAB Answers — New Questions
i am trying to open matlab but it is showing “You dont have a valid license file”. It was working fine before.
i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before.i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before. i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before. valid license file MATLAB Answers — New Questions
py.list bug in R2024a
I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b.I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b. I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b. python MATLAB Answers — New Questions
Fit meta data to a custom equation
Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it.Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it. Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it. nonlinear, curve fitting MATLAB Answers — New Questions
VideoReader: Unrecognized function or variable ‘hasFrame’
I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it?I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it? I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it? video processing MATLAB Answers — New Questions
OWA loop after Exchange 2019 enabling Extended Protection
Has anyone encountered before?
Scenario
Exchange environment is Exchange 2016 & Exchange 2019.Exchange 2016 – Extended Protection not enabledExchange 2019 – Extended Protection enabled.User mailbox is residing in Exchange 2019 User attempt to login via OWA (FBA) on Exchange 2016 When login, the page keeps looping back to the logon screen.
Error in httproxy owa logs: WebExceptionStatus=ProtocolError;ResponseStatusCode=401;WebException=System.Net.WebException: The remote server returned an error: (401) Unauthorized.
Attempted to login to both OWA & ECP via OWA on Exchange 2019 – successful.
Has anyone encountered before?ScenarioExchange environment is Exchange 2016 & Exchange 2019.Exchange 2016 – Extended Protection not enabledExchange 2019 – Extended Protection enabled.User mailbox is residing in Exchange 2019 User attempt to login via OWA (FBA) on Exchange 2016 When login, the page keeps looping back to the logon screen.Error in httproxy owa logs: WebExceptionStatus=ProtocolError;ResponseStatusCode=401;WebException=System.Net.WebException: The remote server returned an error: (401) Unauthorized. Attempted to login to both OWA & ECP via OWA on Exchange 2019 – successful. Read More
Using the Rules exception “is on a recipient’s supervision list”
In our tenant, I want to quarantine all inbound mail from gmail.com except for approved senders. Currently I do this with a Rule with an Exception:
Except if | The sender | is this person
Users send me exception email addresses that I manually enter.
I notice that there is another option for The Sender called “is on a recipient’s supervision list” I don’t fully understand the Microsoft documentation on this option. It says: Messages where the sender is on the recipient’s Allowlist or Blocklist. Does this mean each user can enter the desired exception email address(es) into their Outlook (desktop client) Allow / Block lists?
Any help to clarify is greatly appreciated.
In our tenant, I want to quarantine all inbound mail from gmail.com except for approved senders. Currently I do this with a Rule with an Exception:Except if | The sender | is this person Users send me exception email addresses that I manually enter.I notice that there is another option for The Sender called “is on a recipient’s supervision list” I don’t fully understand the Microsoft documentation on this option. It says: Messages where the sender is on the recipient’s Allowlist or Blocklist. Does this mean each user can enter the desired exception email address(es) into their Outlook (desktop client) Allow / Block lists?Any help to clarify is greatly appreciated. Read More
When checkbox selected, enter specific value into spreadsheet
Greetings,
I have a userform that contains multiple checkboxes that, when checked, I would like to enter “Y” or “N” into a spreadsheet. I’m getting an error when I use an IF statement on line 18 below and am not sure why.
Any assistance would be appreciated as I have numerous checkboxes on various forms that will obviously cause an issue moving forward.
Thanks!
With Sheets(“TIER ACCESS”)
‘copy and pasted into “Sheet2” on the last row without text.
lr = .Range(“A” & Rows.Count).End(3).Row + 1
.Range(“A” & lr).Value = FirstName.Value & ” ” & LastName.Value ‘ USER NAME
.Range(“B” & lr).Value = OPSEmail.Value ‘ PASSWORD
.Range(“C” & lr).Value = OPSEmail.Value ‘ EMAIL ADDRESS
.Range(“D” & lr).Value = Date & ” ” & Time ‘ DATE USER ADDED
.Range(“E” & lr).Value = Sheets(“HOME PAGE”).Range(“M3”).Value ‘ USER ADDED BY
.Range(“F” & lr).Value = “Yes” ‘ ACTIVE USER
.Range(“G” & lr).Value = “TIER 1” ‘ USER TIER
.Range(“H” & lr).Value = “PURGE, ADD, MODIFY” ‘ CLIENT PROFILE PERMISSIONS
.Range(“I” & lr).Value = “NO PERMISSIONS” ‘ NON-CLIENT PROFILE PERMISSIONS
.Range(“J” & lr).Value = “N” ‘ UserAccess
.Range(“K” & lr).Value = “N” ‘ TIER ACCESS WS
.Range(“L” & lr).Value = “N” ‘ LIST WS
.Range(“M” & lr).Value = “N” ‘ CLIENTS WS
.Range(“N” & lr).Value = “Y” ‘ CLIENT PROFILES WS
.Range(“O” & lr).Value = if DTTCheckBox.Value = true then “Y” ‘ DTT WS
.Range(“P” & lr).Value = “Y” ‘ TECHNOLOGY WS
.Range(“Q” & lr).Value = “Y” ‘ UNIFORM WS
.Range(“R” & lr).Value = “Y” ‘ LiDAR & RADAR WS
.Range(“S” & lr).Value = “Y” ‘ VEHICLES WS
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
Greetings, I have a userform that contains multiple checkboxes that, when checked, I would like to enter “Y” or “N” into a spreadsheet. I’m getting an error when I use an IF statement on line 18 below and am not sure why. Any assistance would be appreciated as I have numerous checkboxes on various forms that will obviously cause an issue moving forward. Thanks! With Sheets(“TIER ACCESS”)
‘copy and pasted into “Sheet2” on the last row without text.
lr = .Range(“A” & Rows.Count).End(3).Row + 1
.Range(“A” & lr).Value = FirstName.Value & ” ” & LastName.Value ‘ USER NAME
.Range(“B” & lr).Value = OPSEmail.Value ‘ PASSWORD
.Range(“C” & lr).Value = OPSEmail.Value ‘ EMAIL ADDRESS
.Range(“D” & lr).Value = Date & ” ” & Time ‘ DATE USER ADDED
.Range(“E” & lr).Value = Sheets(“HOME PAGE”).Range(“M3”).Value ‘ USER ADDED BY
.Range(“F” & lr).Value = “Yes” ‘ ACTIVE USER
.Range(“G” & lr).Value = “TIER 1” ‘ USER TIER
.Range(“H” & lr).Value = “PURGE, ADD, MODIFY” ‘ CLIENT PROFILE PERMISSIONS
.Range(“I” & lr).Value = “NO PERMISSIONS” ‘ NON-CLIENT PROFILE PERMISSIONS
.Range(“J” & lr).Value = “N” ‘ UserAccess
.Range(“K” & lr).Value = “N” ‘ TIER ACCESS WS
.Range(“L” & lr).Value = “N” ‘ LIST WS
.Range(“M” & lr).Value = “N” ‘ CLIENTS WS
.Range(“N” & lr).Value = “Y” ‘ CLIENT PROFILES WS
.Range(“O” & lr).Value = if DTTCheckBox.Value = true then “Y” ‘ DTT WS
.Range(“P” & lr).Value = “Y” ‘ TECHNOLOGY WS
.Range(“Q” & lr).Value = “Y” ‘ UNIFORM WS
.Range(“R” & lr).Value = “Y” ‘ LiDAR & RADAR WS
.Range(“S” & lr).Value = “Y” ‘ VEHICLES WS
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “” Read More
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value Read More
How to capture replies to a bot’s message in a Microsoft Teams Channel without mentioning the bot?
I have developed a message extension bot app for Microsoft Teams and I want to capture replies to a message posted by the bot in a Teams channel without requiring users to mention the bot directly.
I am using Node.js and TypeScript for my bot.
The bot is registered in the Azure Bot Service.
I want to capture replies to this message without users needing to mention the bot. How can I achieve this?
Any guidance or examples would be greatly appreciated!
I have developed a message extension bot app for Microsoft Teams and I want to capture replies to a message posted by the bot in a Teams channel without requiring users to mention the bot directly.I am using Node.js and TypeScript for my bot.The bot is registered in the Azure Bot Service.I want to capture replies to this message without users needing to mention the bot. How can I achieve this?Any guidance or examples would be greatly appreciated! Read More
1449/1.0.94.202407110 update has removed transfer to Voicemail
Teams Devices version 1449/1.0.94.202407110. Desk phones no longer have the option to transfer calls directly to Work Voicemail after the person is selected. It was replaced by Call Teams, which is the same as Call Work Number.
I am baffled at the removal of such a critical function of a phone system. Receptionist efficiency is severely degraded with the removal of the function.
Teams Devices version 1449/1.0.94.202407110. Desk phones no longer have the option to transfer calls directly to Work Voicemail after the person is selected. It was replaced by Call Teams, which is the same as Call Work Number.I am baffled at the removal of such a critical function of a phone system. Receptionist efficiency is severely degraded with the removal of the function. Read More
Crowdstrike Agent with Microsoft Purview DLP
Could we use CrowdStrike as the main (Active) EDR while also enrolling the same machine into the agent-based Purview DLP? We have currently deployed MDE (passive) through the MDE Portal Onboarding, with RTP (Real-Time Protection) and BM (Behavioral Monitoring) enabled in the policy settings.
While testing policies against user devices, we are unable to generate any alerts that match a rule based on conditions (e.g. PII, CC Data – where a user tries to copy and print sensitive information in a document), and the action based on the rule should be to BLOCK. This is not happening because there seems to be a disconnect from the workstation receiving the policies from Purview.
Could we use CrowdStrike as the main (Active) EDR while also enrolling the same machine into the agent-based Purview DLP? We have currently deployed MDE (passive) through the MDE Portal Onboarding, with RTP (Real-Time Protection) and BM (Behavioral Monitoring) enabled in the policy settings.While testing policies against user devices, we are unable to generate any alerts that match a rule based on conditions (e.g. PII, CC Data – where a user tries to copy and print sensitive information in a document), and the action based on the rule should be to BLOCK. This is not happening because there seems to be a disconnect from the workstation receiving the policies from Purview. Read More
Drawdown Schedule W/Timeline
Hello – I’m attempting to build an excel based timeline schedule with a budget drawdown based on individuals and amounts. Would there be any examples or is excel capable for such a task? Open to suggestions. Thanks in advance.
Hello – I’m attempting to build an excel based timeline schedule with a budget drawdown based on individuals and amounts. Would there be any examples or is excel capable for such a task? Open to suggestions. Thanks in advance. Read More
xlookup multiple values
Hello I am trying to use a column where each cell has multiple Unique Identifiers separated by a column. in another sheet there’s a column where each cell has a singular unique Identifier. I am trying to pull the products associated with the singular identifiers and bring each unique product separated by commas, into another column. I did it manually for example below. I think it should be some sort of xlookup but I can’t figure it out. I need a forumla to give me column b.
Hello I am trying to use a column where each cell has multiple Unique Identifiers separated by a column. in another sheet there’s a column where each cell has a singular unique Identifier. I am trying to pull the products associated with the singular identifiers and bring each unique product separated by commas, into another column. I did it manually for example below. I think it should be some sort of xlookup but I can’t figure it out. I need a forumla to give me column b. Read More
Process Monitor 2.0 for Linux and Sysmon v15.15
Microsoft Tech Community – Latest Blogs –Read More
The Microsoft Copilot Dashboard is now included with Copilot for Microsoft 365
As previously announced, the Microsoft Copilot Dashboard is now available as part of Copilot for Microsoft 365 licenses and no longer requires a Viva Insights premium license. We are now rolling out the Microsoft Copilot Dashboard to Copilot for Microsoft 365 customers in a few phases over the next few months. More details on what’s changing and timing are below.
Understanding how Copilot is being leveraged by your organization is paramount to driving adoption and impact. That is why we created the Microsoft Copilot Dashboard.
The Copilot Dashboard helps you:
Prepare for your Copilot rollout
Understand how employees utilize Copilot
Measure the impact of your Copilot investments
Microsoft Copilot Dashboard – Adoption ReportMicrosoft Copilot Dashboard – Impact Report
The Copilot Dashboard provides actionable insights to help organizations deploy Copilot, drive adoption based on workplace patterns and measure impact. The dashboard covers the following metric categories: Readiness, Adoption, Impact, and Sentiment. Additionally, the Learning section provides a library of research and best practices to support your AI journey.
Access to the Copilot Dashboard is available to a limited number of leaders in the organization as well as Global Admins (details here). If you have access to the Copilot Dashboard, you can find it in the Teams or web app.
What’s new in the Microsoft Copilot Dashboard
The inclusion of the Copilot Dashboard with Copilot for Microsoft 365 allows us to provide a more comprehensive view of usage across your organization. Users will now see data for all Copilot license holders, not just those users with a Viva Insights license. By including every employee with a Copilot license in the analyzed population, organizations gain a better understanding of the workforce to make data-driven decisions that support AI transformation.
As part of this update, we are also unifying all Copilot Dashboard settings for the Global administrator in the Microsoft 365 Admin Center to make management more streamlined. New controls are available for admins to manage which employees should be analyzed in the Copilot Dashboard (details here). With these new controls, admins can now:
Assign access to the Copilot Dashboard
Upload organizational data
Manage a list of non-Copilot users for comparison
Create an exclusion list
Adjust minimum group size for generating insights
Customer rollout plan
The availability of the Copilot Dashboard for Copilot for Microsoft 365 customers will occur in phases on a rolling basis, starting now.
Customers with over 100 assigned Copilot for Microsoft 365 licenses or 10 assigned premium Viva Insights licenses will begin to see the Copilot Dashboard now.
Customers with less than 100 assigned Copilot for Microsoft 365 licenses will receive the dashboard in the coming months. Timing will be refined as we progress through the phased rollout but we are working to accomplish this in the next 3 months.
Customers with less than 10 assigned Copilot for Microsoft 365 licenses will continue to get access to a limited Copilot Dashboard they have today that features tenant-level metrics.
Once you have the Copilot Dashboard, you will see updated Adoption and Impact reports for all Copilot license holders.
Go deeper with advanced Copilot reporting in Viva Insights
Customers looking for more advanced Copilot reporting should consider Viva Insights for a more customized experience. Analysts can use Viva Insights to create custom reports to better understand Copilot usage at a more granular level and bring in additional data sets from HRIS, CRM and other systems to identify the business value of Copilot for your organization.
Some Copilot reporting capabilities exclusive to Viva Insights include:
Ability to pull usage data older than 28 days
Ability to pull in third party, functional data – for example sales performance or customer service KPIs – to identify business value correlations
Ability to filter and group using custom organizational attributes
Ability to build custom views, dashboards and dynamically change dates
Ability to customize the definition of active Copilot users and other metrics
Advanced, customizable reports for Copilot Adoption and Impact are available now in Viva Insights, take a look!
Viva Insights – Advanced Copilot Adoption Report
With Viva Insights, you can take your Copilot reporting to a whole new level to further accelerate your AI transformation. To use Viva Insights for advanced Copilot reporting, you must have a Viva Insights license.
Next steps and resources
We are very excited to bring the Copilot Dashboard to Copilot for Microsoft 365 customers and we hope you find the above updates helpful. We will continue to innovate on both the Copilot Dashboard and advanced Copilot reporting capabilities in Viva Insights and will provide updates on an ongoing basis. Please stay tuned for more updates and features to help you drive Copilot adoption and impact.
We have a wealth of resources to help you get the most out of your Microsoft Copilot Dashboard. Here are a few to get you started.
MS Learn: Microsoft Copilot Dashboard support and setup
eBook: Microsoft Copilot Dashboard Metric Interpretations and Considerations
Learn more about Viva Workplace Analytics and Employee Feedback and Viva Insights solutions. See features, demos, pricing and more.
Microsoft Tech Community – Latest Blogs –Read More
Join us for the FY25 Azure Playbook Partner Landing Calls
Please join us in kicking-off our fiscal year and see the plans from the Azure Partner Strategy team for Infrastructure, Digital and Application Innovation and Data and AI. This training is made available for all Microsoft Partners.
Azure Infrastructure playbook
When:
Tuesday, July 30th
Option 1 at 8:00-9:00 AM PT and Option 2 at 5:00-6:00 PM PT. A recording will be made available following the session.
Agenda:
Overview
Be AI-Ready
Foundational Priorities
Microsoft Sales Priorities
Partner Opportunity
FY25 GTM Partner Strategy
Priorities and Key Area of Focus
Solution Play Prioritization
The Customer and Partner Journey
Mainstream Solution Plays
Winning in SMB
Microsoft AI Cloud Partner Program
Investments
Partner Investments Summary and Direction
Azure Discovery Workshops
AMM/Azure Innovate Partner-Led Offerings
Hero Investment One-Sliders
Build Your Business
Partner Skilling
Partner Enablement Evolution in FY25
Partner Enablement Big Bets
Partner Marketing Campaigns
Azure Digital and Application Innovation & Data and AI playbook
When:
Wednesday, August 7th
Option 1 at 8:00-9:00 AM PT and Option 2 at 5:00-6:00 PM PT. A recording will be made available following the session.
Agenda:
Overview
Foundational Priorities
AI Design Wins
Data & AI and Digital and App Innovation Business Overview
Partner Opportunity
FY25 GTM Partner Strategy
GTM Priorities
Solution Plays by Customer Segment
The Customer and Partner Journey
Mainstream Solution Plays
Resources
Build Your Business
Microsoft AI Cloud Partner Program
Partner Enablement Evolution in FY25
Partner Enablement Big Bets
Practice Building Resources
Investments
Partner Investments Summary and Direction
Partner Marketing
Campaign in a Box
Through Partner Marketing Roadmap
Thank you,
Azure Data & AI and Digital and App Innovation Partner Strategy Teams
Microsoft Tech Community – Latest Blogs –Read More
