Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
What worked for me was saying New Table on the ribbon
Typing in the circled formula
& the results come through
In this instance I am working at getting a dsate table with unique dates from the original table
I find this is useful when I am plotting charts & I need fixed min and max dates that don't vary depending on the Category I am visualising
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |