Forum Discussion
Solved
Ho to extract data from Aconex (Oracle DB) through API to SQL database to Power BI.
Hi All, I want to develop report on Aconex data in Power BI Aconex is now owned by Oracle and it's database is Oracle. I want to bring in Aconex Field data from Aconex to our Local server SQL data...
Hi saivina2920 ,
You can refer the content in the following links to achive extracting the data in Power BI to SQL Server by the the methods below:
Use DAX Studio:
GUIDE ON EXPORTING DATA FROM POWER BI (PBIX) FILE TO SQL SERVER
Use R scripts or SSIS
Export data from Power Query to Local Machine or SQL Server using R scripts
Exporting Power BI Data to SQL Server
Best Regards
Hi saivina2920 ,
You can refer the content in the following links to achive extracting the data in Power BI to SQL Server by the the methods below:
Use DAX Studio:
GUIDE ON EXPORTING DATA FROM POWER BI (PBIX) FILE TO SQL SERVER
Use R scripts or SSIS
Export data from Power Query to Local Machine or SQL Server using R scripts
Exporting Power BI Data to SQL Server
Best Regards