A common ask from users is the ability to view data related to visuals in excel. While there is an option to export data, the format is often unfriendly and has limitations. What’s more, this data becomes disconnected and is not updated if a user looks at after the data is refreshed. This post will Read More
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
How to Enable External Forwarding in Microsoft 365
When setting up forwarding from Microsoft 365 (formerly referred to as Office 365) to Help Scout, you may need to take an additional step to complete the process. Some Microsoft 365 accounts default to block automatic email forwarding as part of their outbound spam protection. If external forwarding is disabled for your Microsoft 365 account, Read More
How to Merge Columns to Create a New Column in Power Query (Power BI and Excel)
Merge columns (Power Query) Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 In Power Query, you can merge two or more columns in your query. You can merge columns to replace them with one merged column, or create a new merged column alongside the columns that are merged. You can only merge columns of a Text data Read More
How to Add a New Column by Lookup the Values from Another Table in Power BI – LOOKUPVALUE
This article is about LOOKUPVALUE function, which assigns values from another table. There doesn’t have to be a relationship between these tables. How to use it? In this example, we need to connect data from these two tables. One of them contains info about sales, but we miss the prices of items. The prices are Read More
Power BI and SSRS Comparison
Below is the comparison table between Power BI and SSRS. Basis For Comparison Power BI SSRS Definition Power bi stands for power business intelligence which is the product of Microsoft. Used for analysis and generating the reports from the cloud as well as server SSRS stands for SQL server reporting services, it is also a Read More
How to Fix “The User Profile Service Failed the Sign-in” Error in Windows 10
Windows 10 User Profile Cannot Be Loaded “Hey, recently I have experienced a weird thing. There is something wrong with my Windows 10. Whenever I try to log in it says “The User Profile Service failed sign-in. The User Profile cannot be loaded.” I can’t enter my Windows 10 as usual. Can there anybody help Read More