Capture2

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

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

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