How to create Blank query and Table in Power BI.............

[Pratima]

Good Day to All,

I need help on how to create Blank query and Table in Power BI with examples.

Thanks,

Pratima

[Zunair]

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:

https://docs.microsoft.com/en-us/powerquery-m/sharptable

[JoseAndres]

Thanks

[benjos]

Easier way is to click on the icon named "Enter Data" on the home tab. Pretty much like adding a table in MS Word.

[Anonymous]

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

[Pratima]

Dear Mshparber,

I want details with one example on that ..............

Thanks,

Pratima

[Anonymous · Accepted 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

[Tgal_van_die_1]

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