Need to constantly monitor for data update from sources for changes & alterations Is power BI right tool?

newexcler

New Member
Joined
Nov 15, 2015
Messages
25
Hi Experts,

Please can you suggest if power BI is a right tool for this:
Integrate data from various sources, match addresses (Removing all spaces, characters and comparing and highlighting the differences)
Add columns where relevant and update the sheet based on different sources for each column

It is huge manual task, Can I do this entire things above using Power BI

Regards
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

macfuller

Active Member
Joined
Apr 30, 2014
Messages
297
Office Version
  1. 365
Platform
  1. Windows
That's a broad question, and statements like "add columns where relevant" could suggest even bigger issues. The quick answer is that you won't find anything better!

Question #1 for you is what are your various sources and do they update on different schedules? I use Excel Power Query instead of Power BI in those situations because I have macros to run only the queries that have fresh data on that day rather than the whole thing. You can kick off each query manually in Power BI of course, but it depends how many you have and how much time each takes.

Certainly Power BI is excellent at integrating various data sources - once you get past the initial setup you click a button and go for coffee and the work is done. Everything you ask for is feasible, though a phrase like "highlighting the differences" can mean several things... do you want a new column that says "x has changed" etc.

Addresses are always troublesome - "5th Avenue" and "Fifth Avenue", but that's true of any tool.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,127,331
Messages
5,624,050
Members
416,007
Latest member
csf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top