Forum Discussion
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...
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