By Eric Marshall

Hard coded data sources in Power BI

Simple, hard-coded data tables can be useful data sources in Power BI (provided your data won’t change!). Here’s how to incorporate hard-coded data into your data model:

  • Under the Home ribbon of Power BI Desktop, click “Enter Data”.

 

  • Double click on “Column1” and rename the column as needed. Add additional rows and columns to the table by clicking on the * icons. Delete unwanted rows and columns by highlighting the row or column and pressing the delete key.

  • Add data to the table as desired, change the table name in the bottom left-hand corner, then click “Load” to add the data to your data model.

  • If you already have a table of data in Excel handy, you can simply copy the table from Excel, click Enter Data in Power BI, select the top-left cell and hit Ctrl + V to paste in the table contents:

  • To return to the Create Table window and edit your hard-coded data, you can click on the cog wheel in the Source step: