How to Perform ETL with On-Premises Data without Using Cloud Services in Power BI?

[rajasekaro]

hi team ,

the data in on-premises databases such as SQL Server and Oracle.

We are not allowed to use any cloud services (like Power BI Service, Azure Data Factory, etc.).

How can i build a full ETL pipeline using only on-prem tools?
Which tools are best for extract, transform, and load in this environment?

[v-priyankata]

Hi @rajasekaro 
Thank you for reaching out to the Microsoft Fabric Forum Community.
@BhavinVyas3003 Thanks for your inputs, its very helpful to the community.
 
Suggestions from user was helpful for your requirement,If you want to access an on-premises database from Power BI, you can refer to the documentation below.
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

Thanks.

[v-priyankata]

Hi @rajasekaro 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @rajasekaro 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @rajasekaro 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[BhavinVyas3003 · Accepted solution]

To perform ETL with on-premises data without using any cloud services, use SQL Server Integration Services (SSIS) to extract data from sources like SQL Server or Oracle, transform it within SSIS or using SQL scripts, and load it into a dedicated reporting database in SQL Server. Schedule these ETL jobs using SQL Server Agent to automate the process. For reporting, use Power BI Desktop (Report Server version) to connect to the transformed data and publish reports to Power BI Report Server.