cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicksonteh
Helper III
Helper III

Automated data from different source

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

1 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


View solution in original post

4 REPLIES 4
Hariharan_R
Solution Sage
Solution Sage

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


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 ?

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


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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors