Automated data from different source

[Anonymous]

Hi everyone, hope you doing well. 

I have a question regarding automating data from different source into Power BI. I have developed a dashboard for my company to measure and monitor their procurement performance. Currently,  I refresh the data by extracting the data manually from sources such as Oracle, and Excel sharepoint. After that, I will copy all the data and paste into excel that contain the existing data. 

However, to make this process automated and more efficiency, I am looking forward to refresh the data automatically from different source such as Oracle and other ERP system into Power BI. May I know how can I continuously load this data from difference source into existing dataset on monthly basis ? what tool should i research on ( etc. Power Query, VBA, Power Automate) ? 

To summarize, I wanted to refresh data from different source automatically. 

Thank you in advance for your advice. 

Best regards

[Hariharan_R]

Hi,

You need to use Power Query in Power BI Desktop. Add tables from different data sources and build the model and report. You can setup a refresh whenever you get a latest data in your data sources. This is the recommended way within Power BI.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Anonymous]

Hi @Hariharan_R ,  thank you so much for your clarification. May I know is there any available tutorial or external source that I can look for to develop this ?

[Hariharan_R · Accepted solution]

Hi,

You will get mulitple resources online on how to add mulitiple data sources in Power BI.

Ref - https://support.microsoft.com/en-us/office/learn-to-combine-multiple-data-sources-power-query-70cfe6...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Anonymous]

I seee, okay got it. thank you so much for the clarification. appreciate that !