Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good Day to All,
I need help on how to create Blank query and Table in Power BI with examples.
Thanks,
Pratima
Solved! Go to Solution.
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
Open 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
Easier way is to click on the icon named "Enter Data" on the home tab. Pretty much like adding a table in MS Word.
Not sure what you mean but to create a Blank Query go to "Get Data" ---> "Blank Query"
To create a table you can either use "Modeling" ---> New Table
or "Enter Data"
Hope this helps
Michael Shparber
Dear Mshparber,
I want details with one example on that ..............
Thanks,
Pratima
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |