cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pratima Member
Member

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

Accepted Solutions
Community Support Team
Community Support Team

Re: How 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.

 

image

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

5 REPLIES 5
mshparber Established Member
Established Member

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

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

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

Dear Mshparber,

 

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

 

Thanks,

Pratima

Community Support Team
Community Support Team

Re: How 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.

 

image

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Highlighted
benjos Frequent Visitor
Frequent Visitor

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

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

Zunair Frequent Visitor
Frequent Visitor

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

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

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors