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
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.
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.
