Consumption of multiple tables from a Web URL but these tables does not have a Key Identifier

[Anonymous]

Hello All,

We have a requirement to pull 2-3 tables from Web URL. We are able to pull but problem is we are not getting key Identifer so that we can say that all these records belongs to particular ID or region or person. Here is the example:

URL- We have a URL for a particular Server

Power BI returns multple tables:

Table 1  gives stats on CPU utilization

Table 2  gives stats on I/O Resource utilization

Table 3 gives stats on Disk Storage

The issue is that we are not getting the server name in these tables so we can not make relationship between these tables to display all information together. 

How we can add server name in all these tables.

Thanks,

PBI V2

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Open Power Query Editor, add a custom column to each table.

3.Apply and close power query, create the relationship between tables.

4.Drag the server column and other tables field into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Anonymous ,

Thank you so much. This solution is working for us.

Thanks,

PBI V2