Capture2

How to Load Data from an OData Feed into Power Query Desktop and Online

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 […]

Capture2

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 […]

Capture2

How to Import Data from OData to Azure Data Factory

by Gauri Mahajan In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories. Introduction Data practice has the following major part – Data Collection, Data Preparation and Curation, Data Management, and Data Consumption. Typically, data consumption is viewed as a practice of accessing data […]

Capture2

How to Set up SQL Data Sync Between Databases in Azure SQL Database and SQL Server

In this tutorial, you learn how to set up SQL Data Sync by creating a sync group that contains both Azure SQL Database and SQL Server instances. The sync group is custom configured and synchronizes on the schedule you set. The tutorial assumes you have at least some prior experience with SQL Database and SQL […]

Capture2

Features Comparison: Azure SQL Database and Azure SQL Managed Instance

APPLIES TO:  Azure SQL Database  Azure SQL Managed Instance Azure SQL Database and SQL Managed Instance share a common code base with the latest stable version of SQL Server. Most of the standard SQL language, query processing, and database management features are identical. The features that are common between SQL Server and SQL Database or SQL Managed […]

Capture2

How to Change Your Two-step Verification Method and Settings in Office 365

After you set up your security verification methods for your work or school account, you can update any of the related details, including: Default security verification method Security verification method details, like your phone number Authenticator app setup or deleting a device from the authenticator app Using the Additional security verification page If your organization […]