Forum Discussion
Combinar consultas
Buenas noches,
Tengo un informe con varias tablas extraidas de una carpeta en SharePoint a una de ellas le adicioné varias columnas, pero cuando voy a transformar datos para combinar consultas no me aparecen las columnas adicionadas, alguién me puede indicar que debo hacer?
3 Replies
Chelamarce , Are they appearing in the table which was imported. Right click on the table in Data transformation and open advance editor. Check and add columns there
amitchandak Buenos días, en la tabla importada originalmente no están las columnas, las inserté dede la parte de datos, no desde la consulta, pero cuándo intento combinar consultas las columnas insertadas no me aparecen, con qué función se pueden adicionar desde el editor avanzando?. Muchas gracias.
Hi, Chelamarce
I wonder if the 'data part' means several calculated columns. If you create some calculated columns in Power BI Desktop, they won't appear in 'Query Editor'.
With calculated columns, you can add new data to a table already in your model. But instead of querying and loading values into your new column from a data source, you create a Data Analysis Expressions (DAX) formula that defines the column’s values. In Power BI Desktop, calculated columns are created by using the new column feature in Report view. Custom columns are created as part of a query by using Add Custom Column in Query Editor, calculated columns that are created in Report view or Data view are based on data you’ve already loaded into the model. If you want to add new columns during the query, you may create some custom columns.
For further information, I'd like to suggest you refer to the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
