Forum Discussion
Advocate IIHow to create Blank query and Table in Power BI.............
Hi Pratima,
I think you can refer to below link to know how to use power query to create a table:
Creating Tables In Power BI/Power Query M Code Using #table()
Steps:
1. Click on "Editor Queries" to open the query editor.
2. Find out the "Queries" panel, right click on the blank place below the panel and choose "New Query" -> "Blank Query".
3. Refer to steps in above link to create the new table.
Regards,
Xiaoxin Sheng
Advocate IIOpen Query Editor>hit new source>blank query> change source to the following
= #table(null,{})
Done!
---
null : 0 columns
{} : no values
= #table(100,{}) : if we did this, it would create 100 columns with 0 rows.
= #table(1, {{"row 1 value"}}) : 1 column with a row value "row 1 value"
= #table({"ColumnName"}, {{"row 1 value"}}) : same as above but column name is defined
= #table({"Column1Name","Column2Name"}, {{"Column1 row 1 value", ""}, {"Column1 row 2 value","Column2 row 2 value"}}) :
| Column1Name | Column2Name |
| Column1 row 1 value | |
| Column1 row 2 value | Column2 row 2 value |
you get the idea ... 😄
#table(columns as any, rows as any) as any
Source:
Thanks
