Category: Microsoft
Category Archives: Microsoft
Uploading a Spreadsheet to One Drive
I’m having difficulty storing a spread sheet in One Drive.
The drop down says to simply “Upload the Spread Sheet”. But it doesn’t say how….
Thanks in advance!
I’m having difficulty storing a spread sheet in One Drive.The drop down says to simply “Upload the Spread Sheet”. But it doesn’t say how…. Thanks in advance! Read More
Turning off an Excel feature accidentally activated
I accidentally activated an Excel feature which causes the following result: When I move my cursor from the activated cell to another location on the page, the feature creates a large grey square the stretches from the original activated cell to the new location of the cursor. How do I turn this feature off?
(Because my files are automatically saved to OneDrive, I cannot get rid of this feature.)
Jimbo2024
I accidentally activated an Excel feature which causes the following result: When I move my cursor from the activated cell to another location on the page, the feature creates a large grey square the stretches from the original activated cell to the new location of the cursor. How do I turn this feature off? (Because my files are automatically saved to OneDrive, I cannot get rid of this feature.) Jimbo2024 Read More
mailto goes to old version of Outlook instead of new Outlook
After reinstalling a new computer, I installed Office 365 with the new Outlook. In Apps, mail, the mailto is default to “new Outlook”. If I open Paint and make a small drawing, and click on “send” it opens the older version of Outlook 2016 (or the old version of Oulook 365) instead of the new Outlook. I can see that there is the “File” option on the upper left, and there is no button (to choose). on the top right indicating that it’s the new Outlook. If I open the new Outlook directly, everything is OK. But If I try to send an email directly from any app (even Excel 365 or Word 465), it will go to the older version. The older version was never installed on the C: drive, but it exist on a D: backup drive, but was never installed as such. I deleted the Microsoft Office folder on the backup drive and I still have the same issue. Any Idea?
After reinstalling a new computer, I installed Office 365 with the new Outlook. In Apps, mail, the mailto is default to “new Outlook”. If I open Paint and make a small drawing, and click on “send” it opens the older version of Outlook 2016 (or the old version of Oulook 365) instead of the new Outlook. I can see that there is the “File” option on the upper left, and there is no button (to choose). on the top right indicating that it’s the new Outlook. If I open the new Outlook directly, everything is OK. But If I try to send an email directly from any app (even Excel 365 or Word 465), it will go to the older version. The older version was never installed on the C: drive, but it exist on a D: backup drive, but was never installed as such. I deleted the Microsoft Office folder on the backup drive and I still have the same issue. Any Idea? Read More
Alert Correlation and Linking
Hey team,
As a context, I haven’t been around Sentinel in about 1.5 years.I am trying to see how I can end up correlating different alerts/incidents in Sentinel based on entities. Eg. assume a scenario where, based upon some custom logs, I have 3 different scheduled rules popping. Between those 3 rules triggered, there is some commonality. Eg. all came from the same user / same IP, whatever.I am trying to see what is the way in Sentinel to show this correlation/story and going from individual alert triage to something cohesive that correlates everything.
I am seeing the Fusion rule theoretically supports custom scheduled rules in Sentinel for correlation.Any idea on how I could test fire that to show-case it? I’ve tried with 2 custom alerts, entities mapped, mitre, etc but it didn’t trigger.Is there any other way to achieve what I was mentioning? Is there some notebook or something that performs this kind of correlation between alerts that I am not aware of?
Thank you.
Hey team,As a context, I haven’t been around Sentinel in about 1.5 years.I am trying to see how I can end up correlating different alerts/incidents in Sentinel based on entities. Eg. assume a scenario where, based upon some custom logs, I have 3 different scheduled rules popping. Between those 3 rules triggered, there is some commonality. Eg. all came from the same user / same IP, whatever.I am trying to see what is the way in Sentinel to show this correlation/story and going from individual alert triage to something cohesive that correlates everything. I am seeing the Fusion rule theoretically supports custom scheduled rules in Sentinel for correlation.Any idea on how I could test fire that to show-case it? I’ve tried with 2 custom alerts, entities mapped, mitre, etc but it didn’t trigger.Is there any other way to achieve what I was mentioning? Is there some notebook or something that performs this kind of correlation between alerts that I am not aware of? Thank you. Read More
Kql query
I am trying to explore file creation events where the query should check for file creation events in a folder. The query should catch if there are two files created in the same folder and files names starts with same name before first dot and one filename endswith .exe and other one endswith .exe.config
I am trying to explore file creation events where the query should check for file creation events in a folder. The query should catch if there are two files created in the same folder and files names starts with same name before first dot and one filename endswith .exe and other one endswith .exe.config Read More
Excel what-if Price sensitivity table not working
I am trying to conduct a price sensitivity analysis in excel. The project is to calculate how much do I need to save to repay student loan. So my sensitivity table consists of 2 variables: (i) future salary and (ii) my saving ratio after deducting necessary expenses, and the output was my monthly net repayment to student debt.
However, the monthly net repayment to student loan in the sensitivty table is negative, and I clearly don’t figure out where I go wrong after checking tons of youtube videos.
Do someone know how to solve this? Thank you very much!
Financial planning – student loan.xlsx
I am trying to conduct a price sensitivity analysis in excel. The project is to calculate how much do I need to save to repay student loan. So my sensitivity table consists of 2 variables: (i) future salary and (ii) my saving ratio after deducting necessary expenses, and the output was my monthly net repayment to student debt. However, the monthly net repayment to student loan in the sensitivty table is negative, and I clearly don’t figure out where I go wrong after checking tons of youtube videos. Do someone know how to solve this? Thank you very much! Financial planning – student loan.xlsx Read More
Samsung galaxy: outlook.com account not showing up in Settings – Manage accounts
I just upgraded from S20+ to S24+. I use Outlook with an outlook.com account.
These are set up and work fine, but when I go to Settings – Accounts and Backup – Manage accounts, I don’t see outlook.com at all. I see only gmail.
I added a second email (also outlook.com) to the Outlook app. That didn’t show up either. In the outlook app I cannot remove either, I can only reorder.
How do I make it show up? It is annoying because i use the Calendar widget, and I want to select the outlook.com (so it shows all the categories, colors etc) and I cannot, because it is not giving me outlook.com as an account to choose.
This worked fine in S20.
I just upgraded from S20+ to S24+. I use Outlook with an outlook.com account.These are set up and work fine, but when I go to Settings – Accounts and Backup – Manage accounts, I don’t see outlook.com at all. I see only gmail.I added a second email (also outlook.com) to the Outlook app. That didn’t show up either. In the outlook app I cannot remove either, I can only reorder.How do I make it show up? It is annoying because i use the Calendar widget, and I want to select the outlook.com (so it shows all the categories, colors etc) and I cannot, because it is not giving me outlook.com as an account to choose.This worked fine in S20. Read More
problem with the manage device section`
hello guys i am having problem with the manage device section it is supposed to show USE AS A CONNECTED CAMERA but sadly the whole option is unavailable. I tried everything I know such as:
1. Reinstalling phone link and link to windows in my devices (I mean I have an android phone)
2. Granting all required permissions including camera on my android phone
3. reinstalling cross device experience host in windows
i have an HP laptop which exceeds windows system requirements and an android 11 device
I have shown only one device because all of them show the same thing
PLEASE HELP ME OUT THANK YOU VERY MUCH
hello guys i am having problem with the manage device section it is supposed to show USE AS A CONNECTED CAMERA but sadly the whole option is unavailable. I tried everything I know such as:1. Reinstalling phone link and link to windows in my devices (I mean I have an android phone)2. Granting all required permissions including camera on my android phone3. reinstalling cross device experience host in windows i have an HP laptop which exceeds windows system requirements and an android 11 device I have shown only one device because all of them show the same thingPLEASE HELP ME OUT THANK YOU VERY MUCH Read More
Missing msiserver Win 11 Home
I need msiserver to install a particular application. How do I get it?
I need msiserver to install a particular application. How do I get it? Read More
Autosave with office 2019 is not working with one drive.
Hello
Please i need your help on this issue.
We have a user who has office professional 2019 installed on her computer.
She is using the desktop version of office professional 2019 but whenever she wants to save to OneDrive autosave is not working.
Hello Please i need your help on this issue. We have a user who has office professional 2019 installed on her computer. She is using the desktop version of office professional 2019 but whenever she wants to save to OneDrive autosave is not working. Read More
Learn Azure Site to Site VPN On-Premises to Azure
many organizations have started to adopt a hybrid approach, where they maintain a mix of on-premises and cloud resources. Microsoft Azure’s Site-to-Site VPN is a powerful solution that enables secure and seamless connectivity between your on-premises network and an Azure Virtual Network (VNet).
Azure Site-to-Site VPN and the steps to set it up.
What is Azure Site-to-Site VPN?
Azure Site-to-Site VPN is a service that allows you to create a secure and private connection between your on-premises network and an Azure VNet over an encrypted IPsec/IKE (IKEv1 or IKEv2) VPN tunnel. This connection allows your on-premises resources to communicate with Azure resources as if they were part of the same local network.
Prerequisites
To establish a Site-to-Site VPN connection in Azure, you need the following:
An Azure Virtual Network (VNet) with a defined address space.
A compatible VPN device on-premises with a public IP address.
A Local Network Gateway representing your on-premises network.
A Virtual Network Gateway associated with your Azure VNet.
Complete guide below link
Setup guide how to configure Azure site-to-site VPN on-premise to Azure
many organizations have started to adopt a hybrid approach, where they maintain a mix of on-premises and cloud resources. Microsoft Azure’s Site-to-Site VPN is a powerful solution that enables secure and seamless connectivity between your on-premises network and an Azure Virtual Network (VNet).Azure Site-to-Site VPN and the steps to set it up.What is Azure Site-to-Site VPN?Azure Site-to-Site VPN is a service that allows you to create a secure and private connection between your on-premises network and an Azure VNet over an encrypted IPsec/IKE (IKEv1 or IKEv2) VPN tunnel. This connection allows your on-premises resources to communicate with Azure resources as if they were part of the same local network.PrerequisitesTo establish a Site-to-Site VPN connection in Azure, you need the following:An Azure Virtual Network (VNet) with a defined address space.A compatible VPN device on-premises with a public IP address.A Local Network Gateway representing your on-premises network.A Virtual Network Gateway associated with your Azure VNet.Complete guide below link Setup guide how to configure Azure site-to-site VPN on-premise to Azure Read More
Commulativ Update 05.05.2024
Das kommulative Update wird nicht installiert.
Für mein Betriebsbild 26100.268 existiert noch kein Upgrade. Lediglich für das Betriebsbild 26080. Insofern kann kein Update für Insiderb Preview durchgeführt werden.
Wer kann weiterhelfen?
Das kommulative Update wird nicht installiert.Für mein Betriebsbild 26100.268 existiert noch kein Upgrade. Lediglich für das Betriebsbild 26080. Insofern kann kein Update für Insiderb Preview durchgeführt werden. Wer kann weiterhelfen? Read More
Hyperv node blue screens when rebooting a VM
Im asking here since our MS team cant seem to resolve the problem.
I am responsible for the Linux servers in our organization.
When a VM is rebooted the hyperv node where it lives will blue screen. All the VMs on the node is powered off and started on one of the active nodes.
The node blue screen will only happen once and after the node is up I can reboot VMs at will and hyperv stays happy until I need to reboot a VM a day or more after. This has been a problem since we moved from vmware to hyperv in 2020.
Ive been told we have the latest hardware drivers installed, ie network etc.. We are running on Windows Server 2019. Fully patched.
There are other hyperv clusters in our organization but they only host MS VMs. Our MS team started blaming the Linux guys for the problem but cannot give me any proof or where I can start looking.
On the Linux VMs we have the latest hyperv integration modules installed. What else can I investigate to resolve this problem?
Im asking here since our MS team cant seem to resolve the problem. I am responsible for the Linux servers in our organization.When a VM is rebooted the hyperv node where it lives will blue screen. All the VMs on the node is powered off and started on one of the active nodes.The node blue screen will only happen once and after the node is up I can reboot VMs at will and hyperv stays happy until I need to reboot a VM a day or more after. This has been a problem since we moved from vmware to hyperv in 2020. Ive been told we have the latest hardware drivers installed, ie network etc.. We are running on Windows Server 2019. Fully patched. There are other hyperv clusters in our organization but they only host MS VMs. Our MS team started blaming the Linux guys for the problem but cannot give me any proof or where I can start looking. On the Linux VMs we have the latest hyperv integration modules installed. What else can I investigate to resolve this problem? Read More
Unable to add vulnerability assessment solution (MDVM) to Windows 10 VM
Hello all, as part of transitioning from Qualys vulnerability management solution to built-in MDVM, I have followed steps provided by Microsoft (https://learn.microsoft.com/en-us/azure/defender-for-cloud/how-to-transition-to-built-in) on few of the windows 10 VMs and I could see VMs status as “onboarded” on MDVM portal.
However, I am getting the recommendation “Machines should have a vulnerability assessment solution” in the “Microsoft defender for cloud | Recommendations” section. I tried remediating this issue by applying the fix and choosing the below highlighted option in the portal. Even after applying this fix and waiting for suggested period, the VMs still appear under “unhealthy” section with the same vulnerability.
what could I be missing here? and what is the best way to troubleshoot this issue?
Hello all, as part of transitioning from Qualys vulnerability management solution to built-in MDVM, I have followed steps provided by Microsoft (https://learn.microsoft.com/en-us/azure/defender-for-cloud/how-to-transition-to-built-in) on few of the windows 10 VMs and I could see VMs status as “onboarded” on MDVM portal. However, I am getting the recommendation “Machines should have a vulnerability assessment solution” in the “Microsoft defender for cloud | Recommendations” section. I tried remediating this issue by applying the fix and choosing the below highlighted option in the portal. Even after applying this fix and waiting for suggested period, the VMs still appear under “unhealthy” section with the same vulnerability.what could I be missing here? and what is the best way to troubleshoot this issue? Read More
Automatic Scaling: Azure Web Apps Unleash Their Hidden Potential
Scale your Azure Web App automatically using Azure App Service Automatic Scaling
In this article we will focus on scaling azure web apps and how the new automatic scaling feature of azure app service, which allows it to scale out and in, in response to HTTP web traffic against your web app is a great feature which further enhances cost savings and improves the availability and resiliency of your web application under conditions of load.
We will also try to understand how automatic scaling is different (and at times based on scenarios better) than rule scaling, how to better understand and configure scaling limits and how it impacts scaling of different web applications sharing the same app service plan.
A look at existing options to scale an Azure Web App
Manual scale: This is the simplest form of scaling where you decide on a fixed number of instances that you code needs to execute. This may seem similar to deploying an application to a virtual machine, but it has many advantages such as deploying code only once, no management of underlying hardware and as your needs change you can always change the number of instances running without having to deploy the code again.
Rule based auto scale: This has been the most used scale option on azure web apps. This is further sub classified in two options.
Scale based on a schedule: Let’s say your application is used by your users in a predictable manner, for instance an intranet application used by office employees will most likely see traffic consistently during the working days or a payroll application will see traffic once or twice a month (depending how you get your paycheck) for a period of 3-5 days, customers have traditionally been creating these schedules to scale an application out (and in: let’s forget to scale an application back in) using configurations as shown in example below, which allows the web application to run specific number of instances during the specific period of time during the specified days.
Scale based on a metric: This has been the most advanced and a complex scaling condition to set. It allows you to configure the web application to scale in response to how a metric such as CPU Percentage or Memory Percentage of the underlying existing hosts changes during the load conditions. The way this is configured is how we configure an azure monitor metric alert and in response to it, in addition to firing an optional notification, the platform allows you to automatically scale out or in by adding or removing one or more instances of a fresh worker that can cater to your end user application traffic.
Although it works well but I have seen users having their fair share of challenges while setting this up with the common ones, I have faced, being
Which metric should I use to scale? If your application has adopted message or event-based mechanisms, then it is an even more special case to consider the queue depth etc.
Metrics are always aggregated over a period and if your application sees short bursts of load also referred to a transient spike, chances are high that by the time the scale out logic triggers your application may have already passed its peak demand and the scale out operation may not really help. You can try to keep evaluating your rule on a smaller duration and then match it with a smaller cool down period associated with aggressive scale out (meaning you add more instances quickly) and controlled scale in (meaning you scale back in smaller decrements over a longer duration) to cover for any next transient spike. You will see when you try it that it takes several attempts and good proactive monitoring before you get this balance working and the cost savings are less than optimal with a cohort of users complaining about slow response times often.
You forget to create a scale in rule, and you only realize this at the end of the month when you get your invoice, and you are billed for a much higher number of web app instances than what you had planned for.
Automatic Scaling
With Automatic Scaling, instead of us choosing a metric or configuring a schedule, the app service platform continues to monitor the HTTP traffic as soon as your application starts receiving it. Automatic Scaling periodically checks the /admin/host/ping endpoint along with other health check mechanisms inherent to the platform. These checks are specifically implemented features, with worker health assessments occurring at least once every few seconds. If the system detects increased load on the application, health checks become more frequent. In the event of deteriorating workers’ health and slowing requests, additional instances are requested. Once the load subsides, the platform initiates a review for potential scaling in. This process typically begins approximately 5-10 minutes after the load stops increasing. During scaling in, instances are removed at a maximum rate of one every few seconds to a minute.
As you dig in, you will realize that automatic scaling is very similar to the Elastic Premium plan that was introduced a while back for Azure Function Apps. If you are already familiar with Elastic Premium plans and are using them, then you will find the below section as a refresher to the concepts and you can choose to skip it.
Few terms to understand before we get into more details
Pre-warmed instances: Consider this as an additional buffer worker that is ready to receive your applications traffic at moment’s notice. Using pre-warmed instances helps greatly reduce the time it takes to perform a scale-out operation. The default prewarmed instance count is 1 and, for most scenarios, this value should remain as 1. Currently, it is not possible to modify this setting to a higher number using the portal experience, but you can use the CLI, if you want to play around. Be mindful that you are charged for pre-warmed instances so unless you have tested that the default value of 1 does not work for you, do not change it.
Maximum burst: Number of instances this plan can scale out under load. Value should be greater than or equal to current instances for this plan. This value is set at the level of the app service plan and in case you have multiple app services sharing the same plan and you want to see them scale independently then set the “Maximum scale limit” which is a setting that limits the number of instances a specific app under the app service plan can scale up to. All apps combined under the app service plan will be limited to this maximum burst value.
Maximum scale limit: The maximum number of instances this web app can scale out to. As highlighted in the above point this is the setting which controls how much each individual app in the same app service plan can scale up to in terms of number of instances. If you have only one single web app in the same app service plan, then there is no point in configuring this value.
Load Testing the Metric based scaling vs Automatic Scaling
Web App Setup: The Azure web app is a Linux App Service set to Premium V3 P0V3 and 1 single instance set to the “Always Ready” instance.
The code deployed is the eShopOnWeb solution found on GitHub.
Load Test Setup
Note: Automatic Scaling takes precedence over custom auto scale settings. In case you have configured custom auto scale and want to switch to Automatic Scaling, I suggest you first switch to manual scale and disable the rule scale settings. Then enable and configure automatic scaling. As part of my tests, I observed some random behavior when switching between automatic scaling and rule-based scale with metrics back and forth without moving to manual scaling in between. This is also documented.
Rule based scaling:
As you can see, I configure the web app to scale based on the CpuPercentage metric by an instance count of 1.
As a result of the configuration, we observe a consistent scale out and in during the load testing and the graph is consistent in repeated runs.
Automatic Scaling:
For automatic scale setting shown below
under the same load the observed automatic scaling behavior is captured below along with the request rate and HttpResponseTime observed.
Key observations:
What we are measuring is the maximum of a metric introduced as part of automatic scaling called automatic scaling instance count.
We see the scaling out is very quick as the health checks being performed by the automatic scaling setup are being done continuously and if you read the documentation, it states that as the load increases the health checks become more frequent to keep up with the demand.
Quick scale out ensures that the average response time does not stay at peak for a long time and is quickly brought down and remains consistent around a few ms.
As the load varies the instances keep getting added and removed. The pace at which this happens is not always consistent. This is evident from a different set of graphs showing the automatic scale instance count metric for 2 runs of the same load test.
The scaling in also happens quickly as the load decreases. As per documentation, the in starts to happen 5 minutes after the load reduced but I observed a more aggressive scale in which is much nicer as it helps me keep my costs down.
It is safe to say that with automatic scaling the scale behavior is aggressive.
My test load ran for 20 minutes. Comparing the total time, it takes for the scale operation to happen between the two scenarios, it is essentially 22 minutes approximately in case of automatic scale and 35 minutes in the custom scale with rules.
Based on these observations, it is easy to see how automatic scaling brings function app kind of scaling capabilities to azure web app under the new premium plans. However, do note that both are inherently different implementations internally which is why you cannot share a plan with automatic scaling between a function app and an azure web app.
How to understand the billing with automatic scaling
Let’s use my setup as an example. I have only 1 always ready instance, so this is the instance that I am always being billed at. The platform will keep 1 pre-warmed instance handy.
When I am not running my load tests my web application is idle and the pre-warmed instance does not come in to play and hence there are no charges for the same. The moment my web application starts receiving traffic the pre-warmed instance is allocated and the billing for it starts. This is because I had only 1 always ready instance.
Assume, I had 2 or 3 always ready instances so unless all my existing instances had been activated and were receiving a steady stream of traffic the pre-warmed instance will not be activated and hence not billed.
The speed at which instances are added varies based on the individual application’s load pattern and startup time. The only way to keep track is to continue to monitor the automatic scaling instance count metric which is also used internally to come up with the billing which is done on a per second basis with automatic scaling configured. I found “Max” to be a better aggregation as compared to average for this metric so that you are safe with your cost projections.
Sample monthly cost projection, considering 1 single always ready instance at P0V3 and a maximum of 5 scaled instances running for 300 hours a month in east US = 73.73 + 300*0.101 = 104.03 USD. The actual cost will be less because my application is not peaking at 5 instances consistently (look at the graphs).
Automatic Scaling with multiple web apps in the same plan
To test how well different web applications will scale under the same app service plan, I deployed a simple Hello World template for an asp.net core web application you get in visual studio.
The first thing that you will notice is that the new web application also has the automatic scaling turned out as it is sharing the same app service plan.
To make sure that both apps make good use of the available resources and scale without impacting on the performance of the other app sharing the same plan we need to configure the scale out limit.
I kept that as 2 for the Hello World app and 3 for the eShopOnWeb app with the maximum burst set to 5.
There is nothing that prevents us from setting the maximum scale limit as 5 for both the applications and not even enforcing this limit in which case both the web applications will be competing for the 5 maximum burst instances.
My second sample application is just a simple web page with a 5 second delay so I will not be observing its response times for my analysis.
Running the same load test for both the applications
without limits set for each individual web application
With limits set
Observations
When no limits are set both web applications try to scale to the maximum burst limit set at the level of the app service plan. This causes a bit of a race for the available resources initially but soon the web applications can scale to the number of required instances to meet the demand generated by the load.
The average response time is much lower when no limits are set on individual web applications but when we ran the same load with limits of 2 and 3 instances set respectively the same eShopOnWeb application resulted in a much higher average response time.
In this case the load test was run simultaneously but even when the same test was run with a delay of 5 minutes and no limits were set, the resources were distributed to both the web applications despite the first web application having a lead time to scale to more instances. Based on the one run, I executed in this manner having the first web application scaling out and the instances already in place allowed the second web application to scale even faster but my applications are simple so we should not generalize this.
Final Thoughts
Automatic scaling is a great addition to the azure web application service. Being able to scale a web application against web traffic and not just measured metrics has been an ask from customers for a long time and they can now do so by using this feature.
I have seen a lot of customers looking to containerize their web UI to achieve faster scalability against incoming traffic and with automatic scaling they can leverage the azure web application to host the web UI, while using AKS to host their backend API’s and scale the components independently.
It is quite adept in addressing the common challenges highlighted earlier with rule-based scaling by ensuring that setting up scaling is simple to just a couple of radio buttons and a slider, scale in happens as quickly as possible so that cost is optimized as much as possible.
I am sure this feature will see more improvements in the coming months. While the current concept adapts from how function app premium plans work, it will be great to see if the teams can adapt to scaling features akin to Kubernetes, without making it as complex as Kubernetes.
Ref:
https://learn.microsoft.com/en-us/azure/app-service/manage-automatic-scaling?tabs=azure-portal
https://learn.microsoft.com/en-us/azure/azure-functions/functions-premium-plan?tabs=portal
https://learn.microsoft.com/en-us/azure/azure-monitor/autoscale/autoscale-get-started
Microsoft Tech Community – Latest Blogs –Read More
windows update 24h2 mise à jour mais 2024
Bonjour , quand j ‘exécute windows update pour avour la mise à jour suivante : Windows 11 Insider Preview 10.0.26120.461 (ge_release) ca se télécharge ensuite ca installe et j’ai le message d’erreur suivant :Erreur d’installation – 0x8007371b pouvez-vous m’aider ?merci
Bonjour , quand j ‘exécute windows update pour avour la mise à jour suivante : Windows 11 Insider Preview 10.0.26120.461 (ge_release) ca se télécharge ensuite ca installe et j’ai le message d’erreur suivant :Erreur d’installation – 0x8007371b pouvez-vous m’aider ?merci Read More
Import IOCs to Defender for Endpoint
Good day,
I have been trying to import IOCs to Defender for Endpoint using a csv file.
I used the example of the sample template that is provided but it is giving me errors. Is there any other method that I can use?
Kind regards,
Good day, I have been trying to import IOCs to Defender for Endpoint using a csv file.I used the example of the sample template that is provided but it is giving me errors. Is there any other method that I can use?Kind regards, Read More
Connecting Excel to Power BI Dataset with parameters
Hi there,
I’m trying to connect to a Power BI dataset from Excel and to pass a parameter from a cell or rangename. When I go to the connection settings, the parameter box is greyed out. Is there a way to get around this?
Alternatively, in the DAX code in the Command text box, it currently begins with something like
DEFINE
VAR __DS0FilterTable =
FILTER(KEEPFILTERS(VALUES(‘Data'[OrgID])), ‘Data'[OrgID] = 303)
etc….
I would like to replace 303 with a range name or cell reference.
Thanks!
Hi there,I’m trying to connect to a Power BI dataset from Excel and to pass a parameter from a cell or rangename. When I go to the connection settings, the parameter box is greyed out. Is there a way to get around this?Alternatively, in the DAX code in the Command text box, it currently begins with something like DEFINE
VAR __DS0FilterTable =
FILTER(KEEPFILTERS(VALUES(‘Data'[OrgID])), ‘Data'[OrgID] = 303)
etc…. I would like to replace 303 with a range name or cell reference. Thanks! Read More
Alphabetise help
Everyone has been so helpful on this forum; there are really some true experts. I’m making tracks with Excel but have really hit a stumbling block which seems like it should be an easy fix but I just can’t work it out.
So I’m taking data from Cells B2, O64 on sheet named ‘Remove 0s’
I’m transpose and alphabetising this information into Cells B2, 064 on sheet named ‘Alphabetised’
I’m using the formula
=SORTBY(‘Remove 0s’!B3:O64, ‘Remove 0s’!B3:B64, 1)
I need to cover that range of cells as more data may appear in the other rows up to row 64. As you can see from the picture, it is in ascending order however it has prioritised all of the blank cells first. I need those at the bottom.
Please could someone be so kind as to help me out. It’s hugely appreciated.
Thanks
Graeme
Everyone has been so helpful on this forum; there are really some true experts. I’m making tracks with Excel but have really hit a stumbling block which seems like it should be an easy fix but I just can’t work it out. So I’m taking data from Cells B2, O64 on sheet named ‘Remove 0s’ I’m transpose and alphabetising this information into Cells B2, 064 on sheet named ‘Alphabetised’ I’m using the formula =SORTBY(‘Remove 0s’!B3:O64, ‘Remove 0s’!B3:B64, 1) I need to cover that range of cells as more data may appear in the other rows up to row 64. As you can see from the picture, it is in ascending order however it has prioritised all of the blank cells first. I need those at the bottom. Please could someone be so kind as to help me out. It’s hugely appreciated. ThanksGraeme Read More