Search code examples
powerbipowerquerypowerbi-desktopm

Create an empty table and paste values - Power BI

What I want is to create a black table in Power BI nd import data using copy paste method. Currently I have managed to create a table and import some values using the below method:

  • Home – Get Data – Common Data Sources – Click Blank Query
  • = #table ({"First Column", "Second Column"}, {{1,2}, {3,4}})

enter image description here

Is there any alternative which allow me to create a table with many rows and paste the data in?

Thanks in advance.

Solution

  • You can use Enter Data on the ribbon to paste tables in.

    enter image description here

    enter image description here