Tag Archives: microsoft
Help Needed: Quick-Books Error 40001
Hi everyone,
I’m facing Quick-Books Error 40001 when trying to process pay-roll. The error message pops up and halts the process. Has anyone encountered this issue before? Any guidance or solutions would be greatly appreciated.
Thanks!
Hi everyone,I’m facing Quick-Books Error 40001 when trying to process pay-roll. The error message pops up and halts the process. Has anyone encountered this issue before? Any guidance or solutions would be greatly appreciated.Thanks! Read More
Teams calling issue.
Hello
Please i need your help on this issue.
Since updating to the new version of Teams users cannot make calls by clicking a number on the CRM system.
The users are licensed to make phone calls.
Previously when a user clicked the number on the system Teams would open and dial the number.
Now when clicking we get the message; Sorry, we’re unable to complete the call
There was an issue finding the person you were trying to reach.
This only started happening when we updated Teams.
Hello Please i need your help on this issue. Since updating to the new version of Teams users cannot make calls by clicking a number on the CRM system.The users are licensed to make phone calls.Previously when a user clicked the number on the system Teams would open and dial the number.Now when clicking we get the message; Sorry, we’re unable to complete the callThere was an issue finding the person you were trying to reach.This only started happening when we updated Teams. Read More
Crashes on latest Cumulative Update for Windows 11 24H2 insider build
Since the update, my PC has been crashing frequently and unexpectedly. The crashes are random and don’t seem to be related to any specific task or application. Sometimes, the screen will freeze and then restart, while other times I’ll get a blue screen of death (BSOD) with various error messages. The crashes are occurring quite frequently, making it difficult for me to work or use my PC normally.
Since the update, my PC has been crashing frequently and unexpectedly. The crashes are random and don’t seem to be related to any specific task or application. Sometimes, the screen will freeze and then restart, while other times I’ll get a blue screen of death (BSOD) with various error messages. The crashes are occurring quite frequently, making it difficult for me to work or use my PC normally. Read More
Microsoft please remove all my data from portal azure
How can I request that if I don’t have any active subscription?
How can I request that if I don’t have any active subscription? Read More
Linking Contents from SharePoint List to an Existing Excel Sheet
Hi guys! I’m looking into how to link all the contents in an online SharePoint List into an existing excel sheet in OneDrive. I know of a way to link the contents of an excel sheet to another excel sheet in OneDrive. Based on an example table in “Sheet 1” illustrated below:
ABC1WeatherDistance 2Intense Hot2 KM 3 4
The below screenshot illustrates an example of “Sheet 2” (Not a table) in an excel sheet:
ABC1 2 3 4
From the above illustrations, “A”, “B”, “C”, “1”, “2”, “3”, “4” are the cells in the excel sheet. Therefore, if I want the word “Intense Hot” from “Sheet 1” to appear at cell A2 of “Sheet 2”, I would just need to put the expression,’Sheet 1′!A2 into A2 of “Sheet 2” and the word “Intense Hot” would be retrieved from A2 of “Sheet 1” and display it onto A2 of “Sheet 2”.
The above-mentioned works for retrieving a content from an excel sheet to another excel sheet in OneDrive. But I’m wondering whether this similar function works between an online SharePoint List to an excel sheet in OneDrive, retrieving an information from a cell in an online SharePoint List and display it into a cell in an excel sheet in OneDrive. I need help in this, any methods and techniques are appreciated. Thanks in advance!
Hi guys! I’m looking into how to link all the contents in an online SharePoint List into an existing excel sheet in OneDrive. I know of a way to link the contents of an excel sheet to another excel sheet in OneDrive. Based on an example table in “Sheet 1” illustrated below: ABC1WeatherDistance 2Intense Hot2 KM 3 4 The below screenshot illustrates an example of “Sheet 2” (Not a table) in an excel sheet: ABC1 2 3 4 From the above illustrations, “A”, “B”, “C”, “1”, “2”, “3”, “4” are the cells in the excel sheet. Therefore, if I want the word “Intense Hot” from “Sheet 1” to appear at cell A2 of “Sheet 2”, I would just need to put the expression,’Sheet 1′!A2 into A2 of “Sheet 2” and the word “Intense Hot” would be retrieved from A2 of “Sheet 1” and display it onto A2 of “Sheet 2”. The above-mentioned works for retrieving a content from an excel sheet to another excel sheet in OneDrive. But I’m wondering whether this similar function works between an online SharePoint List to an excel sheet in OneDrive, retrieving an information from a cell in an online SharePoint List and display it into a cell in an excel sheet in OneDrive. I need help in this, any methods and techniques are appreciated. Thanks in advance! Read More
How to shorten a long url link that keeps alive permanently?
I have a long URL link that I need to shorten, but I’m not sure how to do this on my Windows 11 PC. I’ve heard that there are various tools and websites that can help with this, but I’m not familiar with any of them.
Could anyone recommend a simple and reliable way to shorten a long URL link? Are there any built-in features in Windows 11 or trusted online services that you use? The shorten links should be live permanently. I tried two free online url shorten services but the link will be expired for a short period of time.
I have a long URL link that I need to shorten, but I’m not sure how to do this on my Windows 11 PC. I’ve heard that there are various tools and websites that can help with this, but I’m not familiar with any of them. Could anyone recommend a simple and reliable way to shorten a long URL link? Are there any built-in features in Windows 11 or trusted online services that you use? The shorten links should be live permanently. I tried two free online url shorten services but the link will be expired for a short period of time. Read More
WSL won’t install after upgrading to 24H2?
I am running the current Dev Windows 11 build. Ever since I upgraded from 23H2 to 24H2 I’ve been unable to get WSL to work. When I run “wsl.exe” I get the following message:
Downloading: Windows Subsystem for Linux 2.1.5
Installing: Windows Subsystem for Linux 2.1.5
Catastrophic failure
I am running the current Dev Windows 11 build. Ever since I upgraded from 23H2 to 24H2 I’ve been unable to get WSL to work. When I run “wsl.exe” I get the following message: Downloading: Windows Subsystem for Linux 2.1.5Installing: Windows Subsystem for Linux 2.1.5Catastrophic failure Read More
Windows insiders preview downloads too slow
Whenever a new preview build is released, it takes an unusually long time to download, often taking several hours or even days to complete. This is much slower than the usual download speeds I’ve experienced in the past, and it’s becoming frustrating as I’m eager to try out the latest features and updates. I’ve checked my internet connection and it seems to be functioning normally, so I’m not sure what could be causing this slow download speed.
Whenever a new preview build is released, it takes an unusually long time to download, often taking several hours or even days to complete. This is much slower than the usual download speeds I’ve experienced in the past, and it’s becoming frustrating as I’m eager to try out the latest features and updates. I’ve checked my internet connection and it seems to be functioning normally, so I’m not sure what could be causing this slow download speed. Read More
Cannot import my PST file into New Outlook on my new Surface laptop
I have just upgraded my Surface Book 2 purchased in 2018 to the new Surface Laptop. I have been using Outlook purchased from Office 365 since I bought the Book 2. I run my own business and have a PST file that has a large amount of important data in it. However, the new laptop comes with ‘New Outlook’ and it does not allow me to import my PST file and hence years of essential data. I have read multiple so-called work arounds on reverting to a classic outlook app that can import PST file, but none of them work e.g. Toggle switch in top right corner of New Outlook (toggle not there), Modify a registry key (file does not exist) etc.
Can anyone help please? I need to have an Outlook app on my new laptop that can import my PST file and hence years of work emails.
I have just upgraded my Surface Book 2 purchased in 2018 to the new Surface Laptop. I have been using Outlook purchased from Office 365 since I bought the Book 2. I run my own business and have a PST file that has a large amount of important data in it. However, the new laptop comes with ‘New Outlook’ and it does not allow me to import my PST file and hence years of essential data. I have read multiple so-called work arounds on reverting to a classic outlook app that can import PST file, but none of them work e.g. Toggle switch in top right corner of New Outlook (toggle not there), Modify a registry key (file does not exist) etc. Can anyone help please? I need to have an Outlook app on my new laptop that can import my PST file and hence years of work emails. Read More
String functions within playbooks
Hi,
Have the following string that I need to tidy up:
“hostname”,”{rn “LastLog”: [rn “2024-06-25T16:15:35.751991Z”rn ]rn}”
so it can have
hostname 2024-06-25 16:15:35
I have attempted to combine replace statements with no luck…
Any ideas..
Many thanks,
Tim
Hi, Have the following string that I need to tidy up: “hostname”,”{rn “LastLog”: [rn “2024-06-25T16:15:35.751991Z”rn ]rn}” so it can have hostname 2024-06-25 16:15:35 I have attempted to combine replace statements with no luck… Any ideas.. Many thanks, Tim Read More
Unified Portal – Sentinel incident losing set tactics
Hi,
Just trialling the unified portal, and incidents in Sentinel seem to lose any tactics set via the analytic rule.
Plus the resulting incident has a slightly different title, assume after being converted to ‘Defender speak’.
We have a standard rule TI MAP IP entity for Office365 and the incident is TI Map IP entity for Office365 involving one user and the tactic is missing even though its in the original rule?
Anyone else experiencing the same?
Regards,
Tim
Hi, Just trialling the unified portal, and incidents in Sentinel seem to lose any tactics set via the analytic rule.Plus the resulting incident has a slightly different title, assume after being converted to ‘Defender speak’. We have a standard rule TI MAP IP entity for Office365 and the incident is TI Map IP entity for Office365 involving one user and the tactic is missing even though its in the original rule? Anyone else experiencing the same? Regards, Tim Read More
Device Discover – MDE AV Passive Mode
Does device discovery work when the endpoint has MDE antivirus set to passive mode?
Does device discovery work when the endpoint has MDE antivirus set to passive mode? Read More
Excel: SUM and SUMIF
Hi all, I am preparing an excel file and I have an issue with the SUM formula.
In the file, I added a checkbox that will give 0 if FALSE (not ticked) or 125 is TRUE (ticked).
For this I used the formula =SUMIF(K21,TRUE,M21) where:
K21 is the true/false cell linked to the checkbox
M21 is 125
What I want to achieve is: When the box is ticked, add 125 to the final amount (in cell J37) and sum all prices in cells J26:J35 (and when the checkbox is not ticked, then 125 should not appear in the total sum).
Both formulas:
=SUMIF(K21,TRUE,M21)
=SUM(J26:J35)
Work separately, but they do not work together in the same cell, as I would like to have just one final cell (J37) that includes the amounts J26:J35 & SUMIF(K21,TRUE,M21).
Could you please help me with this?
Hi all, I am preparing an excel file and I have an issue with the SUM formula. In the file, I added a checkbox that will give 0 if FALSE (not ticked) or 125 is TRUE (ticked). For this I used the formula =SUMIF(K21,TRUE,M21) where:K21 is the true/false cell linked to the checkboxM21 is 125 What I want to achieve is: When the box is ticked, add 125 to the final amount (in cell J37) and sum all prices in cells J26:J35 (and when the checkbox is not ticked, then 125 should not appear in the total sum). Both formulas:=SUMIF(K21,TRUE,M21)=SUM(J26:J35)Work separately, but they do not work together in the same cell, as I would like to have just one final cell (J37) that includes the amounts J26:J35 & SUMIF(K21,TRUE,M21). Could you please help me with this? Read More
What is this Windows 11 Enterprise G version of windows?
My first time to see this version. Anyone knows about it?
My first time to see this version. Anyone knows about it? Read More
BYCOL & BYROW
Hi,
Below formula throwing #Calc error:
Need one array formula.
Hi, Below formula throwing #Calc error:BYCOL(C3#,LAMBDA(ColHdrs_1,BYROW(B4#,LAMBDA(RowHdrs_1,IFERROR(COUNTA(UNIQUE(FILTER($K$3:$K$25,($I$3:$I$25=RowHdrs_1)*($J$3:$J$25=ColHdrs_1)))),0))))) Need one array formula.Sheet Read More
Integrating Power BI with Azure Data Services
Integrating Power BI with Azure Data Services
Introduction
Hi, I am Khalid Abdelaty a Microsoft Learn Student Ambassador, studying Computer Science Student @ Tanta University in Egypt. I am fancisanted by the opportunity of AI and the ability to analyze and interpret data.
Power BI has seen massive growth in the past couple of years in the IT industry. With the exponential growth of data, employees face challenges in data governance. To manage this unmeasurable data, we need reliable storage solutions. Microsoft Azure facilitates the integration of Power BI with services such as SQL, Stream Analytics, and many others. This combination enhances the ability to work with complex data efficiently.
In this article, we will discuss the following topics:
What Azure services can we connect to Power BI?
Hands-on: Integrate Power BI with Azure
FAQs
Conclusion
What Azure Services Can We Connect to Power BI?
By combining Azure services with Power BI, you can transform data processing efforts into analytics and reports for real-time insights that benefit your business. Azure Power BI has built-in connectivity and integration to develop complex business intelligence solutions without the need for coding.
We can connect the following Azure services with Power BI:
Azure SQL Database
Stream Analytics
Azure ML
Azure Event Hub
Azure Storage
Azure HDInsight
Hands-on: Integrate Power BI with Azure
Step-by-Step Guide to Connecting Azure SQL Database with Power BI:
Go to Azure Portal and click create a resource.
2. Search for Azure SQL and press enter.
3. Select the resource type as Single Database and click on create.
4. Fill in the necessary details such as specifying a resource group, creating a server for the database, then click on review and create and finally click on create.
You will notice that the deployment is in progress. Once the database is deployed, open it.
5. Now, we will add some data into the SQL database. For that, go to your SQL database and click on query editor. Enter the credentials you set while creating the server for the database.
6. Let’s add a simple query and run it :
CREATE TABLE Person (
PersonId INT IDENTITY PRIMARY KEY,
FirstName NVARCHAR(128) NOT NULL,
MiddelInitial NVARCHAR(10),
LastName NVARCHAR(128) NOT NULL,
DateOfBirth DATE NOT NULL
);
CREATE TABLE Student (
StudentId INT IDENTITY PRIMARY KEY,
PersonId INT REFERENCES Person (PersonId),
Email NVARCHAR(256)
);
CREATE TABLE Course (
CourseId INT IDENTITY PRIMARY KEY,
Name NVARCHAR(50) NOT NULL,
Teacher NVARCHAR(256) NOT NULL
);
CREATE TABLE Credit (
StudentId INT REFERENCES Student (StudentId),
CourseId INT REFERENCES Course (CourseId),
Grade DECIMAL(5,2) CHECK (Grade <= 100.00),
Attempt TINYINT,
CONSTRAINT [UQ_studentgrades] UNIQUE CLUSTERED (
StudentId, CourseId, Grade, Attempt
)
);
7. Next step is to add data to the table. Select the dbo.course table and add rows to it by clicking on Create New Row.
Now we have the data present in the SQL database. Now we will visualize the data in Power BI.
8. Click on Power BI (preview) option under the Power platform and click on get started, and it will download the pbids file as shown below
9. Open the pbi file, and it will open up the Power BI desktop application. It will ask for the username and password under Database. Provide the username and password you set while creating a database server.
As we added some sample values under the course table, preview the data by clicking on course and click on load.
As you can see that we added CourseID, Name, and Teacher rows.
Just check the CourseID, Name, and Teacher. It will create a visualization out of this data. You can choose any visualization from the visualization section, as shown below.
Hence it is a straightforward process to create a visualization using Power BI Integration with Azure.
FAQs
Q1: How does Power BI integrate with Azure?
Ans: Power BI integrates with Azure services to provide real-time business insights through seamless data analytics and reporting.
Q2: Does Power BI work with Azure?
Ans: Yes, Power BI works with Azure to unify data and simplify complex datasets through visualizations.
Q3: What is the use of Power BI embedded in Azure?
Ans: Power BI embedded allows developers to integrate interactive reports and dashboards into applications quickly, transforming data into graphical forms.
Conclusion
Integrating Power BI with Azure provides stability and enhances the ability to handle large data volumes. With easy connectivity and powerful visualizations, users can leverage Azure’s enhanced governance and cataloging capabilities for insightful data analysis.
Microsoft Tech Community – Latest Blogs –Read More
Display list filtered by a fixed filter in webpart in Sharepoint365
Hello everyone,
please help me out, as I am starting to despair. Here’s what I am trying to do:
I have a List of processes and a separate List of all process steps of all processes. I am using a lookup field to connect those steps to their respective process. For easier use, I want to create a SharePoint page for each process, showing, among other things, a list of the steps of this specific process.
Seems straightforward but, for now, I haven’t found a way to create this filtered view on the List of steps in an embed.
I’ve tried three ways:
1. Using the List web part, there seems to be no way to define a fixed filter.
2. Using a list view filtered by URL parameters embedded using the embed web part – technically works but looks ugly, as it doesn’t display only the list, but several control bars, which I can only remove in parts using JSON view formatting. The “?env=Embedded” parameter also seems to be doing nothing…
3. Creating a pre-defined list view in Lists and embedding this – also technically works but is a lot of manual work and there appears to be no way to filter a view on a hidden column, so I would have to display the name of the process as well which is redundant information.
My last resort would be creating a separate List for each process, but that seems a bit excessive and would massively hinder further extensions of the system.
Any other ideas?
Thanks!
Nils
Hello everyone, please help me out, as I am starting to despair. Here’s what I am trying to do: I have a List of processes and a separate List of all process steps of all processes. I am using a lookup field to connect those steps to their respective process. For easier use, I want to create a SharePoint page for each process, showing, among other things, a list of the steps of this specific process. Seems straightforward but, for now, I haven’t found a way to create this filtered view on the List of steps in an embed. I’ve tried three ways: 1. Using the List web part, there seems to be no way to define a fixed filter. 2. Using a list view filtered by URL parameters embedded using the embed web part – technically works but looks ugly, as it doesn’t display only the list, but several control bars, which I can only remove in parts using JSON view formatting. The “?env=Embedded” parameter also seems to be doing nothing… 3. Creating a pre-defined list view in Lists and embedding this – also technically works but is a lot of manual work and there appears to be no way to filter a view on a hidden column, so I would have to display the name of the process as well which is redundant information. My last resort would be creating a separate List for each process, but that seems a bit excessive and would massively hinder further extensions of the system. Any other ideas? Thanks! Nils Read More
Need a powershell script to change the default font from Aptos to Verdana in powerpoint
Hi Champs,
Does anyone could provide a powershell script to change the default font from Aptos to Verdana in powerpoint please.
We are in a intune environment. I want to push it to all the devices. Please assist.
Thanks,
Ram
Hi Champs, Does anyone could provide a powershell script to change the default font from Aptos to Verdana in powerpoint please.We are in a intune environment. I want to push it to all the devices. Please assist. Thanks,Ram Read More
Auto save on file opening
I am using OneDrive on Windows 11. I manage all my files with OneDrive. I manage the documents with the Windows Explorer file structure on my computer by creating a shortcut via MS Teams or SharePoint.
OneDrive is always in sync mode on my computer. It updates automatically whenever I make changes to any file. But the important detail is “when I update” 🙂
I have a problem with OneDrive for a while. I don’t know if this is due to OneDrive.
When I open any file, the file is somehow automatically saved and synced to OneDrive, even if I don’t make any changes to the file. Unfortunately, this way I miss the previous modification date of the file etc.
Of course, I can go and look at this in the version history, but the date of the last permanent file is updated as my current file opening date.
This is not something that happens in every file, but it becomes annoying because I cannot predict when it will happen or not.
Has anyone ever encountered a similar situation and found a solution?
Thank you in advance for your reply.
I am using OneDrive on Windows 11. I manage all my files with OneDrive. I manage the documents with the Windows Explorer file structure on my computer by creating a shortcut via MS Teams or SharePoint.OneDrive is always in sync mode on my computer. It updates automatically whenever I make changes to any file. But the important detail is “when I update” :)I have a problem with OneDrive for a while. I don’t know if this is due to OneDrive.When I open any file, the file is somehow automatically saved and synced to OneDrive, even if I don’t make any changes to the file. Unfortunately, this way I miss the previous modification date of the file etc.Of course, I can go and look at this in the version history, but the date of the last permanent file is updated as my current file opening date.This is not something that happens in every file, but it becomes annoying because I cannot predict when it will happen or not.Has anyone ever encountered a similar situation and found a solution?Thank you in advance for your reply. Read More
Why FQDN resolution gets affected when Network Protection is in disabled state.
Why FQDN resolution gets affected when Network Protection is in disabled state?
Is it forcing user to use Network Protection?
Isn’t disable state for not interfering with Network?
Why FQDN resolution gets affected when Network Protection is in disabled state?Is it forcing user to use Network Protection?Isn’t disable state for not interfering with Network? Read More