Newbie question: Build table from different feeds and cross referencing

U

Ucubia

Board Regular
Joined
Mar 17, 2010
Messages
90
Hi,

Apologies for the newbie question, no real experience of Power Bi - using Power Bi as the customers preference to blend multiple data sources/tab;es, in this instance CSV files and SQL output.

The CSV lists Virtual Machine hostnames and the HyperVisor Host they reside upon, and the SQL out has a table that lists the network status of host.

I need to create a new table which lists the DISTINCT list of Hosts, count of VMs per Host, and then Network status for the host from the SQL data.

Any help gratefully received, many thanks in advance

VM Host
Server001 HYPER001
Server002 HYPER001
Server002 HYPER002
Server003 HYPER001
Server003 HYPER002
Server004 HYPER001
Server005 HYPER001
Server006 HYPER001
Server006 HYPER003
Server007 HYPER001
Server007 HYPER004
Server008 HYPER002
Server008 HYPER003
Server010 HYPER004
Server011 HYPER005
Server011 HYPER006
Server012 HYPER003
Server012 HYPER005

Host NetworkStatus
HYPER001 Alive
HYPER002 Offline
HYPER003 Offline
HYPER004 Alive
HYPER005 Alive
HYPER006 Ceased
HYPER007 Alive
HYPER008 Offline
HYPER009 Offline
HYPER010 Alive
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
Ucubia said:
Hi,

Apologies for the newbie question, no real experience of Power Bi - using Power Bi as the customers preference to blend multiple data sources/tab;es, in this instance CSV files and SQL output.

The CSV lists Virtual Machine hostnames and the HyperVisor Host they reside upon, and the SQL out has a table that lists the network status of host.

I need to create a new table which lists the DISTINCT list of Hosts, count of VMs per Host, and then Network status for the host from the SQL data.

Any help gratefully received, many thanks in advance

VM Host
Server001 HYPER001
Server002 HYPER001
Server002 HYPER002
Server003 HYPER001
Server003 HYPER002
Server004 HYPER001
Server005 HYPER001
Server006 HYPER001
Server006 HYPER003
Server007 HYPER001
Server007 HYPER004
Server008 HYPER002
Server008 HYPER003
Server010 HYPER004
Server011 HYPER005
Server011 HYPER006
Server012 HYPER003
Server012 HYPER005

Host NetworkStatus
HYPER001 Alive
HYPER002 Offline
HYPER003 Offline
HYPER004 Alive
HYPER005 Alive
HYPER006 Ceased
HYPER007 Alive
HYPER008 Offline
HYPER009 Offline
HYPER010 Alive
Click to expand...
Resolved with the use of Create Table, Columns, "LOOKUPVALUE" and COUNTROWS - plus more understanding as to how Power BI collates data, very interesting
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Locked
  • Question Question
Power BI - multiple table lookup and count
Replies
1
Views
313
Fluff
Fluff

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

Share this page

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
Back
Top