Notă
Accesul la această pagină necesită autorizare. Puteți încerca să vă conectați sau să modificați directoarele.
Accesul la această pagină necesită autorizare. Puteți încerca să modificați directoarele.
The Blank table module lets you enter or paste data to create a table without connecting to an external source. Use it for a small lookup table, a list of categories, or sample values that you want to transform with other queries.
Enter a table
- In Get data, select Blank table.
- Type values into the grid or paste tabular data.
- If your first row contains column names, select Use first row as headers. Check that a data row isn't used as the header by mistake.
- Enter a meaningful Name for the table.
- Select Next to continue into the Power Query editor.
For example, enter a table with RegionCode and RegionName columns to map short codes to readable names. In the editor, review the column types before using the table in a merge.
Choose entered data or an external source
The values you enter are part of the query definition, not a connection to the place you copied them from. Pasting values from a workbook doesn't establish a refreshable link to that workbook.
If the values should be read again from a file or service during refresh, use the appropriate connector. If you want to generate a table with an M expression rather than use a grid, use Blank query.