Data From API to PowerBI

[skorpionaa]

0

I have API link which i want to b in power bi but i need to separate header name from data how can i do that in power bi

you can see the picture

https://coronavirus-19-api.herokuapp.com/countries
i tried split columns function in but still not working please anyone can help me on this ASAP

country , death and so on they are header

 

[sturlaws · Accepted solution]

Hi, @skorpionaa,

try this:

step 1 - import data using the Web connector, this should result in this:

step 2 - Click the 'Convert to table'-button, and choose separator = None:

which should result in this:

Step 3 - Click on the expand button encircled in blue in screenshot above. This should yield this:

All column names are prefixed with Column1., but it will be a onetime operation to change the column names.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.