Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vito_finamore
New Member

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 to Power BI?

Thank you.

Vito

2 REPLIES 2
ZappySys
Helper I
Helper I

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/

 

 

 

v-yuezhe-msft
Employee
Employee

@vito_finamore,

What are the backend databases of your CRM/ERP systems? In Power BI Desktop, we are able to connect to multiple types of databases such as SQL Server, Oracle, MySQL, DB2. If there is no built in connector for your backend databases in Power BI Desktop, you can consider to use ODBC or OLEDB connectors instead if it is possible to create ODBC/OLEDB data source for your database.

In addition, if your CRM/ERP system provides rest api, you can get data through using web connector in Power BI Desktop to connect to the api .

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors