Category: News
Inability for External Presenters to Manage Breakouts is hurting our business in the L&D industry
I’ve raised this topic in various forums and at numerous conferences over the years, but I’m hoping we can initiate a productive dialogue here.
We operate in the L&D space, offering corporate training support for global clients across over a dozen platforms, and have been doing so since the days of Skype. Whether it’s WebEx, Adobe Connect, Zoom, or another platform, the process is generally straightforward. We receive host rights, and we’re set to go.
However, Microsoft Teams is an exception. From the beginning, conducting training sessions as an external vendor on Teams has been extremely challenging. Despite some improvements over the years, one critical piece of functionality is still missing: external users cannot manage breakout rooms.
This oversight is severely impacting our business, as well as many other small businesses like ours, as our corporate clients transition to Teams. Many organizations move to the Microsoft ecosystem partly due to their InfoSec policies, making the issuance of internal organization credentials difficult and often necessitating additional hardware.
It’s not just external vendors who are frustrated. Many of our clients, including the L&D departments of Fortune 500 companies, have actively opposed their companies’ transition to Teams.
We want to embrace these transitions and even endorse and encourage them. Is this functionality on the roadmap? Who do we need to speak to, or what actions are required to fully address this issue? We are eager to discuss the friction points of using Teams for training from the perspective of a company that has facilitated and supported hundreds of thousands of trainings across every major platform over the last decade.
Your thoughts and insights would be greatly appreciated.
I’ve raised this topic in various forums and at numerous conferences over the years, but I’m hoping we can initiate a productive dialogue here. We operate in the L&D space, offering corporate training support for global clients across over a dozen platforms, and have been doing so since the days of Skype. Whether it’s WebEx, Adobe Connect, Zoom, or another platform, the process is generally straightforward. We receive host rights, and we’re set to go. However, Microsoft Teams is an exception. From the beginning, conducting training sessions as an external vendor on Teams has been extremely challenging. Despite some improvements over the years, one critical piece of functionality is still missing: external users cannot manage breakout rooms.This oversight is severely impacting our business, as well as many other small businesses like ours, as our corporate clients transition to Teams. Many organizations move to the Microsoft ecosystem partly due to their InfoSec policies, making the issuance of internal organization credentials difficult and often necessitating additional hardware. It’s not just external vendors who are frustrated. Many of our clients, including the L&D departments of Fortune 500 companies, have actively opposed their companies’ transition to Teams.We want to embrace these transitions and even endorse and encourage them. Is this functionality on the roadmap? Who do we need to speak to, or what actions are required to fully address this issue? We are eager to discuss the friction points of using Teams for training from the perspective of a company that has facilitated and supported hundreds of thousands of trainings across every major platform over the last decade. Your thoughts and insights would be greatly appreciated. Read More
ntel Ethernet controller(3) I 225V issue
Hello,
I was having 2019 standard server, running, Added one SSD and Installed fresh new standard 2022 server. After installation, drivers are missing so exported from running 2019 server. All drivers are installed except one Network card. This card is Intel Ethernet controller(3) I 225V.. I tried all possible but did not find any luck. This 2022 server is not yet keyed, but I guess its good for next 180 days. what could be reason ?
Any help ?
Hello,I was having 2019 standard server, running, Added one SSD and Installed fresh new standard 2022 server. After installation, drivers are missing so exported from running 2019 server. All drivers are installed except one Network card. This card is Intel Ethernet controller(3) I 225V.. I tried all possible but did not find any luck. This 2022 server is not yet keyed, but I guess its good for next 180 days. what could be reason ? Any help ? Read More
Struggling with Vlookup / Index & Match
I need to match 2 columns of data to another sheet, then return another column of data only if they both match. I will attach a file in the reply.
Thank you,
Ambrosia
64-bit operating system, x64-based processor
Windows 10 Enterprise
Microsoft 365 Apps for enterprise
Version 2308
I need to match 2 columns of data to another sheet, then return another column of data only if they both match. I will attach a file in the reply. Thank you,Ambrosia 64-bit operating system, x64-based processorWindows 10 EnterpriseMicrosoft 365 Apps for enterpriseVersion 2308 Read More
Having SharePoint Search Bar search a specific site
Hi,
We are setting up a SharePoint site and would like to behavior of the SharePoint search to search that site collection, as well as a different site collection. I know it’s possible to change the search behavior for a site to either do that site, entire tenant or hub but we’d prefer to have it only search another site if possible.
Thanks.
Hi, We are setting up a SharePoint site and would like to behavior of the SharePoint search to search that site collection, as well as a different site collection. I know it’s possible to change the search behavior for a site to either do that site, entire tenant or hub but we’d prefer to have it only search another site if possible. Thanks. Read More
Audio module soft keys doesn’t work on Teams
Hi
I’m using this docking from HP which I think is great:
The only problem that I’m having is that the soft keys on the top and expecially:
mute
answer call
turn off call
doesn’t work with Team either old and new version of that.
Now I have seen this old discussion:
https://www.reddit.com/r/MicrosoftTeams/comments/k618e6/hp_thunderbolt_dock_integration/
where people where supposing that a firmware update from HP is needed to have them working with Teams and HP is never gonna release it. Now, frankly I don’t know but isn’t there a way to have them working without a firmware update?
Please note that these soft keys were working with old Skype For Business so I guess teams change some sort of protocol for that. Any hope to have them back working?
It’s kind of disappointing that the device is great and running but neither HP or Microsoft is gonna help doing a very minor update to have it fixed.
HiI’m using this docking from HP which I think is great:The only problem that I’m having is that the soft keys on the top and expecially:muteanswer callturn off calldoesn’t work with Team either old and new version of that.Now I have seen this old discussion:https://www.reddit.com/r/MicrosoftTeams/comments/k618e6/hp_thunderbolt_dock_integration/where people where supposing that a firmware update from HP is needed to have them working with Teams and HP is never gonna release it. Now, frankly I don’t know but isn’t there a way to have them working without a firmware update? Please note that these soft keys were working with old Skype For Business so I guess teams change some sort of protocol for that. Any hope to have them back working? It’s kind of disappointing that the device is great and running but neither HP or Microsoft is gonna help doing a very minor update to have it fixed. Read More
Formula Help: Count Unique Domains per Account ID
Hello Community!
I have an Excel file with two columns: Account ID and Domain Name. A single Account ID can have multiple Domain Names associated with it. In other words, the relationship between Account ID and Domain Name is one-to-many (1:N). What’s the best way to pull the number of UNIQUE domains associated with a specific account ID? Here is what the sample data might look like:
Account IDDomain Name1234f.com1234e.com1234g.com4321a.com4321b.com4321
b.com
5678z.com5678
y.com
For Account ID 1234, there are 3 unique domains. Similarly, there are 2 unique domains for account IDs 4321 and 5678. Can anyone please assist.
Hello Community! I have an Excel file with two columns: Account ID and Domain Name. A single Account ID can have multiple Domain Names associated with it. In other words, the relationship between Account ID and Domain Name is one-to-many (1:N). What’s the best way to pull the number of UNIQUE domains associated with a specific account ID? Here is what the sample data might look like: Account IDDomain Name1234f.com1234e.com1234g.com4321a.com4321b.com4321b.com5678z.com5678y.com For Account ID 1234, there are 3 unique domains. Similarly, there are 2 unique domains for account IDs 4321 and 5678. Can anyone please assist. Read More
AzureOpenAI doesn’t support parameter chunking_strategy while creating vector store.
OpenAI recently added a new feature to their library, which says we can customize the chunking strategy used to split and store files in vector stores using the new parameter “chunking_strategy” to be used while creating a vector store.
If I try creating a new vector store mentioning the custom chunking strategy using the OpenAI client, I am able to successfully create one.
But, if I try creating a new vector store mentioning the custom chunking strategy using the AzureOpenAI client, I get BadRequestError which says unknown parameter: chunking_strategy.
I have tried upgrading the openai python library, but that doesn’t solve the issue.
I request AzureOpenAI to update their module as per the changes done by openai library.
OpenAI recently added a new feature to their library, which says we can customize the chunking strategy used to split and store files in vector stores using the new parameter “chunking_strategy” to be used while creating a vector store.If I try creating a new vector store mentioning the custom chunking strategy using the OpenAI client, I am able to successfully create one.But, if I try creating a new vector store mentioning the custom chunking strategy using the AzureOpenAI client, I get BadRequestError which says unknown parameter: chunking_strategy.I have tried upgrading the openai python library, but that doesn’t solve the issue.I request AzureOpenAI to update their module as per the changes done by openai library. Read More
% Complete and % Work Complette do not update with Actual Start change.
Changing the date in Actual Start does not update the values in % Complete and % Work Complete columns, they stay at 0. If the Actual Finish date has any date at all, the percentages go to 100%.
Is Project supposed to be automatically calculating those % complete columns or am I missing steps?
Windows 11
Project Online Desktop Client v2405
Changing the date in Actual Start does not update the values in % Complete and % Work Complete columns, they stay at 0. If the Actual Finish date has any date at all, the percentages go to 100%. Is Project supposed to be automatically calculating those % complete columns or am I missing steps? Windows 11Project Online Desktop Client v2405 Read More
Iteration method of optimization
I am trying to solve the problem using stackelberg sequential equilibrium method –
Understanding the Approach:
In a Stackelberg game, we have two players: the leader and the follower. The leader chooses its strategy first, knowing that the follower will then optimize their strategy in response to the leader’s choice. This sequential decision-making process requires us to iteratively solve for the best responses of each player until we converge to a Nash equilibrium.
-Follower’s Best Response (t given k):
The follower’s strategy t is a function of the leader’s strategy k. We need to find the value of t that maximizes the follower’s utility given the leader’s choice of k. We start by initial guess of k and compute corresponding optimal t.
Leader’s Best Response (k inputing response of t):
Once we have the optimal t, the leader then chooses its strategy k to maximize its utility, knowing the follower will choose t optimally in response.
We will do this iteration till initial guess converge to optimal k. Following code encapsulate my idea –
% Parameters
m_values = linspace(0, 1, 100); % Range of m values
tolerance = 1e-6; % Convergence tolerance
max_iter = 1000; % Maximum number of iterations
% Initialize arrays to store results
k_solutions = zeros(size(m_values));
t_solutions = zeros(size(m_values));
% Function to compute follower’s best response t given k and m
compute_t = @(k, m) fminbnd(@(t) abs(sqrt(k) * ((m./t + 2) / 3) – sqrt(1 – k) * (1 / 3) * (2 + m./t + (2 * m + t) ./ ((m – t).^2 – 2 * t))), 0, 1);
% Function to compute leader’s objective function given k, t, and m
compute_obj = @(k, t, m) -(sqrt(1 – k) * (t^6 * (2 * m * (3 * m + 2) + 4) – t^5 * (m * (m * (5 * m + 6) + 11) + 12) + m^6 + 2 * t^7 – t^8 – t^4 * (m * (3 * m * (m * (3 * m + 2) – 3) – 16) – 9) – 2 * m^3 * t^2 * (3 * m^3 + 2 * m + 3) + m^2 * t^3 * (m * (3 * m * (5 * m + 4) + 1) – 4)) + sqrt(k) * (t^4 * (m * (9 * m * (m * (m + 4) + 5) + 28) + 9) – m^4 * (3 * m – 2) – t^6 * (6 * m * (m + 2) + 10) + t^5 * (4 * m^3 + 12 * m + 8) + t^8 + m * t^2 * (m * (m * (4 * m^3 + 3 * m + 9) + 6) – 8) + 2 * m^2 * t * (3 * m – 2) – 2 * m * t^3 * (m * (m * (6 * m * (m + 2) + 7) + 6) – 2))) / (18 * t^3 * (2 * t – (m – t)^2));
% Main loop to solve for each m
for i = 1:length(m_values)
m = m_values(i);
k_guess = 0.75; % Initial guess for k
k_opt = k_guess;
t_opt = compute_t(k_opt, m);
% Iterative optimization
for iter = 1:max_iter
% Compute optimal t given k
t_opt = compute_t(k_opt, m);
% Optimize k given t
k_opt_new = fminbnd(@(k) compute_obj(k, t_opt, m), 0.5, 1); % Use fminbnd for bounded optimization
% Check for convergence
if abs(k_opt_new – k_opt) < tolerance
k_opt = k_opt_new;
break;
end
k_opt = k_opt_new;
end
% Store solutions
k_solutions(i) = k_opt;
t_solutions(i) = t_opt;
end
% Plot results
figure;
plot(m_values, k_solutions, ‘b-‘, ‘LineWidth’, 1.5);
hold on;
plot(m_values, t_solutions, ‘r–‘, ‘LineWidth’, 1.5);
xlabel(‘m’);
ylabel(‘Value’);
legend(‘Optimal k’, ‘Optimal t’);
title(‘Stackelberg Equilibrium Solutions’);
% Display final values
fprintf(‘Final solutions:n’);
fprintf(‘m t k t tn’);
for i = 1:length(m_values)
fprintf(‘%.4f t %.4f t %.4fn’, m_values(i), k_solutions(i), t_solutions(i));
end
I could have used calculus… But since expression of t cannot be explicitly expressed as a function of k, substituting t into k and then differentiating wrt k (where, t is also function k) would give an untractably long expression.
Is the Approach I used correct? Can someone please suggest a better approach? Anyone please helpI am trying to solve the problem using stackelberg sequential equilibrium method –
Understanding the Approach:
In a Stackelberg game, we have two players: the leader and the follower. The leader chooses its strategy first, knowing that the follower will then optimize their strategy in response to the leader’s choice. This sequential decision-making process requires us to iteratively solve for the best responses of each player until we converge to a Nash equilibrium.
-Follower’s Best Response (t given k):
The follower’s strategy t is a function of the leader’s strategy k. We need to find the value of t that maximizes the follower’s utility given the leader’s choice of k. We start by initial guess of k and compute corresponding optimal t.
Leader’s Best Response (k inputing response of t):
Once we have the optimal t, the leader then chooses its strategy k to maximize its utility, knowing the follower will choose t optimally in response.
We will do this iteration till initial guess converge to optimal k. Following code encapsulate my idea –
% Parameters
m_values = linspace(0, 1, 100); % Range of m values
tolerance = 1e-6; % Convergence tolerance
max_iter = 1000; % Maximum number of iterations
% Initialize arrays to store results
k_solutions = zeros(size(m_values));
t_solutions = zeros(size(m_values));
% Function to compute follower’s best response t given k and m
compute_t = @(k, m) fminbnd(@(t) abs(sqrt(k) * ((m./t + 2) / 3) – sqrt(1 – k) * (1 / 3) * (2 + m./t + (2 * m + t) ./ ((m – t).^2 – 2 * t))), 0, 1);
% Function to compute leader’s objective function given k, t, and m
compute_obj = @(k, t, m) -(sqrt(1 – k) * (t^6 * (2 * m * (3 * m + 2) + 4) – t^5 * (m * (m * (5 * m + 6) + 11) + 12) + m^6 + 2 * t^7 – t^8 – t^4 * (m * (3 * m * (m * (3 * m + 2) – 3) – 16) – 9) – 2 * m^3 * t^2 * (3 * m^3 + 2 * m + 3) + m^2 * t^3 * (m * (3 * m * (5 * m + 4) + 1) – 4)) + sqrt(k) * (t^4 * (m * (9 * m * (m * (m + 4) + 5) + 28) + 9) – m^4 * (3 * m – 2) – t^6 * (6 * m * (m + 2) + 10) + t^5 * (4 * m^3 + 12 * m + 8) + t^8 + m * t^2 * (m * (m * (4 * m^3 + 3 * m + 9) + 6) – 8) + 2 * m^2 * t * (3 * m – 2) – 2 * m * t^3 * (m * (m * (6 * m * (m + 2) + 7) + 6) – 2))) / (18 * t^3 * (2 * t – (m – t)^2));
% Main loop to solve for each m
for i = 1:length(m_values)
m = m_values(i);
k_guess = 0.75; % Initial guess for k
k_opt = k_guess;
t_opt = compute_t(k_opt, m);
% Iterative optimization
for iter = 1:max_iter
% Compute optimal t given k
t_opt = compute_t(k_opt, m);
% Optimize k given t
k_opt_new = fminbnd(@(k) compute_obj(k, t_opt, m), 0.5, 1); % Use fminbnd for bounded optimization
% Check for convergence
if abs(k_opt_new – k_opt) < tolerance
k_opt = k_opt_new;
break;
end
k_opt = k_opt_new;
end
% Store solutions
k_solutions(i) = k_opt;
t_solutions(i) = t_opt;
end
% Plot results
figure;
plot(m_values, k_solutions, ‘b-‘, ‘LineWidth’, 1.5);
hold on;
plot(m_values, t_solutions, ‘r–‘, ‘LineWidth’, 1.5);
xlabel(‘m’);
ylabel(‘Value’);
legend(‘Optimal k’, ‘Optimal t’);
title(‘Stackelberg Equilibrium Solutions’);
% Display final values
fprintf(‘Final solutions:n’);
fprintf(‘m t k t tn’);
for i = 1:length(m_values)
fprintf(‘%.4f t %.4f t %.4fn’, m_values(i), k_solutions(i), t_solutions(i));
end
I could have used calculus… But since expression of t cannot be explicitly expressed as a function of k, substituting t into k and then differentiating wrt k (where, t is also function k) would give an untractably long expression.
Is the Approach I used correct? Can someone please suggest a better approach? Anyone please help I am trying to solve the problem using stackelberg sequential equilibrium method –
Understanding the Approach:
In a Stackelberg game, we have two players: the leader and the follower. The leader chooses its strategy first, knowing that the follower will then optimize their strategy in response to the leader’s choice. This sequential decision-making process requires us to iteratively solve for the best responses of each player until we converge to a Nash equilibrium.
-Follower’s Best Response (t given k):
The follower’s strategy t is a function of the leader’s strategy k. We need to find the value of t that maximizes the follower’s utility given the leader’s choice of k. We start by initial guess of k and compute corresponding optimal t.
Leader’s Best Response (k inputing response of t):
Once we have the optimal t, the leader then chooses its strategy k to maximize its utility, knowing the follower will choose t optimally in response.
We will do this iteration till initial guess converge to optimal k. Following code encapsulate my idea –
% Parameters
m_values = linspace(0, 1, 100); % Range of m values
tolerance = 1e-6; % Convergence tolerance
max_iter = 1000; % Maximum number of iterations
% Initialize arrays to store results
k_solutions = zeros(size(m_values));
t_solutions = zeros(size(m_values));
% Function to compute follower’s best response t given k and m
compute_t = @(k, m) fminbnd(@(t) abs(sqrt(k) * ((m./t + 2) / 3) – sqrt(1 – k) * (1 / 3) * (2 + m./t + (2 * m + t) ./ ((m – t).^2 – 2 * t))), 0, 1);
% Function to compute leader’s objective function given k, t, and m
compute_obj = @(k, t, m) -(sqrt(1 – k) * (t^6 * (2 * m * (3 * m + 2) + 4) – t^5 * (m * (m * (5 * m + 6) + 11) + 12) + m^6 + 2 * t^7 – t^8 – t^4 * (m * (3 * m * (m * (3 * m + 2) – 3) – 16) – 9) – 2 * m^3 * t^2 * (3 * m^3 + 2 * m + 3) + m^2 * t^3 * (m * (3 * m * (5 * m + 4) + 1) – 4)) + sqrt(k) * (t^4 * (m * (9 * m * (m * (m + 4) + 5) + 28) + 9) – m^4 * (3 * m – 2) – t^6 * (6 * m * (m + 2) + 10) + t^5 * (4 * m^3 + 12 * m + 8) + t^8 + m * t^2 * (m * (m * (4 * m^3 + 3 * m + 9) + 6) – 8) + 2 * m^2 * t * (3 * m – 2) – 2 * m * t^3 * (m * (m * (6 * m * (m + 2) + 7) + 6) – 2))) / (18 * t^3 * (2 * t – (m – t)^2));
% Main loop to solve for each m
for i = 1:length(m_values)
m = m_values(i);
k_guess = 0.75; % Initial guess for k
k_opt = k_guess;
t_opt = compute_t(k_opt, m);
% Iterative optimization
for iter = 1:max_iter
% Compute optimal t given k
t_opt = compute_t(k_opt, m);
% Optimize k given t
k_opt_new = fminbnd(@(k) compute_obj(k, t_opt, m), 0.5, 1); % Use fminbnd for bounded optimization
% Check for convergence
if abs(k_opt_new – k_opt) < tolerance
k_opt = k_opt_new;
break;
end
k_opt = k_opt_new;
end
% Store solutions
k_solutions(i) = k_opt;
t_solutions(i) = t_opt;
end
% Plot results
figure;
plot(m_values, k_solutions, ‘b-‘, ‘LineWidth’, 1.5);
hold on;
plot(m_values, t_solutions, ‘r–‘, ‘LineWidth’, 1.5);
xlabel(‘m’);
ylabel(‘Value’);
legend(‘Optimal k’, ‘Optimal t’);
title(‘Stackelberg Equilibrium Solutions’);
% Display final values
fprintf(‘Final solutions:n’);
fprintf(‘m t k t tn’);
for i = 1:length(m_values)
fprintf(‘%.4f t %.4f t %.4fn’, m_values(i), k_solutions(i), t_solutions(i));
end
I could have used calculus… But since expression of t cannot be explicitly expressed as a function of k, substituting t into k and then differentiating wrt k (where, t is also function k) would give an untractably long expression.
Is the Approach I used correct? Can someone please suggest a better approach? Anyone please help iteration, optimization, fmincon MATLAB Answers — New Questions
Calling python function using Matlab error: Unable to resolve the name
I have a python file. The name of the file is final_output.py which contains one function text_recognizer. When I try to call this function using Matlab script it throws me error message.
Unable to resolve the name ‘py.final_output.text_recognizer’.
Error in NER_PM (line 16)
pyOut = py.final_output.text_recognizer(model_path, text);
I share the code block here which I tried to run in Matlab,
pe = pyenv;
disp(pe);
path_add = fileparts(which(‘final_output.py’));
if count(py.sys.path, path_add) == 0
insert(py.sys.path, int64(0), path_add);
end
model_path = ‘D:\output\model-best’;
text = ‘Roses are red’;
pyOut = py.final_output.text_recognizer(model_path, text);
entity_labels = cell(pyOut);
disp(entity_labels);
Any help will be appreciated.I have a python file. The name of the file is final_output.py which contains one function text_recognizer. When I try to call this function using Matlab script it throws me error message.
Unable to resolve the name ‘py.final_output.text_recognizer’.
Error in NER_PM (line 16)
pyOut = py.final_output.text_recognizer(model_path, text);
I share the code block here which I tried to run in Matlab,
pe = pyenv;
disp(pe);
path_add = fileparts(which(‘final_output.py’));
if count(py.sys.path, path_add) == 0
insert(py.sys.path, int64(0), path_add);
end
model_path = ‘D:\output\model-best’;
text = ‘Roses are red’;
pyOut = py.final_output.text_recognizer(model_path, text);
entity_labels = cell(pyOut);
disp(entity_labels);
Any help will be appreciated. I have a python file. The name of the file is final_output.py which contains one function text_recognizer. When I try to call this function using Matlab script it throws me error message.
Unable to resolve the name ‘py.final_output.text_recognizer’.
Error in NER_PM (line 16)
pyOut = py.final_output.text_recognizer(model_path, text);
I share the code block here which I tried to run in Matlab,
pe = pyenv;
disp(pe);
path_add = fileparts(which(‘final_output.py’));
if count(py.sys.path, path_add) == 0
insert(py.sys.path, int64(0), path_add);
end
model_path = ‘D:\output\model-best’;
text = ‘Roses are red’;
pyOut = py.final_output.text_recognizer(model_path, text);
entity_labels = cell(pyOut);
disp(entity_labels);
Any help will be appreciated. matlab, python, pyenv MATLAB Answers — New Questions
Edge reminded me to add the placeholder property to the file upload control.
Form elements must have labels: Element has no title attribute Element has no placeholder attribute [Error]
“`html
<input type=”file” name=”file” accept=”.*”>
“`
Form elements must have labels: Element has no title attribute Element has no placeholder attribute [Error]“`html<input type=”file” name=”file” accept=”.*”>“` Read More
Creating a Hyperlink to Trigger Conditional Formatting
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA?
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA? Read More
Copy data task in pipeline gives error “InternalServerError executing request”
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it?
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it? Read More
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Attention Azure users!
This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.
Both will be discontinued on August 31, 2024.
To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date.
Why the Change?
Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:
Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process.
Taking Action: Migrate to Azure Update Manager
To avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition:
Move from Automation Update Management to Azure Update Manager
https://learn.microsoft.com/en-us/azure/automation/update-management/overview
This guide details the migration process, ensuring a smooth transfer to the new platform.
Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent.
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement Attention Azure users!This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.Both will be discontinued on August 31, 2024.To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date. Why the Change?Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process. Taking Action: Migrate to Azure Update ManagerTo avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition: Move from Automation Update Management to Azure Update Managerhttps://learn.microsoft.com/en-us/azure/automation/update-management/overviewThis guide details the migration process, ensuring a smooth transfer to the new platform. Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent. Read More
RETIREMENT ANNOUCEMENT: AZ-1001: Deploy and manage containers using Azure Kubernetes Service
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
Combining Excel Files
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.
Each file contains different data but the headers in bold are the same.
I tried to combine these using power query but came across 2 main issues and didnt get very far:
1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder)
2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows.
Can anybody please advise me the best solution here?
(I am using a mac and will receive new data every month)
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.Each file contains different data but the headers in bold are the same. I tried to combine these using power query but came across 2 main issues and didnt get very far:1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder) 2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows. Can anybody please advise me the best solution here? (I am using a mac and will receive new data every month) Read More
generate a list of instances
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much!
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much! Read More
MS List no space for unique value
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:
Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique value
Does anyone know what is happening and/or has a solution?
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique valueDoes anyone know what is happening and/or has a solution? Read More
Help! – Excel formatting shifts columns after filtering
Hello,
I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal.
Hello, I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal. Read More
SharePoint Online – How can I add managed properties to search results?
Dear Ladies and Gentlemen,
How can I add managed properties to search results in SharePoint Online?
I have some crawled properties matched with manged properties and also with refinable properties like RefinableString01.
I have also created custom search result page.
I have also updated the CustomString.js file like that:
But how ca I add these properties to the results of the search. So that these values will be displayed with the information about documents like title and URL address?
In the SharePoint Server it was possible to do.
Thank you
Ladislav Stupak
Dear Ladies and Gentlemen, How can I add managed properties to search results in SharePoint Online? I have some crawled properties matched with manged properties and also with refinable properties like RefinableString01. I have also created custom search result page. I have also updated the CustomString.js file like that: // Add your custom localized strings and then include these string dictionaries in your display templates using the $includeLanguageScript function $registerResourceDictionary(“en-us”, { “sampleCustomStringId”: “Sample custom string”, “rf_RefinementTitle_ManagedPropertyName”: “Sample Refinement Title for ManagedPropertyName”,”rf_RefinementTitle_RefinableString01″: “Document ID”,”rf_RefinementTitle_RefinableString02″: “Document ID URL”,”rf_RefinementTitle_RefinableString03″: “Project Name” }); But how ca I add these properties to the results of the search. So that these values will be displayed with the information about documents like title and URL address? In the SharePoint Server it was possible to do. Thank youLadislav Stupak Read More