POST data to REST API URL in Power BI - Use JSON / XML ODBC Driver for Web API / Files (Part 6 of 6)

This demo shows how use ZappySys API drivers to load JSON / XML REST API into Power BI or any other ODBC Compliant Apps (e.g. Excel, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS)

What is ODBC PowerPack?
==========================
ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favorite Data Engine / Reporting / ETL tools (i.e. SQL Server, Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. Our drivers can be called from your favorite programming languages such as JAVA, C#, Python etc.

Main Features of ODBC PowerPack
================================
ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files.
Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API)
Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp… )
Support very large JSON / XML files
Support for Caching engine to reduce query time
Support for retry options (To handle intermittent failures)
Support for API pagination options (Many ways to paginate large API response)
Tight integration with SQL Server (Call REST API from T-SQL Code)
Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS)
Support for popular programming languages such as JAVA, C#, Python

Other Useful Videos In this Series
==========================
(Part 1 of 6) ODBC PowerPack Intro - Loading JSON into Excel (Read from REST API URL or Files)

(Part 1 of 6) GET data from REST API / JSON Files using ODBC Driver - Intro

(Part 2 of 6) Calling REST API with OAuth 2.0 Authentication using ZappySys ODBC Driver

(Part 3 of 6) Calling REST API with Pagination (HTTP Request Loop) using ZappySys ODBC Driver

(Part 4 of 6) Building SQL Query for REST API Call using ZappySys ODBC Driver

(Part 5 of 6) POST data to REST API URL in Power BI (Use JSON / XML ODBC Drivers for Web API and Files)

Keywords:
========================
power bi post data to url
power bi rest api post request
call rest api in power bi
how to call http post in power bi for rest api

[JaswinderSingh-uwhf]

great show sir,
will it work when I refresh the power BI web service to show the data and each time I refresh the dashboard in power BI service it fetch the data from REST API and display. if possible. Please provide such demo link. I am struggling with this from past 3 days. Please provide your inputs.

[AdamMendoza]

Is it possible to have the driver make multiple requests on an API when the API sends only 100 records at a time and you have to make multiple requests to get all data?

[AdamMendoza]

Does it support dotnet core? Then I can use the dll on a Mac

[louiedgomez]

is it possible to use power query directly to post to ssrs 2017 api?