Category: Microsoft
Category Archives: Microsoft
Calcul d’un délai entre deux dates sur LITS, comment enlever une valeur négative qui apparait ?
Bonjour,
Lorsque je calcule le délai entre deux dates sur LISTS et qu’il manque une donnée, cela me donne une valeur négative dans les -45490.
Je pense qu’il faut développer une formule sur JSON
J’aimerai mettre rien du tout quand il manque une donnée
Merci de votre aide
Bonjour, Lorsque je calcule le délai entre deux dates sur LISTS et qu’il manque une donnée, cela me donne une valeur négative dans les -45490. Je pense qu’il faut développer une formule sur JSON J’aimerai mettre rien du tout quand il manque une donnée Merci de votre aide Read More
Enable Copilot in Word, Excel and Power Point
I have a Microsoft account for work with an Office E3 license. I want to activate copilot in Word, Excel and Power Point but I can’t. I have followed the following link How to find and enable missing Copilot button in Microsoft 365 apps – Microsoft Support but it still doesn’t work. Does anyone know how to solve this problem?
I have a Microsoft account for work with an Office E3 license. I want to activate copilot in Word, Excel and Power Point but I can’t. I have followed the following link How to find and enable missing Copilot button in Microsoft 365 apps – Microsoft Support but it still doesn’t work. Does anyone know how to solve this problem? Read More
Incorrect Detected as Malware
Dear team,
Our apps have been detected incorrectly as malware and we’ve submitted for screening somehow still flagged as malware.
We tried to appeal and looking for someone to help us how can we remove this flag from defender.
Dear team, Our apps have been detected incorrectly as malware and we’ve submitted for screening somehow still flagged as malware. We tried to appeal and looking for someone to help us how can we remove this flag from defender. Read More
How Do I Fix Cannot Open Company File In Desktop? [Urgent Help Required]
I’m unable to open our company file. I’ve checked the file path, permissions, and restarted the system, but the issue persists. Could you please help me fix this error or guide me on restoring the file from backup?
I’m unable to open our company file. I’ve checked the file path, permissions, and restarted the system, but the issue persists. Could you please help me fix this error or guide me on restoring the file from backup? Read More
What Causes the Unrecoverable Error in Desktop Enterprise Software?
I’m encountering an unrecoverable error while using my desktop enterprise software. What are the common causes of this error, and how can I fix it? Any tips or troubleshooting steps would be greatly appreciated!
I’m encountering an unrecoverable error while using my desktop enterprise software. What are the common causes of this error, and how can I fix it? Any tips or troubleshooting steps would be greatly appreciated! Read More
What to Do If Enterprise Pay-roll Update Not Working?
I’m facing an issue where the enterprise pay-roll update is not working. Can anyone provide guidance on how to troubleshoot and resolve this problem? Any tips or solutions would be greatly appreciated!
I’m facing an issue where the enterprise pay-roll update is not working. Can anyone provide guidance on how to troubleshoot and resolve this problem? Any tips or solutions would be greatly appreciated! Read More
The best way to convert heic to pdf on Windows 11 for free?
All of photos taken on my iPhone are saved in .heic image format. When I copied them to my Windows 11 PC, they are not available for open with the Photos app. I need to convert many of them to PDF format so I can share with others.
I’ve noticed that HEIC isn’t as widely supported as other image formats, so I’m hoping to find a reliable for converting HEIC to PDF on Windows PC that can handle these conversions smoothly without compromising on image quality.
If you know of any software or online services that work well for converting HEIC to PDF on Windows 11, I’d love to hear your recommendations. It would be great if the tool offers options to customize the layout of the images within the PDF, such as arranging multiple images per page or adjusting the margins and orientation.
Thanks
All of photos taken on my iPhone are saved in .heic image format. When I copied them to my Windows 11 PC, they are not available for open with the Photos app. I need to convert many of them to PDF format so I can share with others. I’ve noticed that HEIC isn’t as widely supported as other image formats, so I’m hoping to find a reliable for converting HEIC to PDF on Windows PC that can handle these conversions smoothly without compromising on image quality. If you know of any software or online services that work well for converting HEIC to PDF on Windows 11, I’d love to hear your recommendations. It would be great if the tool offers options to customize the layout of the images within the PDF, such as arranging multiple images per page or adjusting the margins and orientation. Thanks Read More
Not working DFCI
Hello, Guys
I am using the DFCI function in the Intune.
In some devices, the log is printed as below and DFCI works properly.
However, in other devices, the log is printed as below and DFCI does not work at all.
When it says “License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: false”, what should be checked?
Please give me some advice on this issue.
0. Log file Name
DiagnosticLogCSP_Collector_DeviceEnrollment_2024_7_29_14_48_2.etl
1. Log of successful devices
Microsoft-WindowsPhone-ConfigManager2 5056 6812 2024/06/19-11:03:21.059 0 License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: true, returns: (0)
Microsoft-WindowsPhone-ConfigManager2 5056 6812 2024/06/19-11:03:21.059 0 CSP access: URI: (./Vendor/MSFT/Uefi/DeviceIdentifier), IsAllowed: true, Result: (0)
2. Failed device Logs
Microsoft-WindowsPhone-ConfigManager2 2452 3288 2024/07/26-14:07:55.377 0 License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: false, returns: (0)
Microsoft-WindowsPhone-ConfigManager2 2452 3288 2024/07/26-14:07:55.377 0 CSP access: URI: (./Vendor/MSFT/Uefi/DeviceIdentifier), IsAllowed: false, Result: (86000025)
Thanks a lot.
Hello, Guys I am using the DFCI function in the Intune. In some devices, the log is printed as below and DFCI works properly.However, in other devices, the log is printed as below and DFCI does not work at all. When it says “License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: false”, what should be checked?Please give me some advice on this issue.0. Log file NameDiagnosticLogCSP_Collector_DeviceEnrollment_2024_7_29_14_48_2.etl 1. Log of successful devicesMicrosoft-WindowsPhone-ConfigManager2 5056 6812 2024/06/19-11:03:21.059 0 License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: true, returns: (0)Microsoft-WindowsPhone-ConfigManager2 5056 6812 2024/06/19-11:03:21.059 0 CSP access: URI: (./Vendor/MSFT/Uefi/DeviceIdentifier), IsAllowed: true, Result: (0) 2. Failed device LogsMicrosoft-WindowsPhone-ConfigManager2 2452 3288 2024/07/26-14:07:55.377 0 License check result: URI: ./Vendor/MSFT/Uefi/DeviceIdentifier, IsAllowed: false, returns: (0)Microsoft-WindowsPhone-ConfigManager2 2452 3288 2024/07/26-14:07:55.377 0 CSP access: URI: (./Vendor/MSFT/Uefi/DeviceIdentifier), IsAllowed: false, Result: (86000025) Thanks a lot. Read More
Problems synching Sharepoint Libraries
Hello,
We are currently experiencing issues with synchronizing our SharePoint libraries. The synchronization continues to work without problems on all PCs that have been connected for a longer time. However, when we try to synchronize SharePoint libraries on new devices, problems occur. The library syncs, and OneDrive works until the system is restarted. After every restart, OneDrive starts to resynchronize the entire library. Since there are many files, this takes a while and significantly hinders our work. Does anyone have any idea what could be causing this? The OneDrive versions on both the already synchronized devices and the new devices are the same.
Best regards
Hello,We are currently experiencing issues with synchronizing our SharePoint libraries. The synchronization continues to work without problems on all PCs that have been connected for a longer time. However, when we try to synchronize SharePoint libraries on new devices, problems occur. The library syncs, and OneDrive works until the system is restarted. After every restart, OneDrive starts to resynchronize the entire library. Since there are many files, this takes a while and significantly hinders our work. Does anyone have any idea what could be causing this? The OneDrive versions on both the already synchronized devices and the new devices are the same.Best regards Read More
REGISTER TODAY! New FY25 Level Up CSP Bootcamps | August and September 2024
We are excited to announce our new FY25 Level Up CSP Bootcamps, that are built to help CSP partners grow sales and technical capabilities and accelerate new customer acquisition, upsell and cross sell. Join us for the upcoming Microsoft 365 and Copilot bootcamps to get ready to acquire, upsell and expand with M365 Premium SKUs, Copilot and Copilot Studio.
NEW! We will be offering voiceover and subtitles for ten languages to support our global CSP partners.
Level Up CSP Sales Bootcamp
1-day Sales Bootcamp: Get ready to go to market and sell Microsoft 365 and Copilot
Americas/EMEA region: August 28 | 8:00 AM – 12:00 PM, Pacific Time
APAC region: September 4 | 5:00 PM – 9:00 PM, Pacific Time
Level Up CSP Pre and Post Sales Technical Bootcamp
2-day Technical Bootcamp: Secure customers with Premium SKUs, deploy Copilot and extend with Copilot Studio
Americas/EMEA region: September 11 & 12 | 7:00 AM – 11:00 AM, Pacific Time
APAC region: September 18 & 19 | 5:00 PM – 9:00 PM, Pacific Time
We are excited to announce our new FY25 Level Up CSP Bootcamps, that are built to help CSP partners grow sales and technical capabilities and accelerate new customer acquisition, upsell and cross sell. Join us for the upcoming Microsoft 365 and Copilot bootcamps to get ready to acquire, upsell and expand with M365 Premium SKUs, Copilot and Copilot Studio.
NEW! We will be offering voiceover and subtitles for ten languages to support our global CSP partners.
REGISTER TODAY!
Level Up CSP Sales Bootcamp
1-day Sales Bootcamp: Get ready to go to market and sell Microsoft 365 and Copilot
Americas/EMEA region: August 28 | 8:00 AM – 12:00 PM, Pacific Time
APAC region: September 4 | 5:00 PM – 9:00 PM, Pacific Time
Level Up CSP Pre and Post Sales Technical Bootcamp
2-day Technical Bootcamp: Secure customers with Premium SKUs, deploy Copilot and extend with Copilot Studio
Americas/EMEA region: September 11 & 12 | 7:00 AM – 11:00 AM, Pacific Time
APAC region: September 18 & 19 | 5:00 PM – 9:00 PM, Pacific Time Read More
conditional formula excel
Hi
I have a question and need help find 3 items
1) How use conditional formula and highlight the month based on the DOB
2) How to use conditional formula to highlight in the month turn first 60 based on the birth month (eg the last row should highlight Jan – 60)
Thank you
Birth dateDec 23Jan 24Feb 24Mar 24Apr 24May 24Jun 24Jul 24Aug 24Sep 24Oct 24Nov 24Dec 243/23/1948757575767676767676767676762/5/1956676768686868686868686868681/31/196459606060606060606060606060
Hi I have a question and need help find 3 items1) How use conditional formula and highlight the month based on the DOB2) How to use conditional formula to highlight in the month turn first 60 based on the birth month (eg the last row should highlight Jan – 60) Thank youBirth dateDec 23Jan 24Feb 24Mar 24Apr 24May 24Jun 24Jul 24Aug 24Sep 24Oct 24Nov 24Dec 243/23/1948757575767676767676767676762/5/1956676768686868686868686868681/31/196459606060606060606060606060 Read More
How to Batch convert ape to mp3 that retains good quality?
I recently downloaded hundreds of music files in APE format. I’m aware that APE is a lossless audio format, which means it preserves the original quality of the audio, but it’s not widely supported by many devices and media players. Therefore, I need to convert APE to MP3, a more universally compatible format.
Could anyone recommend a reliable method for batch converting APE to MP3 on a Windows PC or Mac? Ideally, I’d like something that can handle large batches efficiently without compromising too much on audio quality.
I recently downloaded hundreds of music files in APE format. I’m aware that APE is a lossless audio format, which means it preserves the original quality of the audio, but it’s not widely supported by many devices and media players. Therefore, I need to convert APE to MP3, a more universally compatible format. Could anyone recommend a reliable method for batch converting APE to MP3 on a Windows PC or Mac? Ideally, I’d like something that can handle large batches efficiently without compromising too much on audio quality. Read More
Active Directory Users Remapping in DevOps Server 2022
Hi All,
We had a ransomware attack on our AD server and DevOps server. Luckily I had a backup of the DevOps server which I restored back after formating both the servers. I did not change anything after format hostname of DevOps & AD server, IP address, the domain name , created same user names in active directory, everything I have kept identical.
After installation and configuring DevOps AD users are not able to log in to DevOps. It keeps asking for credentials whenever a user tries to connect. Is there any option in TFS to remap active directory users? Please let me know. There are so many project created in TFS and its impossible for us to go and add AD users again on each project.
Regards
Imran Shaikh
Hi All,We had a ransomware attack on our AD server and DevOps server. Luckily I had a backup of the DevOps server which I restored back after formating both the servers. I did not change anything after format hostname of DevOps & AD server, IP address, the domain name , created same user names in active directory, everything I have kept identical.After installation and configuring DevOps AD users are not able to log in to DevOps. It keeps asking for credentials whenever a user tries to connect. Is there any option in TFS to remap active directory users? Please let me know. There are so many project created in TFS and its impossible for us to go and add AD users again on each project. RegardsImran Shaikh Read More
Folder Re-direction to OneDrive
Morning All ,
We are in the process of moving away from Folder redirection to each user OneDrive. Do you perhaps have a best practice step by step to disable the folder redirection and then sync the user files to OneDrive
Thanks
Morning All , We are in the process of moving away from Folder redirection to each user OneDrive. Do you perhaps have a best practice step by step to disable the folder redirection and then sync the user files to OneDriveThanks Read More
Power BI, a measure is not distributed over a certain code in a matrix visual
Hi all,
I need help & I think a planning engineer would easily understand the situation.
I’ve 4 tables, named TActDB, TCodes, TAPerc & TDate (which is recognized as date table).
TActDB linked to TCodes by one to one both direction relation via column named “Activity ID” (Unique).
TActDB linked to TAPerc by one to many relationship via same column “Activity ID” ( See Pic#1)Pic#1
in table TAPerc I’ve created a measure “**bleep** EMH” (i.e.: Cumulative Earned Manhour = ∑EMH) with the below DAX.
**bleep** EMH = IF(SUM(TAPerc[EMH])=0,BLANK(),CALCULATE(SUM(TAPerc[EMH]),FILTER(ALL(TAPerc),TAPerc[DDate]<=MAX(TDate[Date]))))
4. The 4th table “TDate” which I use to filter date thru a slicer. And the TAPerc have the progress under each date (weekly basis), and have been unpivot during the power query. This is why in the DAX above I used “All(Table)” to supersede any filtered dates and then want it to apply the calculations as long as the date is <= the max applied date in the slicer.
now the issue is when i used a matrix visual it couldn’t distribute the **bleep** EMH over the building, noting that building is a column under the table TCodes (See Pic#2)
I tried having the one to many relationship to be both directions and single, but neither didn’t work.
I don’t know why it’s unable to distribute the **bleep** EMH over the buildings and how to resolve the issue.
Hi all,I need help & I think a planning engineer would easily understand the situation.I’ve 4 tables, named TActDB, TCodes, TAPerc & TDate (which is recognized as date table).TActDB linked to TCodes by one to one both direction relation via column named “Activity ID” (Unique).TActDB linked to TAPerc by one to many relationship via same column “Activity ID” ( See Pic#1)Pic#1 in table TAPerc I’ve created a measure “**bleep** EMH” (i.e.: Cumulative Earned Manhour = ∑EMH) with the below DAX. **bleep** EMH = IF(SUM(TAPerc[EMH])=0,BLANK(),CALCULATE(SUM(TAPerc[EMH]),FILTER(ALL(TAPerc),TAPerc[DDate]<=MAX(TDate[Date])))) 4. The 4th table “TDate” which I use to filter date thru a slicer. And the TAPerc have the progress under each date (weekly basis), and have been unpivot during the power query. This is why in the DAX above I used “All(Table)” to supersede any filtered dates and then want it to apply the calculations as long as the date is <= the max applied date in the slicer.now the issue is when i used a matrix visual it couldn’t distribute the **bleep** EMH over the building, noting that building is a column under the table TCodes (See Pic#2) I tried having the one to many relationship to be both directions and single, but neither didn’t work.I don’t know why it’s unable to distribute the **bleep** EMH over the buildings and how to resolve the issue. Read More
AI and NET: AI in Action in Real-World .NET Applications
Building a LLM from zero
Make sure to check out the full video for an in-depth look at how you can start leveraging these tools today and propel your projects into the future of AI-driven development.
Resources
Dicta: https://dicta.org.il/
BERT: https://huggingface.co/google-bert/bert-base-uncased
All .NET Community sessions .NET Community Standups | .NET Live TV (microsoft.com)
Recording
Next Steps
Microsoft Tech Community – Latest Blogs –Read More
Format cells with distributed indent not working
I have entered value in cell
I am trying to format chinse string to keep same width like below:
I try to set with below
But, it did not take effect, its result like format with center
until I enter space between 一 and 二, it will be like
It seems excel treat 一二 as single words instead of two words
I have entered value in cellI am trying to format chinse string to keep same width like below:I try to set with below But, it did not take effect, its result like format with centeruntil I enter space between 一 and 二, it will be likeIt seems excel treat 一二 as single words instead of two words Read More
Beta app
Hi all. I’ve been a windows insider for a while. Today I’m trying to get my Android phone to show up in windows explorer. I am in the Release insider channel but need the Link To Windows beta app for the phone to show in Windows Explorer. I have the Link To Windows app on my phone but need the beta version. Where do I get this beta version?
Thanks in advance ☺️
Hi all. I’ve been a windows insider for a while. Today I’m trying to get my Android phone to show up in windows explorer. I am in the Release insider channel but need the Link To Windows beta app for the phone to show in Windows Explorer. I have the Link To Windows app on my phone but need the beta version. Where do I get this beta version? Thanks in advance ☺️ Read More
MDI not firing alert – “Suspicious additions to sensitive groups (external ID 2024)”
Hi everyone,
i have checked our MDI installation with the Powershell – it is all green. Also the action itself is in the portal.
The group is marked sensitive by default. A user gets added by another Domain Admin.
This should fire an high alert? But nothin happens.
Is there any setting i am missing? We started with a “german AD” so the group names are in German. But this cannot make any difference.
BR
Stephan
Hi everyone, i have checked our MDI installation with the Powershell – it is all green. Also the action itself is in the portal. The group is marked sensitive by default. A user gets added by another Domain Admin.This should fire an high alert? But nothin happens. Is there any setting i am missing? We started with a “german AD” so the group names are in German. But this cannot make any difference. BRStephan Read More
Unit Test Cases for SharePoint Extensions (Application Customizer)
Hi team
Can someone please suggest how to write automated unit test cases for application customizer.
#SPFX
#ApplicationCustomizer.
Hi teamCan someone please suggest how to write automated unit test cases for application customizer.#SPFX#ApplicationCustomizer. Read More
