Forum Discussion
Subir Bases de datos excel / Uploaded databases Ecxel
Hola!
Cuando intento subir una base, desde excel; mi fila 1 es el nombre de las columnas,
pero cuando se cargan a Power Bi, éstas quedan siendo parte de la tabla, y los nombres de las columnas son "Column 1, column 2...."
qué puedo hacer?
Hello!
When I try to upload a base, from excel my row 1 is the name of the columns,
But when Power Bi are loaded, they remain part of the table, and the names of the columns are "Column 1, column 2 ...."
What can i do?
Hi InmarkColombia,
According to your description above, you can use the "Use First Row As Headers" option in Query Editor in this scenario. :smileyhappy:
1. Click on Edit Queries in the toolbar
2. Click the "Use First Row As Headers" in the toolbar on upper right.
3. Click Close and Apply.
Regards
1 Reply
v-ljerr-msftMicrosoft Employee
Hi InmarkColombia,
According to your description above, you can use the "Use First Row As Headers" option in Query Editor in this scenario. :smileyhappy:
1. Click on Edit Queries in the toolbar
2. Click the "Use First Row As Headers" in the toolbar on upper right.
3. Click Close and Apply.
Regards