Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pratima
Helper III
Helper III

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

Good Day to All,

 

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

 

 

Thanks,

Pratima

1 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.

 

image

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
Zunair
Advocate II
Advocate II

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 valueColumn2 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

Thanks

benjos
Frequent Visitor

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 applicable

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.

 

image

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.