The XLOOKUP function is useful when you need to find something in a table or range. Learn how to use the XLOOKUP function in Excel. If you use Excel a lot, you have probably used LOOKUP functions quite often. If you’re not familiar, the LOOKUP function is used to search through a single row or Read More
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
How to Disable Frequent folders or Recent Files in Windows 10 Quick Access
Windows 10 Quick access feature shows your frequently used folders and recently accessed files in File Explorer. While this is great feature, Windows 10 also gives you option to disable frequent folders or recent files in Quick Access. Go to View menu and click “Options” to open “Folder Options” dialog. Disable recent files: In Folder Options Read More
Best Text Editors: For Linux, Mac, and Windows Coders and Programmers
A text editor may sound boring to some, but it’s the lifeblood of so many organizations around the world. From development teams to publishers, text and code editors are intertwined with almost everyone’s workflows. Many of us bounce in and out of them all day long. Whether you’re writing PHP, or simply taking notes for a project, there Read More
How to Create a Dataflow in PowerBI Workspaces
A dataflow is a collection of tables that are created and managed in workspaces in the Power BI service. A table is a set of columns that are used to store data, much like a table within a database. You can add and edit tables in your dataflow, as well as manage data refresh schedules, directly from the workspace Read More
Understand Dataflows in PowerBI
Introduction to dataflows and self-service data prep As data volume continues to grow, so does the challenge of wrangling that data into well-formed, actionable information. We want data that’s ready for analytics, to populate visuals, reports, and dashboards, so we can quickly turn our volumes of data into actionable insights. With self-service data prep for Read More
How to Connect a Dataflow in Power BI Workspace
In Power BI Desktop, you can connect to data created by Power Platform dataflows just like any other data source in Power BI Desktop. Select Power Platform > Dataflows. The Power Platform dataflows connector lets you connect to entities created by dataflows in the Power BI service. Considerations and limitations To use the Power Platform dataflows connector, you must Read More