Newbie question: Build table from different feeds and cross referencing

[Ucubia]

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

 

[Ucubia]

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

Resolved with the use of Create Table, Columns, "LOOKUPVALUE" and COUNTROWS - plus more understanding as to how Power BI collates data, very interesting