Category: Microsoft
Category Archives: Microsoft
Exchange Server minLength > maxLength
Hey,
I’ve recently encountered this strange error in Exchange Server with no online documentation of it except for my own post on spiceworks.
It doesn’t effect mail flow, however I can’t add or remove users, modify certain parts of the database, etc.
Whenever I run `Get-User` or access the mailboxes area of ECP, I get the following error:
[PS] C:Windowssystem32>Get-User
WARNING: An unexpected error has occurred and a Watson dump is being generated: minLength > maxLength
minLength > maxLength
+ CategoryInfo : NotSpecified: (:) [Get-User], ArgumentException
+ FullyQualifiedErrorId : System.ArgumentException,Microsoft.Exchange.Management.RecipientTasks.GetUser
+ PSComputerName : GLTX-EXCH-01.galactix.local
I have tried running a mailbox repair, but it comes back clean. I am utterly confused at why this might not be working.
Upon trying to deploy a secondary Exchange server on my network, I also found that fails too due to this bug.
The HealthCheck tool provided by MS doesn’t return anything out of the ordinary either, adding to my confusion.
Does anyone know how I might resolve this issue?
Hey,I’ve recently encountered this strange error in Exchange Server with no online documentation of it except for my own post on spiceworks.It doesn’t effect mail flow, however I can’t add or remove users, modify certain parts of the database, etc. Whenever I run `Get-User` or access the mailboxes area of ECP, I get the following error:[PS] C:Windowssystem32>Get-User
WARNING: An unexpected error has occurred and a Watson dump is being generated: minLength > maxLength
minLength > maxLength
+ CategoryInfo : NotSpecified: (:) [Get-User], ArgumentException
+ FullyQualifiedErrorId : System.ArgumentException,Microsoft.Exchange.Management.RecipientTasks.GetUser
+ PSComputerName : GLTX-EXCH-01.galactix.local I have tried running a mailbox repair, but it comes back clean. I am utterly confused at why this might not be working. Upon trying to deploy a secondary Exchange server on my network, I also found that fails too due to this bug. The HealthCheck tool provided by MS doesn’t return anything out of the ordinary either, adding to my confusion. Does anyone know how I might resolve this issue? Read More
Excel labs: internal error while processing the request on Mac
Hello to all,
I was working on a new file on Mac testing conditional formatting – I was using Excel Labs to edit formulas without any issues. As the conditional formatting didn’t work as expected, I opened the file under Windows and worked on it. While the conditional formatting worked as expected, I get “internal error while processing the request” when I open the same file on Mac afterwards. I’m not sure what caused it and how to recover from it.
Mac version (insider): Version 16.89 (24073055)
Windows version: Version 2408 Build 16.0.17925.20000 64-bit
Hello to all, I was working on a new file on Mac testing conditional formatting – I was using Excel Labs to edit formulas without any issues. As the conditional formatting didn’t work as expected, I opened the file under Windows and worked on it. While the conditional formatting worked as expected, I get “internal error while processing the request” when I open the same file on Mac afterwards. I’m not sure what caused it and how to recover from it. Mac version (insider): Version 16.89 (24073055)Windows version: Version 2408 Build 16.0.17925.20000 64-bit Read More
Announcing Azure OpenAI Global Batch Offering: Efficient processing at scale with 50% less cost
We are excited to announce the public preview of Azure OpenAI Global Batch offering, designed to handle large-scale and high-volume processing tasks efficiently. Process asynchronous groups of requests with separate quota, with target 24-hour turnaround time, at 50% less cost than global standard.
This is a quote from our customer:
”Ontada is at the unique position of serving providers, patients and life science partners with data-driven insights. We leverage the Azure OpenAI batch API to process tens of millions of unstructured documents efficiently, enhancing our ability to extract valuable clinical information. What would have taken months to process now takes just a week. This significantly improves evidence-based medicine practice and accelerates life science product R&D. Partnering with Microsoft, we are advancing AI-driven oncology research, aiming for breakthroughs in personalized cancer care and drug development.”
Sagran Moodley, Chief Innovation and Technology Officer, Ontada
Why Azure OpenAI Global Batch?
Cost Efficiency: 50% reduction in cost compared to global standard pricing.
Separate Quota: Manage batch requests with an independent enqueued token quota, ensuring that your online workloads are unaffected. Batch quota is substantially high. Learn more.
24-Hour Turnaround: Our aim is to process batch requests within 24 hours, ensuring timely results for your usecases.
Supported Models
The following models currently support the global batch:
Model
Supported Versions
gpt4-o
2024-05-13
gpt-4o-mini
coming soon
gpt-4
turbo-2024-04-09
gpt-4
0613
gpt-35-turbo
0125
gpt-35-turbo
1106
gpt-35-turbo
0613
For the most up-to-date information on regions and models, please refer to our models page.
Key Use Cases
The Azure OpenAI Batch API opens up new possibilities across various industries and applications:
Large-Scale Data Processing: Quickly analyze extensive datasets in parallel, enabling faster decision-making and insights.
Content Generation: Automate the creation of large volumes of text, such as product descriptions, articles, and more.
Document Review and Summarization: Streamline the review and summarization of lengthy documents, saving valuable time and resources.
Customer Support Automation: Enhance customer support by handling numerous queries simultaneously, ensuring faster and more efficient responses.
Data Extraction and Analysis: Extract and analyze information from vast amounts of unstructured data, unlocking valuable insights.
Natural Language Processing (NLP) Tasks: Perform sentiment analysis, translation, and other NLP tasks on large datasets effortlessly.
Marketing and Personalization: Generate personalized content and recommendations at-scale, improving engagement and customer satisfaction.
Getting Started
Ready to try Azure OpenAI Batch API? Take it for a spin here.
Learn more
Using images in your batch input
Default batch token quota allocation and requesting increase
Microsoft Tech Community – Latest Blogs –Read More
Offers/Discounts for Volunteers of Non-Profit
Now that I’ve set up our non-profit organization with Microsoft’s non-profit grant, which includes 10 licenses of Microsoft 365 Business Premium, I’m wondering about what Microsoft 365 discounts are available to volunteers, especially Office software. It’s not clear to me what offers/discounts are available for them.
Can someone advise?
Now that I’ve set up our non-profit organization with Microsoft’s non-profit grant, which includes 10 licenses of Microsoft 365 Business Premium, I’m wondering about what Microsoft 365 discounts are available to volunteers, especially Office software. It’s not clear to me what offers/discounts are available for them.Can someone advise? Read More
[LAPTOP]is it possible to go through BIOS/Safe mode screens using external screen using HDMI cable?
Hello, I am new to this site so tell me if i do something wrong.
I have encountered a problem that has been with me for few years.
Long time ago i broke my laptop screen, and am forced to use external screen since then, using HDMI cable. (only available port on the laptop)
The main broken screen still acts like it is working, but is not usable. external screen is detected as 2nd screen. i successfully set it up to show like a main screen, but it does not work outside of awake system state.
And here is the problem. everything happening in BIOS, recovery screen, Windows update – all stuff that is happening outside of normal running state of the computer is only showing on the main, broken screen. It is incredibly difficult to navigate through menus in this state.
There were cases where magically it would show on external screen but it happened for a very short period of time and did not know the cause. also happened quite a long time ago so i don’t remember too much.
Solution I am looking for is to get external monitor/screen working through HDMI in BIOS and similiar stuff.
Here is some basic information about my device:
-Laptop model: Huawei MateBook D (2019)
-System: Windows 10 Home
I will be happy to cooperate to reach my solution.
Hello, I am new to this site so tell me if i do something wrong. I have encountered a problem that has been with me for few years.Long time ago i broke my laptop screen, and am forced to use external screen since then, using HDMI cable. (only available port on the laptop) The main broken screen still acts like it is working, but is not usable. external screen is detected as 2nd screen. i successfully set it up to show like a main screen, but it does not work outside of awake system state. And here is the problem. everything happening in BIOS, recovery screen, Windows update – all stuff that is happening outside of normal running state of the computer is only showing on the main, broken screen. It is incredibly difficult to navigate through menus in this state. There were cases where magically it would show on external screen but it happened for a very short period of time and did not know the cause. also happened quite a long time ago so i don’t remember too much. Solution I am looking for is to get external monitor/screen working through HDMI in BIOS and similiar stuff. Here is some basic information about my device:-Laptop model: Huawei MateBook D (2019)-System: Windows 10 Home I will be happy to cooperate to reach my solution. Read More
Problema de inicio de sesión de Microsoft Defender an Tablet con Android 13.
Estimados a ver si me pueden ayudar, no logro iniciar sección de Microsoft Defender en mi tablet con Android 13. Tengo una cuenta Family de office 365 la cual si logro iniciar sesión sin problemas pero no asi en microsof defender. El error que me sale dice lo siguiente “Nuestro servicio está fuera de servicio. Vuelva a intentar mas tarde” realicé muchas pruebas borrando cache, reinstalado la app y siempre me da el mismo error. Lo extraño es que el resto del las app de Office 365 funcionan sin problemas. Otro dato yo soy el titular de la cuenta de Office.
Estimados a ver si me pueden ayudar, no logro iniciar sección de Microsoft Defender en mi tablet con Android 13. Tengo una cuenta Family de office 365 la cual si logro iniciar sesión sin problemas pero no asi en microsof defender. El error que me sale dice lo siguiente “Nuestro servicio está fuera de servicio. Vuelva a intentar mas tarde” realicé muchas pruebas borrando cache, reinstalado la app y siempre me da el mismo error. Lo extraño es que el resto del las app de Office 365 funcionan sin problemas. Otro dato yo soy el titular de la cuenta de Office. Read More
[Power Query] PQ Variables linked to named ranges aren’t refreshing with Refresh All
Hi all,
I’m using Power Query to pull data from other Excel files. As the name of these files change every day, I’ve worked around this by using using a cell (named range) and pulling it into Power Query, and using the variable defined there to define the path and file name to get.
Now, one of the problems happen:
1. If I leave the Named Range (Date) with the same name as the Power Query (Date), every time I use the Named Range in a function, Excel automatically changes it to be “_xlpq.Date” resulting in a #CALC! ERROR.
To circumvent this, I changed the names of the variables in Power Query so they would differ from the named ranges.
Great. Now I can use the named ranges without issues.
2. But then I noticed that when I updated the workbook with Refresh All, the Power Query variables linked to the named ranges were /not/ updating. To update them, I had to go to the Power Query editor and refresh the preview one by one.
To be clear, upon changing the PQ variables’ names to match the named ranges, they were updating with Refresh All.
Any help to bypass one issue or the other is welcome. It seems the way forward would be to force Excel to stop updating the formulas with the “_xlpq.” prefix on the shared names, but I don’t see how to do this.
If you think this is an oversight in Excel’s functionalities, how can I share feedback?
Thanks,
J Ruivo
Hi all, I’m using Power Query to pull data from other Excel files. As the name of these files change every day, I’ve worked around this by using using a cell (named range) and pulling it into Power Query, and using the variable defined there to define the path and file name to get. Now, one of the problems happen:1. If I leave the Named Range (Date) with the same name as the Power Query (Date), every time I use the Named Range in a function, Excel automatically changes it to be “_xlpq.Date” resulting in a #CALC! ERROR. To circumvent this, I changed the names of the variables in Power Query so they would differ from the named ranges. Great. Now I can use the named ranges without issues. 2. But then I noticed that when I updated the workbook with Refresh All, the Power Query variables linked to the named ranges were /not/ updating. To update them, I had to go to the Power Query editor and refresh the preview one by one. To be clear, upon changing the PQ variables’ names to match the named ranges, they were updating with Refresh All. Any help to bypass one issue or the other is welcome. It seems the way forward would be to force Excel to stop updating the formulas with the “_xlpq.” prefix on the shared names, but I don’t see how to do this. If you think this is an oversight in Excel’s functionalities, how can I share feedback? Thanks,J Ruivo Read More
Bookings not showing Customer info in Calendar Event Title and in Outlook Calendar
We have set up a bookings page under a shared inbox. When someone books a service, the calendar event is given the name of that service and nothing else. This has lead to confusion since we have multiple events with the same name.
Ideally, there would be something unique in the calendar event name, like the Customer’s name or the Customer’s company name. From reading through this forum it seems like this is something Bookings used to do? Is there some setting I’m just not seeing?
Additionally, we cannot see the Customer’s details when looking at the event in Outlook calendar. Like I mentioned, we are using a shared inbox email address so we have just all added that user’s calendar to our views. The only way to see what Customer booked with us is by logging into the Bookings app. Is there a work around for this?
We have set up a bookings page under a shared inbox. When someone books a service, the calendar event is given the name of that service and nothing else. This has lead to confusion since we have multiple events with the same name. Ideally, there would be something unique in the calendar event name, like the Customer’s name or the Customer’s company name. From reading through this forum it seems like this is something Bookings used to do? Is there some setting I’m just not seeing? Additionally, we cannot see the Customer’s details when looking at the event in Outlook calendar. Like I mentioned, we are using a shared inbox email address so we have just all added that user’s calendar to our views. The only way to see what Customer booked with us is by logging into the Bookings app. Is there a work around for this? Read More
NEW! Microsoft 365 Customer Self-Serve Template for CSP partners
We’re excited to share the Microsoft 365 Customer Self-Serve Template to support your self-serve capabilities and insights for optimizing the commerce experience.
Today, online buying is the norm, and customers are increasingly looking for one-stop shopping with a self-serve experience that’s fast, convenient, and on demand. The Customer Self-Serve Template gives you the tools to offer a seamless self-serve experience, streamlining the customer journey.
Whether you leverage the content for new customer acquisition or for customer expansion, this quick-start guide will help you optimize the customer purchasing and provisioning process. With your self-serve capabilities in place, customers can easily choose, pay for, and auto-provision users on Microsoft 365 without manual partner interaction.
Download the Customer Self-Serve Template to get started
We’re excited to share the Microsoft 365 Customer Self-Serve Template to support your self-serve capabilities and insights for optimizing the commerce experience.
Today, online buying is the norm, and customers are increasingly looking for one-stop shopping with a self-serve experience that’s fast, convenient, and on demand. The Customer Self-Serve Template gives you the tools to offer a seamless self-serve experience, streamlining the customer journey.
Whether you leverage the content for new customer acquisition or for customer expansion, this quick-start guide will help you optimize the customer purchasing and provisioning process. With your self-serve capabilities in place, customers can easily choose, pay for, and auto-provision users on Microsoft 365 without manual partner interaction.
Download the Customer Self-Serve Template to get started Read More
Integrate Logic App workflows as plugins with Semantic Kernel: Step-by-step guide
Semantic Kernel is a framework that integrates natural language processing (NLP) and AI into applications, making it easier to use advanced AI models. It is particularly powerful when combined with plugins, which extend its capabilities by connecting to a variety of external services.
Integrating Logic Apps as a plugin into Semantic Kernel enhances its functionality by providing access to over 1000 connectors, something that my colleague. Matthew has written about in the past. This integration allows for seamless connections with cloud services, on-premises systems, and hybrid environments. By using these plugins, customers can automate complex workflows, trigger actions, and interact with multiple systems. They can also effortlessly integrate their applications with diverse external systems, enabling them to leverage advanced features without the need for extensive custom development, thus saving time and resources.
So, let’s take a look at how to set up this integration. I have included sample here on GitHub to clone so you can follow through.
Here are the steps:
Setting up a Logic App
Deploying an OpenAI model
Configuring Easy Auth
Set up app registration
Add EasyAuth to Logic App (Standard)
Provide authentication details in the Semantic Kernel’s Program.cs file
Adding Logic App as plugin in Semantic Kernel
Testing the plugin
Setting up a Logic App
I have a Logic App (Standard) with two workflows:
One that retrieves active tickets for a particular location passed in as JSON payload
Another that provides weather updates also for a location
Both workflows use HTTP request-based triggers. Add a comment in the trigger describing the prompt that will trigger the workflow. For example, for the workflow that retrieves active tickets, you might use “retrieves active tickets” from Dataverse.
Make sure to have HTTP request trigger and response action so that the Semantic Kernel planner knows which workflow to call and return the appropriate response.
Configuring OpenAI
Create an OpenAI resource and , as you’ll need it along with the model details for the environment variables of the Semantic Kernel app. Here is where you can find the API key and endpoint in the OpenAI resource
Next, navigate to Azure OpenAI Studio from the “Overview” page of your newly created resource. Then, create a model deployment in the AI Studio.
Keep in mind:
Function calling is not supported by many OpenAI models. I made the mistake of using gpt-35-turbo, but with 0301 version, which did not work with Semantic Kernel. Check that support function calling and create deployment. I used GPT-4o as my base model.
Set a high token limit to prevent errors when your conversation exceeds the maximum token limit. I set it to 20k tokens per minute.
Configuring Easy Auth
Easy Auth for Logic Apps is a feature that provides built-in authentication and authorization, making it simple to secure your workflows. It supports various authentication providers like Azure Active Directory, Google, and Facebook, allowing users to log in with their existing credentials. Easy Auth handles token validation and authorization checks, ensuring that only authorized users can access your Logic Apps. This streamlined setup enhances security by protecting workflows and sensitive data without the need for custom code.
I have divided it in 3 sections to help with visualizing how to configure EasyAuth.
Create app registration:
In Azure Portal, search for “App registration”. If you do not already have one, please create a new app registration. Here is my App registration which has ClientID and other details that we will add in our Logic App in the next step.
Next, let’s add Scope which we will use in our Semantic Kernel application. Navigate to Manage->Expose an API to create a new Scope for your app registration. Fill out the necessary details, it would look something like this:
Add EasyAuth to Logic App:
Our team recently released a UI to help with configuring EasyAuth on your app. Follow these steps to fill out details to successfully set it up:
Open your Logic App (Standard) in Azure Portal
Navigate to Settings -> Authentication in your Logic App (Standard)
Click on “Add identity provider”
Client ID can be added from your app registration’s Overview page as shown in image from last step
Issuer URL: This is the URL of the identity provider that issued the token, it is in the format: https://sts.windows.net/{TenantID}
Note that you can also find TenantID from the “Overview” page of your app registration, just like how you found clientID
6. Allowed token audiences: Set this to the Application ID URI of your app. You can find that property in your App registration’s Manage->Expose an API blade in Portal TOC. It would be something like this:
7. Additional checks: Here is what you need to check for Client Application, Identity and Tenant requirements:
Click on “Add”. The identity provider would look something like this after adding:
Provide authentication details in Semantic Kernel:
In the Program.cs file, there are a few authentication details that need to be filled out. Follow the steps to get the right values:
ClientId and TenantId: this is the same as the one you copy/pasted from the App registration in previous steps
Authority: it will be in the format:
string Authority = $”https://login.microsoftonline.com/{Tenant_ID}”;
Scopes: this array variable will be the scope that we created in our app registration. It can be found in your App registration, Manage->Expose an API
And that is all you need to complete configuring EasyAuth successfully.
Adding Logic App as plugin in Semantic Kernel
With all the variables defined, you can now add the plugin to the Program.cs file of your Semantic Kernel application. Additionally, I’ve attached a sample on GitHub that you can clone to easily set up the application locally and get started.
Use the ImportPluginFromOpenAPIAsync() method, replacing the pluginName and uri parameters with the desired plugin name and name of your Logic App respectively, to add the plugin. It would look like this
To find the full code for Program.cs, please go to the sample GitHub sample attached or take a look at my colleague, Xuhong’s blog on how she plugs in logic app using the OpenAPI method.
5. Testing the plugin
Open the VS Code terminal and run the build command to identify any issues. Then, use dotnet run to start the application. You will be prompted to sign in from your account, and once authentication is complete, you can start conversing with the assistant.
Given the integration, you can ask questions like “What is the weather in Seattle” or “Retrieve all active tickets in Kirkland,” which should trigger the appropriate Logic App (Standard) workflow to get weather or get tickets. It will also pass in the location parameter as JSON payload to the workflow. Here is how my conversation looks like
Looking at logic app workflow that was triggered, one can see the run execution so it’s easy to visualize and troubleshoot what went wrong in your workflow plugin.
Here is what the run history looks like of the workflow being called:
Conclusion:
Integrating Logic Apps as a plugin in SDKs like Semantic Kernel opens new possibilities for pro-developers to utilize plugins beyond traditional languages like Python, .NET, and Java. With the extensive connectivity provided by Logic Apps, developers can interact with any system, extending beyond just RAG to more advanced agent capabilities for task completion. Additionally, nested workflows can function as separate agents to handle different aspects of a task based on the prompts provided. We invite your feedback on how we can enhance our platform capabilities to better support agent-based applications.
Appendix:
https://techcommunity.microsoft.com/t5/fasttrack-for-azure/integrating-logic-app-with-semantic-kernel-a-detailed-guide-and/ba-p/4184910
https://devblogs.microsoft.com/semantic-kernel/connect-logic-apps-1400-connectors-to-semantic-kernel/
Microsoft Tech Community – Latest Blogs –Read More
Firewall Whitelist for Connect VM to Arc
Hi,
I need to set up a whitelist of addresses on the router firewall that are necessary for accessing Arc. In the documentation, I found addresses for entire subdomains, such as *.blob.core.windows.net, which the router can’t handle. I also can’t feasibly cache all the addresses from the subdomains with a script. Another resource I found is the Azure IP Ranges list here, but it’s not clear which addresses are needed for Arc. Moreover, creating a whitelist manually from IP addresses that might soon become outdated due to resource migration is not the best solution.
How can this be resolved more elegantly?
Thank you.
Hi,I need to set up a whitelist of addresses on the router firewall that are necessary for accessing Arc. In the documentation, I found addresses for entire subdomains, such as *.blob.core.windows.net, which the router can’t handle. I also can’t feasibly cache all the addresses from the subdomains with a script. Another resource I found is the Azure IP Ranges list here, but it’s not clear which addresses are needed for Arc. Moreover, creating a whitelist manually from IP addresses that might soon become outdated due to resource migration is not the best solution.How can this be resolved more elegantly?Thank you. Read More
GPT-4o mini is now available in API with Vision and Fine-tuning Text Capabilities on Azure AI
Last week, Microsoft announced that we are bringing OpenAI’s fastest model, GPT-4o mini, in the Azure OpenAI Studio Playground, to even more developers by releasing the GPT-4o mini API with vision support for Global and East US Regional Standard Deployments.
Highlights of this announcement include:
Expanding Accessibility extending GPT-4o mini’s availability to the API with global and regional pricing
Unlocking new possibilities with Vision and Text capabilities
Flexible pricing with regional and global options
Key features and benefits including enhanced Vision input, comprehensive Text output, and cost-effective solutions
To learn more about this announcement including the cost for fine-tuning, check out the full blog post available here: OpenAI’s GPT-4o mini Now Available in API with Vision Capabilities on Azure AI (microsoft.com)
Last week, Microsoft announced that we are bringing OpenAI’s fastest model, GPT-4o mini, in the Azure OpenAI Studio Playground, to even more developers by releasing the GPT-4o mini API with vision support for Global and East US Regional Standard Deployments.
Highlights of this announcement include:
Expanding Accessibility extending GPT-4o mini’s availability to the API with global and regional pricing
Unlocking new possibilities with Vision and Text capabilities
Flexible pricing with regional and global options
Key features and benefits including enhanced Vision input, comprehensive Text output, and cost-effective solutions
To learn more about this announcement including the cost for fine-tuning, check out the full blog post available here: OpenAI’s GPT-4o mini Now Available in API with Vision Capabilities on Azure AI (microsoft.com) Read More
جـلب الــحبيب ليون (966578385.770~*00 ) معالج السحر المتمكن
جـلب الــحبيب ليون (966578385.770~*00 ) معالج السحر المتمكن
جـلب الــحبيب ليون (966578385.770~*00 ) معالج السحر المتمكن Read More
What is the best way to identify the words and the frequency of words in an Excel column?
Hi! I need to create a list of the number of times a single word appears in a column. The word may be in multiple rows (of thousands of rows). I’m seeking to discover which words are in the column and how many times (number of rows) a word appears in a column.
I can’t use the IF, because I don’t know the words. I want excel to list the words and the number of times (or rows) in which the word appears.
Example: My column has 5,000 rows with world city names. It would be too hard to use IF, because I’d have to guess the city name, and there are too many cities in the world to guess. I want Excel to tell me what city names are in the column and how many time the city name appears.
Hi! I need to create a list of the number of times a single word appears in a column. The word may be in multiple rows (of thousands of rows). I’m seeking to discover which words are in the column and how many times (number of rows) a word appears in a column. I can’t use the IF, because I don’t know the words. I want excel to list the words and the number of times (or rows) in which the word appears. Example: My column has 5,000 rows with world city names. It would be too hard to use IF, because I’d have to guess the city name, and there are too many cities in the world to guess. I want Excel to tell me what city names are in the column and how many time the city name appears. Read More
Power Query Rows Loaded Count
Good day.
I have filtered queries that merge into a single query. The end result in Excel is about 20,000 rows. When refreshing, it counts up to 3.6 million rows.
This is problematic for speed – but I cannot figure out where to determine the problem spot. I say “problem” because the query loads about 20,000 rows per second until about 3.1 million rows…then slows to about 100 rows per second until about 3.4 million when the speed returns to about 20,000 per second.
Questions:
– When refreshing a query (or in the preview mode in the Power Query Editor), what is the “Rows Loaded” actually counting? [[If I have filtered rows, why does it count so many more?]]
– What would explain the variable speeds in refreshing?
– How can I trouble shoot to find what is slowing refresh?
– Should I change how I think about this in any way?
Thank you for any help.
Good day. I have filtered queries that merge into a single query. The end result in Excel is about 20,000 rows. When refreshing, it counts up to 3.6 million rows. This is problematic for speed – but I cannot figure out where to determine the problem spot. I say “problem” because the query loads about 20,000 rows per second until about 3.1 million rows…then slows to about 100 rows per second until about 3.4 million when the speed returns to about 20,000 per second. Questions:- When refreshing a query (or in the preview mode in the Power Query Editor), what is the “Rows Loaded” actually counting? [[If I have filtered rows, why does it count so many more?]]- What would explain the variable speeds in refreshing?- How can I trouble shoot to find what is slowing refresh?- Should I change how I think about this in any way? Thank you for any help. Read More
Odd mess with Junk and Spam folders
I am using a locally installed Outlook (2016) as my email client on a Windows 10 Laptop. I am accessing my mail provider using IMAP and I am witnessing an odd naming mess-up:
The folder where my Email provider moves Spam to (and which is called “Spam” when accessing emails via the provider’s Web-interface) is called “Junk” in Outlook. That would be OK and I could live with that, although I am puzzled how and where that name mapping is done.
However, odd enough I do have an other folder called “Spam” (shown as top-level folder in Outlook) and that folder is shown in the the Web-interface as a nested folder under “Own folders/Spam”. Annoyingly about 20% of all Spam message go to that second Spam folder. I was unable so far to figure out, why or by which mechanism emails end up in this folder. I would prefer if all Spam emails would end up in the same folder, because right now I always need to check TWO spam folders for possible false positives to not miss any legit emails.
That second spam folder, however, is not deletable (there is no Delete folder-option in its context menuin Outlook). It’s also impossible to delete that folder in the Web-Interface. If I try so then it’s gone at first, but if I refresh the email page then it reappears. 🙁
Where is this name mapping done and how can I either name Outlook’s Junk-folder “Spam” or get rid of that second Spam folder? Can one rectify this mess? And if so: how?
I am using a locally installed Outlook (2016) as my email client on a Windows 10 Laptop. I am accessing my mail provider using IMAP and I am witnessing an odd naming mess-up:The folder where my Email provider moves Spam to (and which is called “Spam” when accessing emails via the provider’s Web-interface) is called “Junk” in Outlook. That would be OK and I could live with that, although I am puzzled how and where that name mapping is done.However, odd enough I do have an other folder called “Spam” (shown as top-level folder in Outlook) and that folder is shown in the the Web-interface as a nested folder under “Own folders/Spam”. Annoyingly about 20% of all Spam message go to that second Spam folder. I was unable so far to figure out, why or by which mechanism emails end up in this folder. I would prefer if all Spam emails would end up in the same folder, because right now I always need to check TWO spam folders for possible false positives to not miss any legit emails.That second spam folder, however, is not deletable (there is no Delete folder-option in its context menuin Outlook). It’s also impossible to delete that folder in the Web-Interface. If I try so then it’s gone at first, but if I refresh the email page then it reappears. :(Where is this name mapping done and how can I either name Outlook’s Junk-folder “Spam” or get rid of that second Spam folder? Can one rectify this mess? And if so: how? Read More
Teams client (New), Unlicensed user, Separate Tenant.
Hey Team,
Hoping you can assist here. We have 2 separate tenants 1) All E3 Licenses (Teams enabled), 2) ALl e1 licenses, (No teams) license. (havent rolled it out as of yet).
1) Users from the NO Teams tenant get an error when joining meetings which are sent by our other (Teams enabled) tenant.
The error they get is:
“You dont have the requred permissions to access this org”
I see a number of different cuases, solutions, but i wanted to verify the following:
1) Users from no teams tenant, can join a teams meeting? (They are not licensed)
2) Users from the Teams Enabled Tenant all have Teams licenses assigned, the meeting originates from this tenant.
Is it accurate to have the no teams users simply join the meeting without signing in at all? Such as via a browser? If so, how would those same users join a meeting using the teams client (since they do not have the teams license enabeld)
Thanks,
Robert
Hey Team, Hoping you can assist here. We have 2 separate tenants 1) All E3 Licenses (Teams enabled), 2) ALl e1 licenses, (No teams) license. (havent rolled it out as of yet). 1) Users from the NO Teams tenant get an error when joining meetings which are sent by our other (Teams enabled) tenant. The error they get is: “You dont have the requred permissions to access this org” I see a number of different cuases, solutions, but i wanted to verify the following: 1) Users from no teams tenant, can join a teams meeting? (They are not licensed) 2) Users from the Teams Enabled Tenant all have Teams licenses assigned, the meeting originates from this tenant. Is it accurate to have the no teams users simply join the meeting without signing in at all? Such as via a browser? If so, how would those same users join a meeting using the teams client (since they do not have the teams license enabeld) Thanks, Robert Read More
SharePoint List Progress Bar Top Border
How do I get rid of the top border in a progress bar? I have attached an image and here is my code …
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json“,
“elmType”: “div”,
“children”: [
{
“elmType”: “span”,
“txtContent”: “@currentField”,
“style”: {
“padding-left”: “8px”,
“white-space”: “nowrap”
}
}
],
“attributes”: {
“class”: “sp-field-dataBars”
},
“style”: {
“padding”: “0”,
“font-size”: “12pt”,
“font-weight”: “bold”,
“color”: “#000000”,
“background-color”: “#12ae00”,
“width”: “=if(@currentField >= 101, ‘50%’, (@currentField * 1) + ‘%’)”
}
}
Thanks,
John
How do I get rid of the top border in a progress bar? I have attached an image and here is my code … { “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”, “elmType”: “div”, “children”: [ { “elmType”: “span”, “txtContent”: “@currentField”, “style”: { “padding-left”: “8px”, “white-space”: “nowrap” } } ], “attributes”: { “class”: “sp-field-dataBars” }, “style”: { “padding”: “0”, “font-size”: “12pt”, “font-weight”: “bold”, “color”: “#000000”, “background-color”: “#12ae00”, “width”: “=if(@currentField >= 101, ‘50%’, (@currentField * 1) + ‘%’)” }} Thanks,John Read More
SharePoint List Choice Pills Hex Colors
How and where do I modify the following code so I can set my own colors for the background and text using Hex codes like #FF0000? It seems to be using CSS color coding. Apologies for the long code sniplet.
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json“,
“elmType”: “div”,
“style”: {
“flex-wrap”: “wrap”,
“display”: “flex”,
“justify-content”: “center”
},
“children”: [
{
“elmType”: “div”,
“style”: {
“box-sizing”: “border-box”,
“padding”: “4px 8px 5px 8px”,
“overflow”: “hidden”,
“text-overflow”: “ellipsis”,
“display”: “flex”,
“border-radius”: “16px”,
“height”: “24px”,
“align-items”: “center”,
“white-space”: “nowrap”,
“margin”: “4px 4px 4px 4px”
},
“attributes”: {
“class”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“”
]
},
“”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Cancelled”
]
},
“sp-css-backgroundColor-BgDarkRed sp-css-borderColor-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Completed”
]
},
“sp-css-backgroundColor-BgGreen sp-css-borderColor-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“On-Hold”
]
},
“sp-css-backgroundColor-BgCoral”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Queued”
]
},
“sp-css-backgroundColor-BgMintGreen sp-css-borderColor-MintGreenFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Work in Progress”
]
},
“sp-css-backgroundColor-BgTeal sp-css-borderColor-MintGreenFont”,
“sp-field-borderAllRegular sp-field-borderAllSolid sp-css-borderColor-neutralSecondary”
]
}
]
}
]
}
]
}
]
}
]
}
},
“children”: [
{
“elmType”: “span”,
“style”: {
“line-height”: “16px”,
“height”: “14px”,
“display”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“”
]
},
“none”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Cancelled”
]
},
“inherit”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Completed”
]
},
“inherit”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“On-Hold”
]
},
“inherit”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Queued”
]
},
“inherit”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Work in Progress”
]
},
“inherit”,
“none”
]
}
]
}
]
}
]
}
]
}
]
}
},
“attributes”: {
“iconName”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“”
]
},
“”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Cancelled”
]
},
“ErrorBadge”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Completed”
]
},
“Like”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“On-Hold”
]
},
“Warning”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Queued”
]
},
“Calendar”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Work in Progress”
]
},
“Forward”,
“”
]
}
]
}
]
}
]
}
]
}
]
},
“class”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“”
]
},
“”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Cancelled”
]
},
“sp-css-color-WhiteText”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Completed”
]
},
“sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“On-Hold”
]
},
“sp-css-color-CoralFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Queued”
]
},
“sp-css-color-MintGreenFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Work in Progress”
]
},
“sp-css-color-WhiteText”,
“”
]
}
]
}
]
}
]
}
]
}
]
}
}
},
{
“elmType”: “span”,
“style”: {
“overflow”: “hidden”,
“text-overflow”: “ellipsis”,
“padding”: “0 3px”
},
“txtContent”: “[$State]”,
“attributes”: {
“class”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“”
]
},
“”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Cancelled”
]
},
“sp-css-color-WhiteText”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Completed”
]
},
“sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“On-Hold”
]
},
“sp-css-color-CoralFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Queued”
]
},
“sp-css-color-MintGreenFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$State]”,
“Work in Progress”
]
},
“sp-css-color-WhiteText”,
“”
]
}
]
}
]
}
]
}
]
}
]
}
}
}
]
}
]
}
How and where do I modify the following code so I can set my own colors for the background and text using Hex codes like #FF0000? It seems to be using CSS color coding. Apologies for the long code sniplet. { “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”, “elmType”: “div”, “style”: { “flex-wrap”: “wrap”, “display”: “flex”, “justify-content”: “center” }, “children”: [ { “elmType”: “div”, “style”: { “box-sizing”: “border-box”, “padding”: “4px 8px 5px 8px”, “overflow”: “hidden”, “text-overflow”: “ellipsis”, “display”: “flex”, “border-radius”: “16px”, “height”: “24px”, “align-items”: “center”, “white-space”: “nowrap”, “margin”: “4px 4px 4px 4px” }, “attributes”: { “class”: { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “” ] }, “”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Cancelled” ] }, “sp-css-backgroundColor-BgDarkRed sp-css-borderColor-WhiteFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Completed” ] }, “sp-css-backgroundColor-BgGreen sp-css-borderColor-WhiteFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “On-Hold” ] }, “sp-css-backgroundColor-BgCoral”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Queued” ] }, “sp-css-backgroundColor-BgMintGreen sp-css-borderColor-MintGreenFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Work in Progress” ] }, “sp-css-backgroundColor-BgTeal sp-css-borderColor-MintGreenFont”, “sp-field-borderAllRegular sp-field-borderAllSolid sp-css-borderColor-neutralSecondary” ] } ] } ] } ] } ] } ] } }, “children”: [ { “elmType”: “span”, “style”: { “line-height”: “16px”, “height”: “14px”, “display”: { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “” ] }, “none”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Cancelled” ] }, “inherit”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Completed” ] }, “inherit”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “On-Hold” ] }, “inherit”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Queued” ] }, “inherit”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Work in Progress” ] }, “inherit”, “none” ] } ] } ] } ] } ] } ] } }, “attributes”: { “iconName”: { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “” ] }, “”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Cancelled” ] }, “ErrorBadge”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Completed” ] }, “Like”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “On-Hold” ] }, “Warning”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Queued” ] }, “Calendar”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Work in Progress” ] }, “Forward”, “” ] } ] } ] } ] } ] } ] }, “class”: { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “” ] }, “”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Cancelled” ] }, “sp-css-color-WhiteText”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Completed” ] }, “sp-css-color-WhiteFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “On-Hold” ] }, “sp-css-color-CoralFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Queued” ] }, “sp-css-color-MintGreenFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Work in Progress” ] }, “sp-css-color-WhiteText”, “” ] } ] } ] } ] } ] } ] } } }, { “elmType”: “span”, “style”: { “overflow”: “hidden”, “text-overflow”: “ellipsis”, “padding”: “0 3px” }, “txtContent”: “[$State]”, “attributes”: { “class”: { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “” ] }, “”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Cancelled” ] }, “sp-css-color-WhiteText”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Completed” ] }, “sp-css-color-WhiteFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “On-Hold” ] }, “sp-css-color-CoralFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Queued” ] }, “sp-css-color-MintGreenFont”, { “operator”: “:”, “operands”: [ { “operator”: “==”, “operands”: [ “[$State]”, “Work in Progress” ] }, “sp-css-color-WhiteText”, “” ] } ] } ] } ] } ] } ] } } } ] } ]} Read More
