{"id":3933,"date":"2018-06-14T13:36:33","date_gmt":"2018-06-14T13:36:33","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=3933"},"modified":"2018-06-19T02:23:47","modified_gmt":"2018-06-19T02:23:47","slug":"call-soap-api-power-bi-read-xml-web-service-data","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/","title":{"rendered":"Calling SOAP API in Power BI (Read XML Web Service data)"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3951 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\" alt=\"Power BI Integration\" width=\"109\" height=\"109\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png 310w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310-300x300.png 300w\" sizes=\"(max-width: 109px) 100vw, 109px\" \/><\/a>In our <a href=\"https:\/\/zappysys.com\/blog\/howto-import-json-rest-api-power-bi\/\" target=\"_blank\" rel=\"noopener\">previous post<\/a>, we saw in general how to <strong>call REST API in Power BI<\/strong>. Now let&#8217;s look at how to <strong>call SOAP API in Power BI<\/strong> (e.g. <a href=\"https:\/\/zappysys.com\/blog\/get-data-from-workday-in-ssis-using-soap-or-rest-api\/\" target=\"_blank\" rel=\"noopener\">WorkDay<\/a>, Google AdWords services). SOAP API is in XML format so we will be using ZappySys XML Driver for a demonstration in this article.<\/p>\n<p>To learn how to automate dataset refresh on a scheduled basis you can again refer to the <a href=\"https:\/\/zappysys.com\/blog\/howto-import-json-rest-api-power-bi\/\" target=\"_blank\" rel=\"noopener\">previous post<\/a>\u00a0because that won&#8217;t be covered in this article.<\/p>\n<p>So let&#8217;s get started !!!<\/p>\n<h2 style=\"text-align: left;\">Requirements<\/h2>\n<ol>\n<li>First, you will need to have <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/desktop\/\" target=\"_blank\" rel=\"noopener\">Power BI Desktop (FREE)<\/a> installed<\/li>\n<li>Make sure you have <a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/\">ZappySys ODBC Power Pack<\/a>\u00a0installed<\/li>\n<\/ol>\n<h2>Creating SQL Queries to call SOAP API in Power BI\u00a0(Using XML Driver)<\/h2>\n<p>Very first step to call SOAP API in Power BI is to understand how to craft SOAP Requests using ZappySys XML Driver. Once you play with sample SOAP queries you can copy\/paste that into Power BI.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-3870\">To call SOAP API you need to know Request XML Body Structure.\u00a0If you are not sure how to create SOAP Request body then no worries. <a href=\"https:\/\/zappysys.com\/blog\/calling-soap-web-service-in-ssis-xml-source\/\" target=\"_blank\" rel=\"noopener\">Check this article<\/a> to learn how to generate SOAP Request body using the Free tool <a href=\"https:\/\/www.soapui.org\/downloads\/latest-release.html\" target=\"_blank\" rel=\"noopener\">SoapUI<\/a>. Basically, you have to use SoapUI to generate Request XML and after that, you can replace parameters as needed in the generated body.\r\n<h3>What is SOAP Web Service?<\/h3>\r\nIf you are new to SOAP Web Service sometimes referred as XML Web Service then please read some concept\u00a0about\u00a0SOAP\u00a0Web service standard <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms996507.aspx?f=255&amp;MSPPError=-2147217396\" target=\"_blank\" rel=\"noopener\">from this link<\/a>\r\n\r\nThere are two important aspects in SOAP Web service.\r\n<ol>\r\n \t<li>Getting WSDL file or URL<\/li>\r\n \t<li>Knowing exact Web Service URL<\/li>\r\n<\/ol>\r\n<h3>What is WSDL<\/h3>\r\nIn very simple term WSDL (often pronounced as whiz-dull) is nothing but a document which describes Service metadata (e.g. Functions you can call, Request parameters, response structure etc). Some service simply give you WSDL as xml file you can download on local machine and then\u00a0analyze or sometimes you may get direct URL (e.g. http:\/\/api.mycompany.com\/hr-soap-service\/?wsdl )\r\n<h3>Example SQL Query for SOAP API call using ZappySys XML Driver<\/h3>\r\nHere is an example SQL query you can write to call SOAP API. If you not sure about many details then check next few sections on how to use XML Driver User Interface to build desired SQL query to POST data to XML SOAP Web Service without any coding.\r\n<pre class=\"lang:tsql decode:true\">SELECT * FROM $\r\nWITH(\r\n\t Src='http:\/\/www.holidaywebservice.com\/HolidayService_v2\/HolidayService2.asmx'\r\n\t,DataConnectionType='HTTP'\r\n\t,CredentialType='Basic' --OR SoapWss\r\n\t,SoapWssPasswordType='PasswordText'\r\n\t,UserName='myuser'\r\n\t,Password='pass$$w123'\r\n\t,Filter='$.soap:Envelope.soap:Body.GetHolidaysAvailableResponse.GetHolidaysAvailableResult.HolidayCode[*]'\r\n\t,ElementsToTreatAsArray='HolidayCode'\t\r\n\t,RequestMethod='POST'\t\r\n\t,Header='Content-Type: text\/xml;charset=UTF-8 || SOAPAction: \"http:\/\/www.holidaywebservice.com\/HolidayService_v2\/GetHolidaysAvailable\"'\r\n\t,RequestData='\r\n&lt;soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:hol=\"http:\/\/www.holidaywebservice.com\/HolidayService_v2\/\"&gt;\r\n   &lt;soapenv:Header\/&gt;\r\n   &lt;soapenv:Body&gt;\r\n      &lt;hol:GetHolidaysAvailable&gt;\r\n         &lt;!--type: Country - enumeration: [Canada,GreatBritain,IrelandNorthern,IrelandRepublicOf,Scotland,UnitedStates]--&gt;\r\n         &lt;hol:countryCode&gt;UnitedStates&lt;\/hol:countryCode&gt;\r\n      &lt;\/hol:GetHolidaysAvailable&gt;\r\n   &lt;\/soapenv:Body&gt;\r\n&lt;\/soapenv:Envelope&gt;'\r\n)<\/pre>\r\nNow let's look at steps to create SQL query to call SOAP API. Later we will see how to generate code for your desired programming language (e.g. C# or SQL Server)\r\n<h3>Video Tutorial - Introduction to SOAP Web Service and SoapUI tool<\/h3>\r\nBefore we dive into details about calling SOAP API using ZappySys XML Driver, lets first understand what is SOAP API and how to create SOAP requests using SoapUI tool. You will learn more about this process in the\u00a0later section. The video contains some fragment about using SOAP API in SSIS but just ignore that part because we will be calling Soap API using ZappySys ODBC Driver rather than SSIS Components.\r\n\r\n&nbsp;\r\n\r\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/d_x5bgGjg0Y?rel=0&amp;showinfo=0\" frameborder=\"0\" allow=\"autoplay; encrypted-media\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe>\r\n<h3>Using SoapUI to test SOAP API call \/ Create Request Body XML<\/h3>\r\nAssuming you have downloaded and installed <a href=\"https:\/\/www.soapui.org\/downloads\/latest-release.html\" target=\"_blank\" rel=\"noopener\">SoapUI from here<\/a>, now we are ready to use WSDL for your SOAP Web Service Calls. If you do not have WSDL file or URL handy then contact your API provider (sometimes you just have to add <strong>?wsdl\u00a0<\/strong>at the end of your Service URL to get WSDL so try that. Example: http:\/\/mycompany\/myservice?wsdl ).\r\n\r\nIf you don't\u00a0know what is WSDL then in short, WSDL is <strong>Web service Description Language<\/strong> (i.e. XML file which describes your SOAP Service). WSDL helps to craft SOAP API request Body for ZappySys XML Driver. So Let's get started.\r\n<ol>\r\n \t<li>Open SoapUI and click SOAP button to create new SOAP Project<\/li>\r\n \t<li>Enter WSDL URL or File Path of WSDLFor example WSDL for our sample service can be accessed via this URL\r\n<pre class=\"lang:default highlight:0 decode:true\">http:\/\/www.dneonline.com\/calculator.asmx?wsdl<\/pre>\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/calling-soap-api-import-wsdl-new-soapui-project.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3871\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-14.png\" alt=\"Create new SOAP API Project in SoapUI tool for SOAP API Testing\" width=\"486\" height=\"349\" \/><\/a>\r\n<div style=\"margin-bottom: 1em;\">Create new SOAP API Project in SoapUI tool for SOAP API Testing<\/div><\/li>\r\n \t<li>Once WSDL is loaded you will see possible operations you can call for your SOAP Web Service.<\/li>\r\n \t<li>If your web service requires credentials then you have to configure it. There are two common credential types for public services (<strong>SOAP WSS<\/strong> or <strong>BASIC<\/strong> )\r\n<ol>\r\n \t<li>\r\n<div style=\"margin-bottom: 1em;\">To use <strong>SOAP WSS Credentials<\/strong> select request node and enter UserId, Password, and <strong>WSS-PasswordType<\/strong> (PasswordText or PasswordHash)<\/div>\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/calling-soap-api-pass-soap-wss-credentials-userid-password.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3872 alignnone\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-2.png\" alt=\"Configure SOAP WSS Credentials for SoapUI (SOAP API Testing Tool)\" width=\"294\" height=\"544\" \/><\/a>\r\n<div style=\"display: block;\">Configure SOAP WSS Credentials for SoapUI (SOAP API Testing Tool)<\/div><\/li>\r\n \t<li>To use <strong>BASIC Auth<\/strong> Credentials select request node and double-click it.\u00a0At the bottom click on Auth (Basic) and From Authorization dropdown click Add New and Select Basic.<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/calling-soap-api-pass-basic-authentication-userid-password.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3873\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-2.png\" alt=\"Configure Basic Authorization for SoapUI (SOAP API Testing Tool)\" width=\"616\" height=\"653\" \/><\/a>\r\n<div style=\"margin-bottom: 1em;\">Configure Basic Authorization for SoapUI (SOAP API Testing Tool)<\/div><\/li>\r\n<\/ol>\r\n<\/li>\r\n \t<li>Now you can test your request first Double-click on the request node to open request editor.<\/li>\r\n \t<li>Change necessary parameters, remove optional or unwanted parameters. If you want to regenerate request you can click on <strong>Recreate default request toolbar icon<\/strong>.\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/create-soap-request-with-optional-parameters-soapui.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2812\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-4.png\" alt=\"Create SOAP Request XML (With Optional Parameters)\" width=\"807\" height=\"315\" \/><\/a>\r\n<div style=\"margin-bottom: 1em;\">Create SOAP Request XML (With Optional Parameters)<\/div><\/li>\r\n \t<li>Once your SOAP Request XML is ready, <strong>Click the Play button<\/strong> in the toolbar to execute SOAP API Request and Response will appear in Right side panel.\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/soapui-test-soap-api-request-response-edit-xml-body.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3874\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-5.png\" alt=\"Test SOAP API using SoapUI Tool (Change Default XML Body \/ Parameters, Execute and See Response)\" width=\"1216\" height=\"511\" \/><\/a>\r\nTest SOAP API using SoapUI Tool (Change Default XML Body \/ Parameters, Execute and See Response)<\/li>\r\n<\/ol>\r\n<h3>Create DSN using ZappySys XML Driver to call SOAP API<\/h3>\r\nOnce you have tested your SOAP API in SoapUI tool, we are ready to use ZappySys XML driver to call SOAP API in your preferred BI tool or Programming language.\r\n<ol>\r\n \t<li>First open <strong>ODBC Data Sources<\/strong> (search ODBC in your start menu\u00a0or go under ZappySys &gt; ODBC PowerPack &gt; <strong>ODBC 64 bit<\/strong>)<\/li>\r\n \t<li>Goto <strong>System DSN<\/strong> Tab (or User DSN which is not used by Service account)<\/li>\r\n \t<li>Click <strong>Add<\/strong> and Select ZappySys XML Driver\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/zappysys-odbc-xml-soap-api-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3875\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-6.png\" alt=\"ZappySys ODBC Driver for XML \/ SOAP API\" width=\"593\" height=\"459\" \/><\/a>\r\nZappySys ODBC Driver for XML \/ SOAP API<\/li>\r\n \t<li>Configure API URL, Request Method and Request Body as below\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/calling-soap-web-service-zappysys-xml-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3876\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-7.png\" alt=\"ZappySys XML Driver - Calling SOAP API - Configure URL, Method, Body\" width=\"916\" height=\"874\" \/><\/a>\r\nZappySys XML Driver - Calling SOAP API - Configure URL, Method, Body<\/li>\r\n \t<li><strong>(This step is Optional)<\/strong> If your SOAP API requires credentials then Select Connection Type to HTTP and configure as below.\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/soap-api-call-credential-basic-soap-wss-zappysys-xml-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3877\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-8.png\" alt=\"ZappySys XML Driver - Configure SOAP WSS Credentials or Basic Authorization (Userid, Password)\" width=\"564\" height=\"483\" \/><\/a>\r\n<div style=\"display: block;\">ZappySys XML Driver - Configure SOAP WSS Credentials or Basic Authorization (Userid, Password)<\/div><\/li>\r\n \t<li>Configure-Request Headers as below (You can get it from Request &gt; Raw tab from SoapUI after you test the request by clicking the Play button)\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/set-soap-api-request-headers-zappysys-xml-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3881\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-9.png\" alt=\"Configure SOAP API Request Headers - ZappySys XML Driver\" width=\"1009\" height=\"747\" \/><\/a>\r\nConfigure SOAP API Request Headers - ZappySys XML Driver<\/li>\r\n \t<li>Once credentials entered you can select Filter to extract data from the desired node. Make sure to select array node (see special icon) or select the node which contains all necessary columns if you don't have array node.\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/soap-api-query-select-filter-zappysys-xml-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3882\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-10.png\" alt=\"Select Filter - Extract data from nested XML \/ SOAP API Response (Denormalize Hierarchy)\" width=\"809\" height=\"594\" \/><\/a>\r\nSelect Filter - Extract data from nested XML \/ SOAP API Response (Denormalize Hierarchy)<\/li>\r\n \t<li>If prompted select yes to treat selected node as Array (This is helpful when you expect one or more record for selected node)\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/xml-api-array-handling-zappysys-xml-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3883\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-11.png\" alt=\"Treat selected node as XML Array Option for SOAP API Response XML\" width=\"655\" height=\"572\" \/><\/a>\r\nTreat selected node as XML Array Option for SOAP API Response XML<\/li>\r\n<\/ol>\r\n<h3>Preview SOAP API Response \/ Generate SQL Code for SOAP API Call<\/h3>\r\nOnce you configure settings for XML Driver now you can preview data or generate example code for desired language (e.g. C#, Python, Java, SQL Server).\r\n\r\nGo to Preview tab and you will see default query generated based on settings you entered in previous sections. Attributes listed in WITH clause are optional. If you omit attribute in WITH clause it will use it from Properties tab.\r\n<h3>Preview Data<\/h3>\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/calling-soap-web-service-zappysys-xml-api-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3884\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-12.png\" alt=\"Preview SOAP API Response in ZappySys XML Driver\" width=\"808\" height=\"780\" \/><\/a>\r\nPreview SOAP API Response in ZappySys XML Driver\r\n<h3>Generate Code Option<\/h3>\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/zappysys-driver-code-generator.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3885\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-call-soap-api-13.png\" alt=\"Generate Example Code for ZappySys Driver\" width=\"572\" height=\"618\" \/><\/a>\r\n<div style=\"display: block;\">Generate Example Code for ZappySys Driver<\/div><\/div>\n<h2>Import XML SOAP Web Service in Power BI (Using XML Driver)<\/h2>\n<p>Once you know how to craft SQL Queries for SOAP API calls, and you save created DSN as per the\u00a0previous section we are ready to load data into Power BI from XML Web Service.<\/p>\n<p>So let&#8217;s get started.<\/p>\n<ol>\n<li>First launch Power BI and Click on Get Data &gt;&gt; More Data &gt;&gt; Other &gt;&gt; ODBC\n<div id=\"attachment_3945\" style=\"width: 545px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-data-xml-soap-web-service-call-odbc-xml-api-driver.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3945\" class=\"size-full wp-image-3945\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-data-xml-soap-web-service-call-odbc-xml-api-driver.png\" alt=\"Import SOAP API in Power BI (Using ZappySys XML ODBC Driver)\" width=\"535\" height=\"590\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-data-xml-soap-web-service-call-odbc-xml-api-driver.png 535w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-data-xml-soap-web-service-call-odbc-xml-api-driver-272x300.png 272w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><p id=\"caption-attachment-3945\" class=\"wp-caption-text\">Import SOAP API in Power BI (Using ZappySys XML ODBC Driver)<\/p><\/div><\/li>\n<li>Select your ODBC DSN Source from the dropdown (Assuming you have created a ODBC Data Source using ZappySys XML Driver &#8211; See the previous Section)<\/li>\n<li>Expand Advanced Options to enter custom Query.<\/li>\n<li>Enter your SOAP API call SQL query here. For example purpose, we will use below query to try demo\u00a0SOAP web service.\n<pre class=\"lang:tsql decode:true \">SELECT * FROM $\r\nWITH(\r\n\t Src='http:\/\/www.holidaywebservice.com\/HolidayService_v2\/HolidayService2.asmx'\r\n\t,DataConnectionType='HTTP'\r\n\t,CredentialType='Basic' --OR SoapWss\r\n\t,SoapWssPasswordType='PasswordText'\r\n\t,UserName='myuser'\r\n\t,Password='pass$$w123'\r\n\t,Filter='$.soap:Envelope.soap:Body.GetHolidaysAvailableResponse.GetHolidaysAvailableResult.HolidayCode[*]'\r\n\t,ElementsToTreatAsArray='HolidayCode'\t\r\n\t,RequestMethod='POST'\t\r\n\t,Header='Content-Type: text\/xml;charset=UTF-8 || SOAPAction: \"http:\/\/www.holidaywebservice.com\/HolidayService_v2\/GetHolidaysAvailable\"'\r\n\t,RequestData='\r\n&lt;soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:hol=\"http:\/\/www.holidaywebservice.com\/HolidayService_v2\/\"&gt;\r\n   &lt;soapenv:Header\/&gt;\r\n   &lt;soapenv:Body&gt;\r\n      &lt;hol:GetHolidaysAvailable&gt;\r\n         &lt;!--type: Country - enumeration: [Canada,GreatBritain,IrelandNorthern,IrelandRepublicOf,Scotland,UnitedStates]--&gt;\r\n         &lt;hol:countryCode&gt;UnitedStates&lt;\/hol:countryCode&gt;\r\n      &lt;\/hol:GetHolidaysAvailable&gt;\r\n   &lt;\/soapenv:Body&gt;\r\n&lt;\/soapenv:Envelope&gt;'\r\n)<\/pre>\n<div id=\"attachment_3946\" style=\"width: 952px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-soap-api-xml-web-service-advanced-options-sql.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3946\" class=\"size-full wp-image-3946\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-soap-api-xml-web-service-advanced-options-sql.png\" alt=\"Enter custom SQL to load SOAP Web Service Data in Power BI (ZappySys XML Driver)\" width=\"942\" height=\"713\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-soap-api-xml-web-service-advanced-options-sql.png 942w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-soap-api-xml-web-service-advanced-options-sql-300x227.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-import-soap-api-xml-web-service-advanced-options-sql-768x581.png 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/a><p id=\"caption-attachment-3946\" class=\"wp-caption-text\">Enter custom SQL to load SOAP Web Service Data in Power BI (ZappySys XML Driver)<\/p><\/div><\/li>\n<li>Once you see data preview click OK to import.<\/li>\n<li>After data import is done you can edit your dataset (e.g. remove unwanted columns)<\/li>\n<li>You can also edit Source query after data is imported (See below)\n<div id=\"attachment_3947\" style=\"width: 829px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-edit-data-source-query-after-import.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3947\" class=\"size-full wp-image-3947\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-edit-data-source-query-after-import.png\" alt=\"Edit Power BI Data Source SQL after SOAP Web Service Import\" width=\"819\" height=\"502\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-edit-data-source-query-after-import.png 819w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-edit-data-source-query-after-import-300x184.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-edit-data-source-query-after-import-768x471.png 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><p id=\"caption-attachment-3947\" class=\"wp-caption-text\">Edit Power BI Data Source SQL after SOAP Web Service Import<\/p><\/div><\/li>\n<li>That&#8217;s\u00a0it. Use your dataset to build Power BI dashboard and when you ready to publish just hit Publish Button.<\/li>\n<\/ol>\n<h2><\/h2>\n<h2>Using Parameters in Power BI (Dynamic Query)<\/h2>\n<div class=\"content_block\" id=\"custom_post_widget-3954\">In the real world, many values of your REST \/ SOAP API call may be coming from Parameters. If that's the case for you can try to edit script manually as below. In below example its calling SQL Query with POST method and passing some parameters. Notice below where paraAPIKey is Power BI Parameter (string type). You can use parameters anywhere in your script just like the\u00a0normal variable.\r\n<p \/>\r\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/power-bi-import-odbc-sql-query-pass-parameters-dynamically.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3121 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/power-bi-import-odbc-sql-query-pass-parameters-dynamically.png\" alt=\"Import REST API in Power BI - Using parameters in SQL Query (Edit code - Advanced Mode)\" width=\"629\" height=\"467\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/power-bi-import-odbc-sql-query-pass-parameters-dynamically.png 629w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/power-bi-import-odbc-sql-query-pass-parameters-dynamically-300x223.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/a>\r\n<p \/>\r\n&nbsp;\r\n<pre class=\"lang:default highlight:0 decode:true\">let\r\n    vKey=paraAPIKey,\r\n    Source = Odbc.Query(\r\n\"dsn=ZS - OData Customers\", \r\n\"SELECT * FROM $ WITH (SRC='http:\/\/httpbin.org\/post',\" \r\n&amp; \"METHOD='POST',\" \r\n&amp; \"HEADER='Content-Type:application\/json',\" \r\n&amp; \"BODY=@'{\"\"CallerId\"\":1111, \"\"ApiKey\"\":\"\"\" &amp; vKey &amp; \"\"\"}')\")\r\nin\r\n    Source<\/pre>\r\n&nbsp;\r\n<\/div>\n<h2>SOAP XML \/ REST API pagination in Power BI<\/h2>\n<div class=\"content_block\" id=\"custom_post_widget-3892\"><div style=\"margin-bottom: 1em;\">Even we set up ODBC Data Source to get the data, it may not be enough. Usually, if you are getting a huge data set from API provider, it won't give it to you in one HTTP response. Instead, it gives back only a subset of data and provides a mechanism for data pagination. The good news is that\u00a0<em>ZappySys ODBC Driver<\/em> includes many options to cover virtually any pagination method.<\/div>\r\n<div><span style=\"font-size: 16px;\">Below you will find a few examples of API pagination. If you need something more sophisticated check the below link (the article was written for SSIS PowerPack but UI options and concepts apply to ODBC Driver too):<\/span><\/div>\r\n<div style=\"margin-bottom: 1em;\"><a href=\"https:\/\/zappysys.com\/blog\/ssis-rest-api-looping-until-no-more-pages-found\/\" target=\"_blank\" rel=\"noopener\">https:\/\/zappysys.com\/blog\/ssis-rest-api-looping-until-no-more-pages-found\/<\/a><\/div>\r\n<h3>Paginate by Response Attribute<\/h3>\r\nThis example shows how to paginate API calls where you need to paginate until the last page detected. In this example, next page is indicated by some attribute called nextlink (found in response). If this attribute is missing or null then it stops fetching the next page.\r\n<pre class=\"lang:tsql decode:true codeblock\">SELECT * FROM $\r\nWITH(\r\nSRC=@'https:\/\/zappysys.com\/downloads\/files\/test\/pagination_nextlink_inarray_1.json'\r\n,NextUrlAttributeOrExpr = '$.nextlink'  --keep reading until this attribute is missing. If attribute name contains dot then use brackets like this $.['my.attr.name']\r\n)<\/pre>\r\n<h3>Paginate by URL Parameter (Loop until certain StatusCode)<\/h3>\r\nThis example shows how to paginate API calls where you need to pass page number via URL. The driver keeps incrementing page number and calls next URL until the last page detected (401 error). There are few ways to indicate the last page (e.g. By status code, By row count, By response size). If you don't specify end detection then it will use the default (i.e. No records found).\r\n<pre class=\"lang:tsql decode:true codeblock\">SELECT * FROM $\r\nWITH (\r\nSRC=@'https:\/\/zappysys.com\/downloads\/files\/test\/page-xml.aspx?page=1&amp;mode=DetectBasedOnResponseStatusCode'\r\n,PagingMode='ByUrlParameter'\r\n,PagingByUrlAttributeName='page'\r\n,PagingByUrlEndStrategy='DetectBasedOnResponseStatusCode'\r\n,PagingByUrlCheckResponseStatusCode=401\r\n,IncrementBy=1\r\n)<\/pre>\r\n<h3>Paginate by URL Path (Loop until no record)<\/h3>\r\nThis example shows how to paginate API calls where you need to pass page number via URL Path. The driver keeps incrementing page number and calls next URL until the last page is detected. There are few ways to indicate the last page (e.g. By status code, By row count, By response size). If you don't specify end detection then it will use the default (i.e. No records found).\r\n<pre class=\"lang:tsql decode:true codeblock\">SELECT * FROM $\r\nWITH (\r\nSRC=@'https:\/\/zappysys.com\/downloads\/files\/test\/cust-&lt;%page%&gt;.xml'\r\n,PagingMode='ByUrlPath'\r\n,PagingByUrlAttributeName='&lt;%page%&gt;'\r\n,PagingByUrlEndStrategy='DetectBasedOnRecordCount'\r\n,IncrementBy=1\r\n)<\/pre>\r\n<h3>Paginate by Header Link (RFC 5988)<\/h3>\r\nAPI like GitHub \/ Wordpress use Next link in Headers (<a href=\"https:\/\/tools.ietf.org\/html\/rfc5988\" target=\"_blank\" rel=\"noopener\">RFC 5988<\/a>)\r\n<pre class=\"lang:default decode:true \">SELECT * FROM $\r\nLIMIT 25\r\nWITH(\r\n\t Src='https:\/\/wordpress.org\/news\/wp-json\/wp\/v2\/categories?per_page=10'\r\n\t,PagingMode='ByResponseHeaderRfc5988'\r\n\t,WaitTimeMs='200' --\/\/wait 200 ms after each request\r\n)<\/pre>\r\n&nbsp;<\/div>\n<h2>SOAP XML \/ REST API\u00a0Error Handling in Power BI<\/h2>\n<div class=\"content_block\" id=\"custom_post_widget-3894\">Sometimes errors occur... they just do and there is nothing you can do! Or can you? Actually, in ODBC PowerPack you can handle them in two ways.\r\n<h3>METHOD 1 - Using Error Handling Options<\/h3>\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3949\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-api-error-handling-1.png\" alt=\"\" width=\"668\" height=\"702\" \/>\r\n<h4>When to use?<\/h4>\r\nYou may want to use them when your source is a resource located\u00a0on\u00a0the Internet; e.g. a file on a website, a file on an FTP server or just a plain API HTTP response. By default, when a remote server returns an error, data retrieval is stopped, an error is raised and no data is given back to you. This might not be always desirable.\r\n<h4>Scenario 1<\/h4>\r\nImagine a scenario, that there is a\u00a0web server which\u00a0each day at 12 AM releases a new JSON file with\u00a0that day's date as filename, e.g. <span style=\"text-decoration: underline;\"><em>http:\/\/www.some-server.com\/data\/2018-06-20.json<\/em><\/span>. And, of course, you want to download it and use it daily in your Power BI report. But you have a problem: Power BI report data sources are\u00a0refreshed each\u00a0hour and you may get\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/HTTP_404\" target=\"_blank\" rel=\"noopener\">HTTP 404 status code<\/a>\u00a0(no file was found) when a\u00a0file is not released yet. Which consequentially means other data sources won't be updated as well and you will see old and cached data on the report. That's where\u00a0you could use\u00a0<strong><span class=\"lang:default highlight:0 decode:true crayon-inline\">Continue on any error<\/span><\/strong>\u00a0or <strong><span class=\"lang:default highlight:0 decode:true crayon-inline\">Continue when Url is invalid or missing (404 Errors)<\/span><\/strong>\u00a0to avoid an error being raised and let other data sources to be updated.\r\n<h4>Scenario 2<\/h4>\r\nAnother scenario is when you expect a web server to raise some kind of HTTP error when accessing a URL. You don't want ODBC Data Source to raise an error but instead, you want to get response data. That's where you can use\u00a0<strong><span class=\"lang:default highlight:0 decode:true crayon-inline\">Continue on any error<\/span><\/strong>\u00a0or alike together with\u00a0\u00a0<strong><span class=\"lang:default highlight:0 decode:true crayon-inline\">Get response data on error<\/span><\/strong>\u00a0to continue on an error and get the data:\r\n\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3961 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-get-response-data-on-error.png\" alt=\"\" width=\"547\" height=\"235\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-get-response-data-on-error.png 547w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-get-response-data-on-error-300x129.png 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/>\r\n<h3>METHOD 2 - Using Connection [Retry Settings]<\/h3>\r\nAnother scenario you may run into is a buggy web server. You ask it to give you some file or data and it, like a snotty kid, just doesn't give it to you! You have to ask twice or thrice before it does its job. If that's the case, you have to retry HTTP requests using <em>Connection<\/em>:\r\n\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3963 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-api-error-handling-3.png\" alt=\"\" width=\"671\" height=\"572\" \/><\/div>\n<h2>Security \/ Connection Types (Options for HTTP, OAuth, SOAP) in Power BI<\/h2>\n<div class=\"content_block\" id=\"custom_post_widget-3896\"><div style=\"margin-bottom: 1em;\">If you need to authenticate or authorize your user to access a web resource, you will need to use one of\u00a0the <em>Connections:<\/em><\/div>\r\n<ul>\r\n \t<li>HTTP<\/li>\r\n \t<li>OAuth<\/li>\r\n<\/ul>\r\n<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4078 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-authentication-authorization-e1529337108252.png\" alt=\"ZappySys XML Driver - HTTP and OAuth Connection Types\" width=\"577\" height=\"302\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-authentication-authorization-e1529337108252.png 577w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-powerpack-authentication-authorization-e1529337108252-300x157.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/>\r\n<h3>HTTP Connection<\/h3>\r\n<div style=\"margin-bottom: 1em;\">Use <em>HTTP Connection<\/em> for simple\u00a0Windows, Basic, NTLM or Kerberos authentication. Just fill in a username and a password and you are good to go!<\/div>\r\n<div style=\"margin-bottom: 1em;\">You can also use <em>HTTP Connection<\/em> for more sophisticated authentication like:<\/div>\r\n<ul>\r\n \t<li><strong>SOAP WSS<\/strong> (when accessing a SOAP WebService)<\/li>\r\n \t<li><strong>Static Token \/ API Key<\/strong> (when need to pass an API key in HTTP header)<\/li>\r\n \t<li><strong>Dynamic Token<\/strong> (same as Static Token method except that each time you need to log in\u00a0and retrieve a fresh API key)<\/li>\r\n \t<li><strong>JWT Token<\/strong> (As per RFC 7519)<\/li>\r\n<\/ul>\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4091 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-api-connection-type-1.png\" alt=\"\" width=\"622\" height=\"570\" \/>\r\n<h3>OAuth<\/h3>\r\nIf you are trying to access REST API resource, it is a huge chance, you will need to use <em>OAuth Connection<\/em>. <a href=\"https:\/\/zappysys.com\/blog\/rest-api-authentication-with-oauth-2-0-using-ssis\/\" target=\"_blank\" rel=\"noopener\">Read this article<\/a> to understand how OAuth authentication and authorization works and how to use it (article originally was written for <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack<\/a>, but the concepts and UI stay the same):\u00a0<br\/>\r\n<a href=\"https:\/\/zappysys.com\/blog\/rest-api-authentication-with-oauth-2-0-using-ssis\/\" target=\"_blank\" rel=\"noopener\">https:\/\/zappysys.com\/blog\/rest-api-authentication-with-oauth-2-0-using-ssis\/<\/a>\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/odbc-api-connection-type-2.png\" width=\"721\" height=\"708\" \/><\/div>\n<h2>Other Considerations for Calling Web API in Power BI<\/h2>\n<div class=\"content_block\" id=\"custom_post_widget-3901\">There are few settings you can coder while calling Web API\r\n<h3><strong>API Limit \/ Throttling<\/strong><\/h3>\r\nWhile calling public API or other external web services one important aspect you have to check,\u00a0 how many requests are allowed by your API. Especially when you use API pagination options to pull many records you have to slow down based on API limits. For example, your API may allow you only 5 requests per second. Use Throttling Tab on Driver UI to set delay after each request.\r\n<h3><strong>2D Array Transformation<\/strong><\/h3>\r\nIf you are using JSON or XML API Driver then possible you may have to transform your data using 2D array transformation feature. <a href=\"https:\/\/zappysys.com\/blog\/parse-multi-dimensional-json-array-ssis\/\" target=\"_blank\" rel=\"noopener\">Check this link<\/a> for more information.\r\n\r\n&nbsp;<\/div>\n<h2>Conclusion<\/h2>\n<p>In this article, we explored possibilities to load SOAP API data in Power BI without any coding or ETL approach. You can build powerful dashboards and reports by consuming data from any REST \/ XML SOAP API services using ZappySys Drivers. You can <a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/\" target=\"_blank\" rel=\"noopener\">download ZappySys ODBC Drivers<\/a> and try yourself to learn many other features not covered in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous post, we saw in general how to call REST API in Power BI. Now let&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3951,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[276,335,278],"tags":[68,349,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-06-14T13:36:33+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-06-19T02:23:47+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"310\" \/>\r\n\t<meta property=\"og:image:height\" content=\"310\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/\",\"url\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/\",\"name\":\"Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\",\"datePublished\":\"2018-06-14T13:36:33+00:00\",\"dateModified\":\"2018-06-19T02:23:47+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png\",\"width\":310,\"height\":310,\"caption\":\"Power BI Integration\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calling SOAP API in Power BI (Read XML Web Service data)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog","description":"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/","og_locale":"en_US","og_type":"article","og_title":"Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog","og_description":"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).","og_url":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-06-14T13:36:33+00:00","article_modified_time":"2018-06-19T02:23:47+00:00","og_image":[{"width":310,"height":310,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/","url":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/","name":"Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png","datePublished":"2018-06-14T13:36:33+00:00","dateModified":"2018-06-19T02:23:47+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Build custom reports, dashboards by calling SOAP API in Power BI, You can Import REST or SOAP XML data from any Web Service (e.g. WorkDay, Google AdWords).","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/power-bi-logo-310x310.png","width":310,"height":310,"caption":"Power BI Integration"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/call-soap-api-power-bi-read-xml-web-service-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Calling SOAP API in Power BI (Read XML Web Service data)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3933"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=3933"}],"version-history":[{"count":19,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3933\/revisions"}],"predecessor-version":[{"id":4123,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3933\/revisions\/4123"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/3951"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=3933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=3933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=3933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}