Forum Discussion
Import extra column from a API into power bi
Hi!
I've been trying recently import new columns to my data on power query from an api but when i refresh to get the data it seems that is not importing the columns, it's not anywhere that i could find, it doesn't show in the table, pick columns or the advanced editor
I already tried just write the column name on this to bring the column but it doesn´t work too, refreshing data also does nothing, theres nothing wrong with the data and how its written.
Anyone knows what could be the problem and how can i resolve this issue?
2 Replies
Hey Thiago_Melo ,
can you make sure you pick the first step in your applied step list:
Does the column exist there? Many times columns get not selected in the next steps. So check if that is the case.
Otherwise can you call the API manually and make sure the column is there?
Also check the documentary:
https://docs.microsoft.com/en-us/power-query/applied-steps
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovicThanks for the help! selimovd
The columns doesn't exist in the applied steps also
The information that represents the column can be seen by calling the api, one interesting thing is that they are imported if i create a new query, but i can't add them to an existing and functional query (wich is a problem for us), you know what could be happening? there's another thing that i could do to try import these columns?
