Tag Archives: microsoft
Power Query table transformation challenge
Hello! I have data that I import form TXT file that looks like this:
Accommodation Apartmán Slezák 2Arrival 05.05.2024 Departure 10.05.2024 First NameNAMELast NameLAST NAMEDate of birth 16.9.1969NationalityCzechReason for visitTourismNumber of additional guests 2StreetStreet 1Postal code111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12345 First NameNAME2Last NameLASTNAME2Date of birth 26.3.1999NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 First NameNAME3Last NameLASTNAME3Date of birth 24.1.2023NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346
And I would like it to look like this:
AccommodationArrivalDepartureFirst NameLast NameDate of birthNationalityReason for visitStreetPostal codeCityCountryDocument TypeDocument number Apartmán Slezák 2 05.05.2024 10.05.2024 NAMELAST NAME 16.9.1969CzechTourismStreet 1111111PragueCzechia ID / License12345 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME2LASTNAME2 26.3.1999CzechTourismStreet 21111111PragueCzechia ID / License12346 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME3LASTNAME3 24.1.2023CzechTourismStreet 21111111PragueCzechia ID / License12346
I have used group by but I am unable to expand the tables into rows. Could sb. please help me? Thanks!
Hello! I have data that I import form TXT file that looks like this: Accommodation Apartmán Slezák 2Arrival 05.05.2024 Departure 10.05.2024 First NameNAMELast NameLAST NAMEDate of birth 16.9.1969NationalityCzechReason for visitTourismNumber of additional guests 2StreetStreet 1Postal code111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12345 First NameNAME2Last NameLASTNAME2Date of birth 26.3.1999NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 First NameNAME3Last NameLASTNAME3Date of birth 24.1.2023NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 And I would like it to look like this: AccommodationArrivalDepartureFirst NameLast NameDate of birthNationalityReason for visitStreetPostal codeCityCountryDocument TypeDocument number Apartmán Slezák 2 05.05.2024 10.05.2024 NAMELAST NAME 16.9.1969CzechTourismStreet 1111111PragueCzechia ID / License12345 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME2LASTNAME2 26.3.1999CzechTourismStreet 21111111PragueCzechia ID / License12346 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME3LASTNAME3 24.1.2023CzechTourismStreet 21111111PragueCzechia ID / License12346 I have used group by but I am unable to expand the tables into rows. Could sb. please help me? Thanks! Read More
Need Suggestion about my website in Microsoft Edge
Hello, i am a web developer at fscobill.pk website. I want suggestions about my website including its speed, responsiveness and its designing in Microsoft Edge. I will really appreciate any suggestion from you.
Hello, i am a web developer at fscobill.pk website. I want suggestions about my website including its speed, responsiveness and its designing in Microsoft Edge. I will really appreciate any suggestion from you. Read More
How I passed the Microsoft AZ-900 Exam in one month
In just one month, I successfully passed the Microsoft AZ-900 exam, and I attribute much of my success to Passexam4sure’s exceptional study materials. Their comprehensive study guides, practice tests, and exam simulations were instrumental in helping me understand the exam topics thoroughly. The interactive format of their materials made learning engaging and effective, allowing me to track my progress and reinforce key concepts. With Passexam4sure, I was able to create a focused study plan, allocate time efficiently, and confidently tackle the exam questions on test day. If you’re looking to pass the AZ-900 exam efficiently, Passexam4sure is definitely the way to go!
In just one month, I successfully passed the Microsoft AZ-900 exam, and I attribute much of my success to Passexam4sure’s exceptional study materials. Their comprehensive study guides, practice tests, and exam simulations were instrumental in helping me understand the exam topics thoroughly. The interactive format of their materials made learning engaging and effective, allowing me to track my progress and reinforce key concepts. With Passexam4sure, I was able to create a focused study plan, allocate time efficiently, and confidently tackle the exam questions on test day. If you’re looking to pass the AZ-900 exam efficiently, Passexam4sure is definitely the way to go! Read More
How to Check SASSA Balance Without Airtime? Free Methods
Have you ever run out of airtime when you need to check your SASSA balance? I’ve been there! Once I had to deal with this situation myself, I decided to look into the available solutions. Using in-depth research, I came up with a guide on How to check SASSA balance without airtime. This guide explores alternative methods that don’t require airtime, ensuring you can easily access your grant information anytime.
Have you ever run out of airtime when you need to check your SASSA balance? I’ve been there! Once I had to deal with this situation myself, I decided to look into the available solutions. Using in-depth research, I came up with a guide on How to check SASSA balance without airtime. This guide explores alternative methods that don’t require airtime, ensuring you can easily access your grant information anytime. Read More
Checking for duplicates
Hi,
I have entered a formula that checks the sharepoint list for duplicates and returns an error message in a text label if that duplicate is found, before the user submits.
It works great when I was testing and still does but when I am using the published version, it returns a Duplicate exists on all items listed.
I am not sure why it works in testing but the published version is not, I dont understand?
Thanks for any help.
Ren
Hi,I have entered a formula that checks the sharepoint list for duplicates and returns an error message in a text label if that duplicate is found, before the user submits.It works great when I was testing and still does but when I am using the published version, it returns a Duplicate exists on all items listed.I am not sure why it works in testing but the published version is not, I dont understand? Thanks for any help.Ren Read More
Adding the app to a team ends up adding 2 tabs to the channel
Hi Everyone
I’m facing some problem when i upload the menifest file in new teams some how it’s creating 2 tabs on teams channel
Hi Everyone I’m facing some problem when i upload the menifest file in new teams some how it’s creating 2 tabs on teams channel Read More
Black screen every few seconds and stuck on desktop forever
Hi,
My Windows 10 PC suddenly goes black every few seconds and stuck on desktop after a recent update. Now, I can’t do anything except ctrl alt dlt.
Hi, My Windows 10 PC suddenly goes black every few seconds and stuck on desktop after a recent update. Now, I can’t do anything except ctrl alt dlt. Read More
Default document not showing while using IIS as a reverse proxy server
I am using IIS as a reverse proxy for multiple applications using URL rewrite module. I have wrote a rule like “App/?(.*)” to match the application path.
The default document which is a “Home.aspx” file is loading when I put a path like “https://localhost/App/” but, if I remove the last forward-slash like “https://localhost/App” it is not working.
I understand that the rule is written to consider only after the slash, but any way I can rewrite the rule to written the default document without the last slash as well ? Kind suggest.
I am using IIS as a reverse proxy for multiple applications using URL rewrite module. I have wrote a rule like “App/?(.*)” to match the application path.The default document which is a “Home.aspx” file is loading when I put a path like “https://localhost/App/” but, if I remove the last forward-slash like “https://localhost/App” it is not working. I understand that the rule is written to consider only after the slash, but any way I can rewrite the rule to written the default document without the last slash as well ? Kind suggest. Read More
Visual studio is automatically making errors while building
I have a vb.net project and now whenever i edit the ui elements like change the text of labels importing images or even changing project setting are also making errors in the file HarmonyPlayer.Designer.vb
the errors are like btm_mute.Image = resources.sound i know the correct one is btm_mute.Image = my.resources.sound but whenever i try to run the app after changing the resources these errors automatically made i am providing a clip https://drive.google.com/file/d/1MkMT3nb5EALMrZoXx5Y9IOoGClIbUmUB/view?usp=drive_link
I have a vb.net project and now whenever i edit the ui elements like change the text of labels importing images or even changing project setting are also making errors in the file HarmonyPlayer.Designer.vbthe errors are like btm_mute.Image = resources.sound i know the correct one is btm_mute.Image = my.resources.sound but whenever i try to run the app after changing the resources these errors automatically made i am providing a clip https://drive.google.com/file/d/1MkMT3nb5EALMrZoXx5Y9IOoGClIbUmUB/view?usp=drive_link Read More
“Sorry, this conversation has reached its limit. Let’s start a new chat.”
Hi All,
We’re currently using Copilot for Microsoft 365 in our business and I’m finding it incredibly annoying when Copilot tells me this.
“Sorry, this conversation has reached its limit. Let’s start a new chat.”
When I asked Copilot why, this is what I receive.
“The message “Sorry, this conversation has reached its limit. Let’s start a new chat.” means that the current conversation has reached the maximum number of turns or messages allowed. Each conversation with me, Copilot Pro, has a limit on the number of turns it can take. Once this limit is reached, the conversation cannot continue further in the same thread. Starting a new chat will initiate a new conversation where you can continue to ask questions or request assistance. This is a measure to ensure optimal performance and user experience. I hope this clarifies your query! :smiling_face_with_smiling_eyes:”
“I’m sorry, but I can’t provide the exact number of turns or messages allowed in a conversation. The limit is set to ensure optimal performance and user experience. However, once the limit is reached, you can always start a new conversation. Please let me know if there’s anything else I can assist you with! :smiling_face_with_smiling_eyes:“
I’d love to understand the logic for such a limitation. Can anyone kindly explain this is plain simple English please? Thanks!
Cheers,
Eddie | Zhamatix
Hi All, We’re currently using Copilot for Microsoft 365 in our business and I’m finding it incredibly annoying when Copilot tells me this.”Sorry, this conversation has reached its limit. Let’s start a new chat.”When I asked Copilot why, this is what I receive. “The message “Sorry, this conversation has reached its limit. Let’s start a new chat.” means that the current conversation has reached the maximum number of turns or messages allowed. Each conversation with me, Copilot Pro, has a limit on the number of turns it can take. Once this limit is reached, the conversation cannot continue further in the same thread. Starting a new chat will initiate a new conversation where you can continue to ask questions or request assistance. This is a measure to ensure optimal performance and user experience. I hope this clarifies your query! :smiling_face_with_smiling_eyes:” When I asked Copilot what the limit is, this is what I receive.”I’m sorry, but I can’t provide the exact number of turns or messages allowed in a conversation. The limit is set to ensure optimal performance and user experience. However, once the limit is reached, you can always start a new conversation. Please let me know if there’s anything else I can assist you with! :smiling_face_with_smiling_eyes:”I’d love to understand the logic for such a limitation. Can anyone kindly explain this is plain simple English please? Thanks!Cheers,Eddie | Zhamatix Read More
Additional CSP partner Benefits for lighting up Azure Services
Folks – Curious as a MSFT CSP, were lighting up more and more Azure internal services on our tenant, such as Lighthouse and will seek to turn around and repackage/resell to customers. Anyone know(besides the specializations) if there are other MSFT benefits/programs/credits/incentives to lighting up services(Arc, Purview, Monitor etc…) in Azure? TIA
Folks – Curious as a MSFT CSP, were lighting up more and more Azure internal services on our tenant, such as Lighthouse and will seek to turn around and repackage/resell to customers. Anyone know(besides the specializations) if there are other MSFT benefits/programs/credits/incentives to lighting up services(Arc, Purview, Monitor etc…) in Azure? TIA Read More
aurora borealis
One of my other hobbies is astronomy. Tonight (May 10th 2024) the earth is being hit with a CME from the sun, and it can be seen by many more people than normal.
so if you go out and take some pics, please share them below and tell us where you took them.
These are from Scotland
One of my other hobbies is astronomy. Tonight (May 10th 2024) the earth is being hit with a CME from the sun, and it can be seen by many more people than normal.
so if you go out and take some pics, please share them below and tell us where you took them.
These are from Scotland
first-time Azure user, inadvertently activated a costly Synapse Analytics service without use, accum
Dear all：
Hi， this is Harry Huang who is a first-time user of Azure and makes the mistake for the wrong applications of Synapse Analytics service.
I am a passionate technology enthusiast who subscribed to Azure services for self-education and to further my interest in technology. As this was my first experience with cloud services, I was not aware of the need to set up cost-blocking or cost-alerting features. Regrettably, I inadvertently activated the Synapse Analytics Dedicated SQL service without a clear understanding of its costs (Now it costs me AU$13,943.97) and have not utilized it any more.
The service has incurred daily expenses of up to 600 Australian dollars, amounting to a cumulative total of $14,658.52 AUD. This service was activated accidentally, a result of the platform’s operational complexity. As a novice to cloud services and someone who has never intentionally used such an expensive feature, I am reaching out to request special consideration/solutions regarding my account.
Here is my request
(1) Is it possible to delay the due date for payment of $14,658.52 AUD ?
(2) Can I have the discount for the Synapse Analytics Dedicated SQL service( AU$13,943.97)?
Dear all： Hi， this is Harry Huang who is a first-time user of Azure and makes the mistake for the wrong applications of Synapse Analytics service. I am a passionate technology enthusiast who subscribed to Azure services for self-education and to further my interest in technology. As this was my first experience with cloud services, I was not aware of the need to set up cost-blocking or cost-alerting features. Regrettably, I inadvertently activated the Synapse Analytics Dedicated SQL service without a clear understanding of its costs (Now it costs me AU$13,943.97) and have not utilized it any more. The service has incurred daily expenses of up to 600 Australian dollars, amounting to a cumulative total of $14,658.52 AUD. This service was activated accidentally, a result of the platform’s operational complexity. As a novice to cloud services and someone who has never intentionally used such an expensive feature, I am reaching out to request special consideration/solutions regarding my account. Here is my request(1) Is it possible to delay the due date for payment of $14,658.52 AUD ?(2) Can I have the discount for the Synapse Analytics Dedicated SQL service( AU$13,943.97)? Read More
having issue in word, pages merge.
While i was doning my work, my pages merge and i can’t see my work properly and not even see after save into pdf document.
While i was doning my work, my pages merge and i can’t see my work properly and not even see after save into pdf document. Read More
Azure Database for MySQL – April 2024 updates and latest feature roadmap
We’re pleased to share a summary of the Azure Database for MySQL – Flexible Server announcements from last month, as well as the latest roadmap of upcoming features!
May 2024 Live webinar
These updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Below is a link to the session recording of the live webinar we delivered this week:
April 2024 announcements
Click-through demos for Azure MySQL’s top 3 uses cases
Explore the power and versatility of Azure Database for MySQL with these three new comprehensive, click-through demos highlighting the top three use cases – integration with WordPress, Moodle, and Magento! By completing these demos, you’ll learn how you can get your web apps up and running, connected securely to Azure Database for MySQL, and performing efficiently and reliably – all with just a few clicks!
Link to demos: Azure Database for MySQL demos
Reminder: Register for Microsoft Build 2024 today!
Register for Microsoft Build 2024 and meet the Azure Database for MySQL product group during our demo session “Industry leading performance with Azure Database for MySQL apps” (on May 22, 1:15pm – 1:30pm PDT), during which we’ll walk you through some exciting new feature updates releasing this month!
Latest feature roadmap
Feature
Description
Release status
Coming soon!
(Tentative*)
Accelerated Logs
This feature, available with the Business Critical service tier and designed for mission-critical workloads, provides a significant performance boost by minimizing latency, which results in faster query execution and more responsive interactions. Take advantage of an impressive increase in throughput of up to two times (2x) for your applications at no additional cost! Learn more.
Public Preview
General Availability
in May CY24
Support for 32TB storage
This feature provides you with the ability to expand the storage for your workloads using the Business-Critical service tier up to 32TB.
Private Preview
General Availability
in May CY24
On-demand backup and export
This feature provides you with the ability to export at-moment physical backup of the server to an Azure storage account (Azure blob storage) using an Azure CLI command. After export, these backups can be used for data recovery, migration, data redundancy and availability, or auditing.
Private Preview
Public Preview
in May CY24
Azure MySQL Import for external migrations
Azure MySQL Import enables you to migrate your MySQL on-premises or Virtual Machine (VM) workload seamlessly to Azure Database for MySQL – Flexible Server. It takes advantage of a user-provided physical backup file and restores the source server’s physical data files to the target server offering a simple and fast migration path. Based on user inputs, the feature takes up the responsibility of provisioning your target flexible server, then restoring the user-provided physical backup of the source server stored in the Azure Blob storage account to the target Flexible Server instance. Learn more.
Public Preview
General Availability
in Q2 CY24
Flexible maintenance options
Building upon our existing system-managed and custom-managed maintenance windows, the following new flexible maintenance options aim to elevate user convenience and operational flexibility in server maintenance:
Reschedule window: Tailor maintenance schedules to suit your business rhythm.
On-demand maintenance: Instantly initiate maintenance activities using the Reschedule now option.
Public Preview
General Availability
in Q2 CY24
Near-zero downtime maintenance for HA servers
This feature is designed to substantially reduce maintenance downtime for HA-enabled servers, ensuring that in most cases, maintenance downtime is expected to be between 40 to 60 seconds. This capability is pivotal for businesses that demand high availability and minimal interruption in their database operations. Learn more.
Public Preview
General Availability
in Q2 CY24
Virtual Canary
The Virtual Canary feature is an exciting solution for Azure MySQL users who prioritize staying at the forefront of technology by making sure that their servers always run the most current version. Servers opted in for virtual canary receive maintenance updates earlier in advance. You can also take advantage of the feature as an opportunity to perform an additional layer of update testing on your dev, test, or staging servers to help avoid workload-specific issues like application-level compatibility issues. The feature thus offers an efficient way to manage updates, align testing and production environments, and maintain operational stability with minimal disruption.
–
Public Preview
in Q3 CY24
Long Term Retention of Backups
Previously with Azure Database for MySQL, you could retain automated backups and on-demand backups for up to 35 days. With Long Term Retention, you can now retain the backups up to 10 years, further accommodating your audit and compliance needs. Learn more.
Public Preview
General Availability
in early Q3 CY24
Error Logs (in Server Logs)
This feature allows you to maintain MySQL error log files under Server logs and download them for up to seven days. These error logs can help you efficiently identify and troubleshoot performance and reliability issues, and proactively detect and respond to unauthorized access attempts, failed login attempts, and other security-related events. Learn more.
Public Preview
General Availability
in early Q3 CY24
MySQL Discovery & Assessment in Azure Migrate
With this functionality, you can use Azure Migrate to discover MySQL servers in your environment, assess them by identifying their compatibility for moving to Azure Database for MySQL, and receive compute and storage SKU recommendations along with their costs. Learn more.
Private Preview
Public Preview
in Q3 CY24
*The roadmap features and dates are tentative and subject to changes. Please stay tuned for continuous updates.
Conclusion
As we continue to work on new features and functionalities, your feedback is very critical for our improvement. If you wish to enroll in Private Preview for any of the above features, or if you have any suggestions for or queries about our service, email us at AskAzureDBforMySQL@service.microsoft.com.
To learn more about what’s new with Flexible Server, see What’s new in Azure Database for MySQL – Flexible Server. Stay tuned for more updates and announcements by following us on social media: YouTube | LinkedIn | X.
Microsoft Tech Community – Latest Blogs –Read More
NEW Copilot ILTs coming your way May & June!
_________________________________________________________
Note: Please click on image to view full-size. Thank you
_________________________________________________________
Note: Please click on image to view full-size. Thank you Read More
Available time not showing up on booking page
Hello!
I have been using Bookings for quite a while now. Suddenly there are time slots that I know I have free that are not available when clients go to book. I have checked all my calendars to make sure I don’t have something booking me off and I cannot see a thing. For example, all my calendars show me free next Tuesday but there are no slots available on the booking page in the afternoon? Any suggestions would be appreciated!
Hello!I have been using Bookings for quite a while now. Suddenly there are time slots that I know I have free that are not available when clients go to book. I have checked all my calendars to make sure I don’t have something booking me off and I cannot see a thing. For example, all my calendars show me free next Tuesday but there are no slots available on the booking page in the afternoon? Any suggestions would be appreciated! Read More
Footnotes in Word
Following all the standard procedures, I am unable to have Word restart numbering footnotes on each page of my documents. The other options work OK–“continuous” and “restart each section;” “restart each page,” however, causes all footnotes to become “8s” I’ve just spent over an hour with Microsoft support with no resolution to the problem.
Following all the standard procedures, I am unable to have Word restart numbering footnotes on each page of my documents. The other options work OK–“continuous” and “restart each section;” “restart each page,” however, causes all footnotes to become “8s” I’ve just spent over an hour with Microsoft support with no resolution to the problem. Read More
The Copilot in Edge sidebar refreshed during generating answers
Since there’s no history available in the Enterprise version, I’ve experienced the issue of losing my entire prompt, and it’s been a problem since day one. Never encountered this issue in any other LLM products (ChatGPT, Gemini, Perplexity, Poe…). Just curious if this is “by design” or a known bug.
Since there’s no history available in the Enterprise version, I’ve experienced the issue of losing my entire prompt, and it’s been a problem since day one. Never encountered this issue in any other LLM products (ChatGPT, Gemini, Perplexity, Poe…). Just curious if this is “by design” or a known bug. Read More
Copy/Convert Excel email list to a gmail distribution list
Is there any way to copy/convert/import a list of 80+ email addresses from Excel to a gmail distribution list without having to go into gmail and type in each email address one at a time?
Is there any way to copy/convert/import a list of 80+ email addresses from Excel to a gmail distribution list without having to go into gmail and type in each email address one at a time? Read More
