Summary Item Description Release State General Availability Products Power BI (Datasets)Power BI (Dataflows)Power Apps (Dataflows)ExcelDynamics 365 Customer InsightsAnalysis Services Authentication Types Supported AnonymousWindowsBasic (requires Gateway)Web APIOrganizational Account Function Reference Documentation OData.Feed, ODataOmitValues.Nulls Note Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities. Load data from an OData Read More
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
Understand OData Connection Manager in SSIS
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory Connect to an OData data source with an OData connection manager. An OData Source component uses an OData connection manager to connect to an OData data source and consume data from the service. For more info, see OData Source. Adding an OData Connection Manager Read More
How to Download OData Source to SQL or a TXT File in SSIS
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory This tutorial walks you through the process to extract the Employees collection from the sample Northwind OData service (https://services.odata.org/V3/Northwind/Northwind.svc/), and then load it into a flat-file. 1. Create an Integration Services project Launch SQL Server Data Tools or Visual Studio. Click File, point to New, and click Project. In the New Project dialog box, Read More
How to Do Lookups with Returning Multiple Column Values
This is the first post in a series where we’ll talk about how to use the FILTER function as an alternative to lookup functions including VLOOKUP. Why? Well, as we’ll discover in this series, the FILTER function offers several key benefits. For example, FILTER supports: Multiple return columns Multiple lookup columns Multiple matching row values In this first post, we’ll see Read More
How to Filter Out Multiple Criteria Using Excel VBA
Questions: I have 8 variables in columns A, 1,2,3,4,5, and A, B, C.My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But what the code does is filters variables 1 to 5 and display them. I want to do the opposite but yield Read More
Understand What is Retire / Wipe / Delete / Fresh Start / Autopilot Reset in Microsoft Intune
It feels there are a million different reset options in Microsoft’s endpoint manager (aka Intune). Some of the options even provide additional „suboptions“. I would like to explain the different options, their differences, and their main use cases here. If you prefer it short and concise summary can be found at the end. Retire/Delete Let us get Read More