jira-to-power-biimport-export

How to Import JIRA data in Power BI

Introduction In our previous blog we saw how to import rest api in Power BI. We recommend you go through that article first. In this article, we will learn how to Import JIRA data in Power BI. For that, we will create a successful HTML Connection then request for reading JIRA data and loading into Power […]

How to Import Amazon MWS data in Power BI

Introduction In our previous blog we saw how to call REST API in Power BI to import data from JSON based REST API services. Now let’s continue on that and learn how to import Amazon MWS data in Power BI using XML driver. To learn more about how to consume Amazon MWS data in ETL […]

Power BI Integration

How to read NetSuite data in Power BI

Introduction In our previous blog we discussed how to import REST / SOAP API data in Power BI. Now we will use that knowledge to read NetSuite data in Power BI (NetSuite CRM – SuiteTalk). We will use ZappySys XML Driver to call Search function in NetSuite SOAP API. If you are not familiar with SOAP […]

How to Import LinkedIn data in Power BI

Introduction In this article, we will learn how to import LinkedIn data in Power BI. For that, we will create a successful OAuth Connection then request for reading LinkedIn Profile data and loading into Power BI Power BI is a very popular Business Analytic tool used to get business information. It is very popular because it […]

Power BI Integration

Read Amazon S3 data in Power BI or Call AWS REST API (JSON / XML)

Introduction If you are looking around to find connectivity options to get Amazon AWS data in Power BI (e.g. Read from Amazon S3 files (CSV, JSON, XML) or get AWS API data such as Billing Data by calling REST API) then unfortunately as of now Power BI doesn’t support it natively. In this article, you will […]

Power BI Integration

Calling SOAP API in Power BI (Read XML Web Service data)

Introduction In our previous post, we saw in general how to call REST API in Power BI. Now let’s look at how to call SOAP API in Power BI (e.g. WorkDay, Google AdWords services). SOAP API is in XML format so we will be using ZappySys XML Driver for a demonstration in this article. To […]

Introduction icon json to power bi

How to import REST API in Power BI (Load JSON / SOAP XML)

Introduction In this article, we will learn how to import REST API in Power BI. Power BI is a very popular Business Analytic tool used to get business information. It is very popular because it is easy to install, simple to learn and very intuitive. Also, REST API is very popular these days and we […]