Tag Archives: microsoft
VBA to save a xlsm as an xlsx
I have the following macro which I now want to save the file as a .xlsx file type rather than a macro-enabled workbook.
I’ve tried various permutations and nothing has changed the file type!
Is anyone able to help please?
PS It would also be great if it didn’t give the warning that the macros will no longer work!
Sheets(“Control Sheet”).Select
Range(“d5”).Copy
Range(“e5”).PasteSpecial Paste:=xlPasteValues
Dim fPath
Dim fName
With Application.FileDialog(msoFileDialogFolderPicker)
If .Show = True Then
fPath = .SelectedItems(1) & “”
fName = fPath & Range(“e5”).Value & “.xls”
Call MsgBox(fName, vbInformation, “Save Path”)
ThisWorkbook.SaveAs Filename:=fName
Range(“e5”).Select
Selection.ClearContents
Range(“c5”).Select
Sheets(“Preparer”).Select
Range(“c13”).Select
End If
End With
End Sub
I have the following macro which I now want to save the file as a .xlsx file type rather than a macro-enabled workbook.I’ve tried various permutations and nothing has changed the file type!Is anyone able to help please?PS It would also be great if it didn’t give the warning that the macros will no longer work!Sheets(“Control Sheet”).SelectRange(“d5”).CopyRange(“e5”).PasteSpecial Paste:=xlPasteValuesDim fPathDim fNameWith Application.FileDialog(msoFileDialogFolderPicker)If .Show = True ThenfPath = .SelectedItems(1) & “”fName = fPath & Range(“e5”).Value & “.xls”Call MsgBox(fName, vbInformation, “Save Path”)ThisWorkbook.SaveAs Filename:=fNameRange(“e5”).SelectSelection.ClearContentsRange(“c5”).SelectSheets(“Preparer”).SelectRange(“c13”).SelectEnd IfEnd WithEnd Sub Read More
VBA to save a xlsm as an xlsm
I have the following macro which I now want to save the file as a .xlsm file type rather than an xls
I’ve tried various permutations and nothing has changed the file type!
Is anyone able to help please?
Sheets(“Control Sheet”).Select
Range(“d5”).Copy
Range(“e5”).PasteSpecial Paste:=xlPasteValues
Dim fPath
Dim fName
With Application.FileDialog(msoFileDialogFolderPicker)
If .Show = True Then
fPath = .SelectedItems(1) & “”
fName = fPath & Range(“e5”).Value & “.xls”
Call MsgBox(fName, vbInformation, “Save Path”)
ThisWorkbook.SaveAs Filename:=fName
Range(“e5”).Select
Selection.ClearContents
Range(“c5”).Select
Sheets(“Preparer”).Select
Range(“c13”).Select
End If
End With
End Sub
I have the following macro which I now want to save the file as a .xlsm file type rather than an xls I’ve tried various permutations and nothing has changed the file type! Is anyone able to help please? Sheets(“Control Sheet”).SelectRange(“d5”).CopyRange(“e5”).PasteSpecial Paste:=xlPasteValuesDim fPathDim fNameWith Application.FileDialog(msoFileDialogFolderPicker)If .Show = True ThenfPath = .SelectedItems(1) & “”fName = fPath & Range(“e5”).Value & “.xls”Call MsgBox(fName, vbInformation, “Save Path”)ThisWorkbook.SaveAs Filename:=fNameRange(“e5”).SelectSelection.ClearContentsRange(“c5”).SelectSheets(“Preparer”).SelectRange(“c13”).SelectEnd IfEnd WithEnd Sub Read More
Complex (for me!) lookup formula – help please….
I need an Excel formula to return a lookup value based on date. The lookup dates and values (exchange rates for each date) are arranged in two columns per year.
More detail in this sample spreadsheet.
Can anyone help?
Thank you in advance!
I need an Excel formula to return a lookup value based on date. The lookup dates and values (exchange rates for each date) are arranged in two columns per year.More detail in this sample spreadsheet. Can anyone help? Thank you in advance! Read More
Top Stories: May 28, 2024
News and events you don’t want to miss.
English Top Stories: May 28, 2024 | Microsoft
Français À la une : 28 mai 2024 | Microsoft
Español Novedades más relevantes: 28 de mayo de 2024 | Microsoft
Português Notícias principais: 28 de maio de 2024 | Microsoft
News and events you don’t want to miss.
English Top Stories: May 28, 2024 | Microsoft
Français À la une : 28 mai 2024 | Microsoft
Español Novedades más relevantes: 28 de mayo de 2024 | Microsoft
Português Notícias principais: 28 de maio de 2024 | Microsoft Read More
Cannot transfer schema using NTDSUTIL
When trying to transfer operational control to a new A/D server, I tried to use the GUI but it would not show the new A/D. I found a note which indicated to use NTDSUTIL to perform the task. When issueing the commands:
roles
connections
connect to server dc1 – put the target DC server’s name here
quit
transfer infrastructure master
transfer naming master
transfer pdc
transfer rid master
transfer schema master
quit
quit
Everything appears to be fine, however, when I issue the netdom query fsmo, all of the roles refer to the new server, but the Schema Master still points to the existing A/D server. I am part of the schema admin group but I don’t know what else to do except maybe to use the Seize option which appears to be a last resort. What other settings should I look for?
When trying to transfer operational control to a new A/D server, I tried to use the GUI but it would not show the new A/D. I found a note which indicated to use NTDSUTIL to perform the task. When issueing the commands:rolesconnectionsconnect to server dc1 – put the target DC server’s name herequittransfer infrastructure mastertransfer naming mastertransfer pdctransfer rid mastertransfer schema masterquitquit Everything appears to be fine, however, when I issue the netdom query fsmo, all of the roles refer to the new server, but the Schema Master still points to the existing A/D server. I am part of the schema admin group but I don’t know what else to do except maybe to use the Seize option which appears to be a last resort. What other settings should I look for? Read More
PROBLEMAS NA ATUALIZAÇÃO DO WINDOWS INSIDER.
//Toda vez que tento atualizar o windows insider da erro
//Chega a baixar e instalar até 100%, mas quando completa, dá erro
//Vários programas e até mesmo a aba de “segurança do windows” não abrem
//Não obtive sucesso em resolver som o suporte também
//Toda vez que tento atualizar o windows insider da erro//Chega a baixar e instalar até 100%, mas quando completa, dá erro//Vários programas e até mesmo a aba de “segurança do windows” não abrem//Não obtive sucesso em resolver som o suporte também Read More
send an attachement file received in forms
Hey pros !
So i’ve been struggling with this.
I have a form with only 5 questions, one of them would be a file upload that is mandatory.
I was able to get it but only with a link to my onedrive and the original name
But what i need is to :
Receive an email with only the file (might be pdf or jpeg or whatever) they have sent in the form
I need it to be named after question #1 and #2.
Sorry its in french
Hey pros !So i’ve been struggling with this. I have a form with only 5 questions, one of them would be a file upload that is mandatory.I was able to get it but only with a link to my onedrive and the original name But what i need is to :Receive an email with only the file (might be pdf or jpeg or whatever) they have sent in the formI need it to be named after question #1 and #2. Sorry its in french Read More
Migrating Mailbox On-premise to the Cloud
Hello
Please i need your help on this issue.
We have over 150 active mailboxes On-Prem which we would like to migrate to the cloud.
Please how do i go about this. Is there any guidance or steps to go about it.
Hello Please i need your help on this issue. We have over 150 active mailboxes On-Prem which we would like to migrate to the cloud.Please how do i go about this. Is there any guidance or steps to go about it. Read More
ATTENTION: Microsoft Learn Update
(Please note: Clicking on this image will provide you with a standard sized view. This update is also uploaded in a PDF format at the bottom of this post. Thank you!)
(Please note: Clicking on this image will provide you with a standard sized view. This update is also uploaded in a PDF format at the bottom of this post. Thank you!) Read More
Excell formula
It has been awhile since i worked on advanced formulas in excel.
I am working on a budget sheet and am having trouble on a formula to sum numbers in column F based on a range of numbers (a week of rows) in column E that can be extended to other rows (drag fill) to get a dollar amount needed for a specific day. This is what i have as of now;
=IF E3:E40,>=H46-1,and<=H46+5,SUM(F3,F40)
E is the due date column in a table
H is the reference date outside the table with the range (minus a day and plus 5 days)
F is the column of numbers in the table i want summed.
So if i put in 15 in cell H, i would like it to sum the numbers in column F that are in the range of 14-20 in column E.
Is it possible to get it to wrap around back to 1 since there are no more than 31 days in a month, rather then the range increasing to 35?
It has been awhile since i worked on advanced formulas in excel.I am working on a budget sheet and am having trouble on a formula to sum numbers in column F based on a range of numbers (a week of rows) in column E that can be extended to other rows (drag fill) to get a dollar amount needed for a specific day. This is what i have as of now;=IF E3:E40,>=H46-1,and<=H46+5,SUM(F3,F40)E is the due date column in a tableH is the reference date outside the table with the range (minus a day and plus 5 days)F is the column of numbers in the table i want summed. So if i put in 15 in cell H, i would like it to sum the numbers in column F that are in the range of 14-20 in column E.Is it possible to get it to wrap around back to 1 since there are no more than 31 days in a month, rather then the range increasing to 35? Read More
Business Applications Partner News: Week of May 28
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK!
May 28 (PDT): Optimizing Business Impact through the Microsoft Commercial Marketplace
May 28-31 (PDT): Accelerate Business Process Automation using Microsoft Power Platform Workshop
May 29: Microsoft AI Training Roadshows (Tokyo, Japan)
May 30: Copilot Studio Partner Opportunity Webinar
Closes May 31: Q4 Microsoft Catalyst Partner Training
Save the date: Join us on July 11 for MCAPS Start for Partners
What to download
Microsoft Build 2024 assets:
What’s new for Copilot Studio – Build 2024
Copilot Studio Agents Vision Deck
ISV Copilot datasheet
Build 2024 ISV quotes
What to review/like/share:
Partner Alert: Microsoft Build
Copilot Studio brings power of generative AI to ISV offerings: LinkedIn post | blog link
Majesco creates AI-driven digital assistant with Copilot Studio: LinkedIn post | blog link
Announcing Partner Center to certify and publish Power Platform Copilot connectors and plugins: LinkedIn | blog link
Directions North America recap: LinkedIn | blog link
Blog: Revolutionize the way you work with automation and AI
What to watch:
Microsoft Build replay
Welcome to the future of automation with AI flows in Power Automate
Automate your desktop with multi-modal AI
Reminders: Register for the upcoming partner events!
Events:
June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Trainings:
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
Level Up Copilot Sales Champion training course (access code: MOKC-MCJB)
FY24 High Volume Acceleration Program (Advanced)
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK!
May 28 (PDT): Optimizing Business Impact through the Microsoft Commercial Marketplace
May 28-31 (PDT): Accelerate Business Process Automation using Microsoft Power Platform Workshop
May 29: Microsoft AI Training Roadshows (Tokyo, Japan)
May 30: Copilot Studio Partner Opportunity Webinar
Closes May 31: Q4 Microsoft Catalyst Partner Training
Save the date: Join us on July 11 for MCAPS Start for Partners
What to download
Microsoft Build 2024 assets:
What’s new for Copilot Studio – Build 2024
Copilot Studio Agents Vision Deck
ISV Copilot datasheet
Build 2024 ISV quotes
What to review/like/share:
Partner Alert: Microsoft Build
Copilot Studio brings power of generative AI to ISV offerings: LinkedIn post | blog link
Majesco creates AI-driven digital assistant with Copilot Studio: LinkedIn post | blog link
Announcing Partner Center to certify and publish Power Platform Copilot connectors and plugins: LinkedIn | blog link
Directions North America recap: LinkedIn | blog link
Blog: Revolutionize the way you work with automation and AI
What to watch:
Microsoft Build replay
Welcome to the future of automation with AI flows in Power Automate
Automate your desktop with multi-modal AI
Reminders: Register for the upcoming partner events!
Events:
June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Trainings:
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
Level Up Copilot Sales Champion training course (access code: MOKC-MCJB)
FY24 High Volume Acceleration Program (Advanced)
Unable to get cells with % Formulas to add up to100% but yet the Sum Total in the cell shows 100%
Example Column Cell K5=SUM(C5,E5,G5,I5)
Then all of Column K is added up with the following formula K31 =SUM(K5:K30)
Column L, rows 5 thru 30 are a % of the rows Total (Cell K31) or the formula of Cell K31 =SUM(K5:K30)
Cell L5=K5/K31 to get a % or 24% This is duplicated for Cells L6 through L30 for a total of 100% in cell L31 but the actual total of the column is only 99%. How can this be corrected so that the numbers are accurate and don’t need to manually add to see if the total is correct. I have had to do manual adjustments to make the numbers add up to the 100%. Your assistance is greatly appreciated.
Example Column Cell K5=SUM(C5,E5,G5,I5)Then all of Column K is added up with the following formula K31 =SUM(K5:K30) Column L, rows 5 thru 30 are a % of the rows Total (Cell K31) or the formula of Cell K31 =SUM(K5:K30)Cell L5=K5/K31 to get a % or 24% This is duplicated for Cells L6 through L30 for a total of 100% in cell L31 but the actual total of the column is only 99%. How can this be corrected so that the numbers are accurate and don’t need to manually add to see if the total is correct. I have had to do manual adjustments to make the numbers add up to the 100%. Your assistance is greatly appreciated. Read More
Owner of Teams Channel not showing in Teams Channel Distribution List
I requested for a new Team’s Channel be created that includes a distribution list. The distribution list works great – as soon as I add or remove people from the channel, the distribution list is updated. Exactly what I wanted, except for one thing – I’m not included in the distribution list. So if someone else uses the distribution list for communication, I do not receive the email. Is there a way to resolve this?
I requested for a new Team’s Channel be created that includes a distribution list. The distribution list works great – as soon as I add or remove people from the channel, the distribution list is updated. Exactly what I wanted, except for one thing – I’m not included in the distribution list. So if someone else uses the distribution list for communication, I do not receive the email. Is there a way to resolve this? Read More
message available that a new version is available in Windows Update but windows update doesn’t show
On windows 11 I have a message available that a new version is available in Windows Update in Insider menu. When I check for the update, it says that there are no updates.
I have tried most steps shown on online:
1. Rejoining Windows Insider Preview
2.cmd: bcdedit /set flightsigning on
3. Deleting: HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsSelfHost
4. Clean Installation of windows 11
Info:
Insider: Release Preview
Current OS build: 22631.3668
Edition: Windows 11 Pro
On windows 11 I have a message available that a new version is available in Windows Update in Insider menu. When I check for the update, it says that there are no updates.I have tried most steps shown on online:1. Rejoining Windows Insider Preview2.cmd: bcdedit /set flightsigning on3. Deleting: HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsSelfHost4. Clean Installation of windows 11Info:Insider: Release PreviewCurrent OS build: 22631.3668Edition: Windows 11 Pro Read More
Tenant allow/block list and Exchange rules – order of execution
I’ve just been trying to reduce all the emails from a particularly large global spam bot which hit my tenant daily and aren’t being picked up automatically as SPAM by the service. The bot uses many different individual email mailboxes, on many different (real) domains, registered in many countries (including European countries) – and the domains only seem to make it onto the occasional blacklist. The mail server IPs seem to be Russian ISPs , but several of those too. So it has been difficult to stop but I’m pretty much there as there is only a small variation in the content.
In the process of dealing with it, I have noticed that Exchange rules I have defined appear to take precedence over domain entries in the tenant allow/block list, where I expected it to be the other way around. i.e I expected the TABL would be checked before anything else.
e.g. I have a particular domain listed in the TABL because I want to block anything/everything from it as it is actually the predominant domain spamming us, and an Exchange rule that just looks for content rather than the source to catch all the other domains that are sending out the exact same junk. The other day, my rule caught an email from the domain based on content, and it is clear the TABL had not had an activation against it.
Is my understanding correct, and if so, is there something somewhere that describes how the various components of 365 act on incoming messages and in what order – kinda like a flow chart? I’ve had a look and can’t find anything.
Thanks!
I’ve just been trying to reduce all the emails from a particularly large global spam bot which hit my tenant daily and aren’t being picked up automatically as SPAM by the service. The bot uses many different individual email mailboxes, on many different (real) domains, registered in many countries (including European countries) – and the domains only seem to make it onto the occasional blacklist. The mail server IPs seem to be Russian ISPs , but several of those too. So it has been difficult to stop but I’m pretty much there as there is only a small variation in the content. In the process of dealing with it, I have noticed that Exchange rules I have defined appear to take precedence over domain entries in the tenant allow/block list, where I expected it to be the other way around. i.e I expected the TABL would be checked before anything else. e.g. I have a particular domain listed in the TABL because I want to block anything/everything from it as it is actually the predominant domain spamming us, and an Exchange rule that just looks for content rather than the source to catch all the other domains that are sending out the exact same junk. The other day, my rule caught an email from the domain based on content, and it is clear the TABL had not had an activation against it. Is my understanding correct, and if so, is there something somewhere that describes how the various components of 365 act on incoming messages and in what order – kinda like a flow chart? I’ve had a look and can’t find anything. Thanks! Read More
Formulas and Functions
Hello,
I would like to know if it is possible to create a formula in a spreadsheet based on data from another spreadsheet without having to copy or re-enter the data?
Thank you in advance for your reply,
Maëlle
Hello,I would like to know if it is possible to create a formula in a spreadsheet based on data from another spreadsheet without having to copy or re-enter the data?Thank you in advance for your reply,Maëlle Read More
🌟 Microsoft Partner Community Update: Empowering Your Success 🌟
Dear Partners,
Thank you for joining today’s Partner Townhall, covering a dynamic convergence of insights, collaboration, and strategic vision on Microsoft Build and Partner Enablement.
Mark Your Calendars for the upcoming exciting events:
Digital Kickoff (July 11th): An electrifying start to the new fiscal year. More information is available here.
Partner of the Year Awards (Geneva: July 15th, Zurich: July 18th): Celebrate excellence. Registration details coming soon.
Microsoft Ignite (Nov. 18-22, 2024) in Chicago and online: Our biggest event of the year is getting even bigger.
Recording Available: If you missed today’s Townhall, don’t worry. Catch the recording on our community platform. Dive into the discussions, gain fresh perspectives, and stay informed.
Sign Up for Future Townhalls: The journey continues. Visit the Cloud Champion platform, establish your account, and be part of the next wave of insights. Our next Townhall awaits on June 27th. :spiral_calendar:️
Provide feedback: Your insights matter! We’re conducting a brief survey to enhance our Partner Townhalls. Share your thoughts, ideas, and suggestions—it’s your chance to shape the future of these engaging sessions.
Let’s amplify our collective impact. Share your takeaways, connect with fellow partners, and gear up for what’s next. Together, we thrive!
Microsoft Switzerland Partner Team
Dear Partners,
Thank you for joining today’s Partner Townhall, covering a dynamic convergence of insights, collaboration, and strategic vision on Microsoft Build and Partner Enablement.
Mark Your Calendars for the upcoming exciting events:
Digital Kickoff (July 11th): An electrifying start to the new fiscal year. More information is available here.
Partner of the Year Awards (Geneva: July 15th, Zurich: July 18th): Celebrate excellence. Registration details coming soon.
Microsoft Ignite (Nov. 18-22, 2024) in Chicago and online: Our biggest event of the year is getting even bigger.
Recording Available: If you missed today’s Townhall, don’t worry. Catch the recording on our community platform. Dive into the discussions, gain fresh perspectives, and stay informed.
Sign Up for Future Townhalls: The journey continues. Visit the Cloud Champion platform, establish your account, and be part of the next wave of insights. Our next Townhall awaits on June 27th. :spiral_calendar:️
Provide feedback: Your insights matter! We’re conducting a brief survey to enhance our Partner Townhalls. Share your thoughts, ideas, and suggestions—it’s your chance to shape the future of these engaging sessions.
Let’s amplify our collective impact. Share your takeaways, connect with fellow partners, and gear up for what’s next. Together, we thrive!
Microsoft Switzerland Partner Team Read More
Lesson Learned #496:Verifying Network Route to Azure SQL Database via VPN in Windows
Today, I worked on a service request where our customer was using a VPN, but the network routes seemed to indicate it was not working and was using the ISP IP instead of the VPN IP.
I found that can be challenging to verify whether your connection is indeed passing through the VPN or directly via your ISP. In this article, I would like to share my lessons learned to determine which route your connection to Azure SQL Database is taking using PowerShell in Windows.
First, running in PowerShell ping servername.database.windows.net we are going to have the IP address of gateway. Remember, that Azure gateway might be more than 1 IPs.
ping servername.database.windows.net
The output will display the IP address of your Azure SQL Database (example).
Pinging servername.database.windows.net [1.1.1.0] with 32 bytes of data:
With the IP address in hand, I can now use the Find-NetRoute cmdlet to determine the route the system is using to connect to the Azure SQL Database.
Execute the following command, replacing 1.1.1.0 with the IP address obtained. This command will output details about the route being used, including the interface and the next hop.
The output will include several important fields:
InterfaceIndex: The index of the network interface used for the connection.
DestinationPrefix: The destination prefix for the route.
NextHop: The next hop in the route (which could be the gateway of your VPN or your ISP).
RouteMetric: The metric of the route.
InterfaceAlias: The alias of the interface used.
IPAddress: will be the IP address of ISP or VPN.
Example:
IPAddress : 100.x.x.x
InterfaceIndex : 91
InterfaceAlias : MyVPN
AddressFamily : IPv4
Type : Unicast
PrefixLength : 32
PrefixOrigin : Other
SuffixOrigin : Other
AddressState : Preferred
ValidLifetime :
PreferredLifetime :
Microsoft Tech Community – Latest Blogs –Read More
Secure Model Deployments with Microsoft Entra and Managed Online Endpoints
Introduction
Microsoft Entra ID token-based auth mode for managed online endpoints in Azure Machine Learning is now generally available. This new auth mode makes identity and access management easier when using models hosted on Azure.
Plus, to deploy models securely and efficiently, Azure Machine Learning offers another great feature: managed online endpoints. In this blog, we’ll see how Microsoft Entra ID helps with endpoint authentication/authorization, and learn some important concepts about Azure Machine Learning managed online endpoints and how to use them with Microsoft Entra ID.
Managed Online Endpoints: A Turnkey Solution to simplify deployments
Managed online endpoints are designed to simplify machine learning model deployment. Here are some benefits:
Flexibility: Deploy models with no-code, low-code, or full code options
Scalability: Handle high request volumes and expand to hundreds of nodes
Cost Optimization: Autoscaling and cost monitoring for individual models
DevOps Efficiency: GitOps-friendly interfaces, local testing, and safe model rollouts
Security Compliance: Secure authentication, network isolation, and managed identity
Infrastructure Management : Reduce infrastructure complexity
Both Azure AI Studio and Azure Machine Learning use managed online endpoints to improve model deployment experiences.
Key concepts: Endpoints and deployments
Managed online endpoints decouple the concepts of endpoints and deployments.
Endpoint: A logical entity that represents a service or API where you can send requests for inferencing. It acts as the entry point for your machine learning models.
Deployment: A set of resources and logic required for hosting the actual model that performs inferencing. It includes the necessary infrastructure, such as CPU or GPU machines, the environment, and the inferencing logic to consume the models.
When you deploy a model, you create a deployment behind an endpoint. This deployment contains the model, any custom code, and other dependencies.
A key benefit of this separation is that it decouples the interface presented to clients (the endpoint) from the implementation details (the deployment). This separation allows you to manage deployments independently without affecting the overall endpoint. For example, you can use this to maintain multiple deployments for multiple model versions under a single endpoint, or to safely roll out new model versions without downtime.
Key concepts: Control plane operation vs data plane operation
Control plane operations
These operations manage and modify the online endpoints. They involve creating, reading, updating, and deleting online endpoints and deployments. They send requests to the Azure Machine Learning workspace.
To authenticate, you need a Microsoft Entra token. To authorize, you need Azure RBAC action for Microsoft.MachineLearningServices/workspaces/onlineEndpoints/write, delete, and read. We’ll see what this means later.
Data plane operations
These operations do not change the online endpoints, but use data to work with them. For example, sending a scoring request to an online endpoint and getting a response. They send requests to the endpoint’s scoring URI.
To authenticate, you can use a key, Microsoft Entra token, or Azure Machine Learning token. You specify which mechanism to use by choosing `auth_mode` when creating a managed online endpoint. If you choose Microsoft Entra to authorize, you need Azure RBAC action for Microsoft.MachineLearningServices/workspaces/onlineEndpoints/score/action.
What’s new about this? Data plane operations for online endpoint now supports Microsoft Entra token for full RBAC authorization.
Why Microsoft Entra ID is useful
Consume multiple endpoints using a single token with full RBAC support
Key auth endpoints have two keys for each endpoint, which may complicate integration with applications when you have many endpoints. Microsoft Entra ID lets you use one token for many endpoints, by giving the right role to a bigger scope you pick. For example, if the IT admin gives a group of Azure identities the right role for data plane actions over a resource group, those Azure identities can call all the endpoints in the resource group.
Streamline control plane and data plane operations
Expanding from the above scenario, if the group of Azure identities are assigned the proper role for both control plane and data plane operations over the scope of a subscription, the Azure identities will be able to not only create/update/delete/read the endpoints and deployments and but also invoke the endpoints in the subscription. You can adjust the RBAC actions and the scope as needed.
Seeing it in action
You don’t need tokens if you sign in and use CLI/SDK/UI. They manage them for you. But you can also choose to do it yourself, if you use REST API with endpoints. We use CLI to keep it simple in this blog. We assume you have set up:
Azure AI hub / project or Azure Machine Learning workspace
Development environment where you have set up CLI and ml extension, or a cloud-based setting that is already prepared for you, such as Compute Instance, Visual Studio Code for Web, or Azure Cloud Shell
1. Create the endpoint and the deployment
Suppose you want to deploy an LLM model for a chat completion scenario. You’ll want to create an endpoint and a deployment. Earlier, we saw that this is a control plane operation. First things first, you would sign into Azure.
az login
Once signed in, the authentication is done and the CLI session will run on your Azure identity. When you perform an operation, the CLI will interact with the backend services (via REST APIs) and backend services will check authorization if the operation is permitted for your Azure identity.
Note that the IT admin with the permission of `Microsoft.Authorization/roleAssignments/write` will be able to assign the proper role for an operation to your Azure identity, if it isn’t already assigned such a role.
Now suppose your definitions of the endpoint and deployment for your LLM model are defined as YAML files. Especially your endpoint definition YAML will look like:
$schema: https://azuremlschemas.azureedge.net/latest/managedOnlineEndpoint.schema.json
name: my-endp1
auth_mode: aad_token
You can run the following commands to create the endpoint and the deployment:
az ml online-endpoint create -n my-endp1 -f ./endpoint.yaml
az ml online-deployment create -n blue -e my-endp1 -f ./deployment.yaml
The above two CLI commands send the requests to the Azure AI Studio hub or Azure Machine Learning workspace, and if your Azure identity has the permission to create them (more specifically, if your Azure identity is assigned an Azure role with ` Microsoft.MachineLearningServices/workspaces/onlineEndpoints/write` action over the scope of the Azure AI hub or Azure Machine Learning workspace resource), the creation requests will be processed.
NOTE
If you’re using REST API to create endpoints and deployments, you’ll need to get the Microsoft Entra token from the resource endpoint https://management.azure.com and pass it in the header. More on this at Get the Microsoft Entra token for control plane operations.
2. Invoke the endpoint
Now it’s time to consume the model. As mentioned earlier, this is a data plane operation.
You can formulate a request file that has the expected payload that the model expects, for example, a JSON input including input text, chat history, and/or parameters such as max response, temperature etc. Then you can run the following command to invoke the endpoint:
az ml online-endpoint invoke -n my-endp1 -r ./request.json
The CLI command will send the request to the scoring URI of the endpoint, and if your Azure identity has the permission to invoke the endpoint (more specifically, if your Azure identity is assigned an Azure role with ` Microsoft.MachineLearningServices/workspaces/onlineEndpoints/score/action` action over the scope of the managed online endpoint resource), the invoke request will be processed.
NOTE
If you’re using REST API to invoke endpoints, you’ll need to get Microsoft Entra token from resource endpoint https://ml.azure.com and pass it in the header. More on this at Get the key or token for data plane operations.
Conclusion
Azure Machine Learning managed online endpoints, combined with Microsoft Entra ID, provide a seamless and secure way to deploy and consume your AI/ML models. By leveraging these features, you can focus on delivering value to your organization without worrying about infrastructure complexities.
Learn more
What are online endpoints? – Azure Machine Learning
Deploy machine learning models to online endpoints for inference – Azure Machine Learning | Microsoft Learn
Authentication for managed online endpoints – Azure Machine Learning | Microsoft Learn
Authenticate clients for online endpoints – Azure Machine Learning | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More