Forum Discussion

vito_finamore's avatar
vito_finamore
New Member
7 years ago

ETL

Hi! Is it possible to import data to Power BI direcly from any CRM, ERP and other databases, without importing them to a data warehouse first? Or is it absolutely necessary an ETL before importing t...
Need Help
ZappySys's avatar
ZappySys
Helper I
7 years ago

Hi,

 

Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.`You can import data using SQL Query Language from any API without doing ETL.

 

You can write queries like below

SELECT * FROM $
LIMIT 25
WITH(
	 src='https://wordpress.org/news/wp-json/wp/v2/categories?per_page=10'
	,PagingMode='ByResponseHeaderRfc5988'
	,WaitTimeMs='200' --//wait 200 ms after each request
)

 

Here is an article you can start with.


https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

 

Check below link for more articles related to Power BI and Rest API Integration.

 

https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/