Home › Power BI › Power BI – Enter Data and Edit Data
Power BI · Dec 28, 2017

Power BI – Enter Data and Edit Data

In Power BI Desktop, there is a feature to Enter Data. This is useful if you would like to add some ad-hoc data that does not come from a data source. For example, you could create a simple table with some columns and rows, and then use that as you would with other tables in Power BI.

To do this, in a Power BI Desktop project, select Enter Data:

This will open the Create Table screen:

From here, you can enter new columns, give these columns names, and enter in rows of data. You can also give the table a name, in this case, Orders:

Click Load to load the data to the Power BI desktop, or Edit to open the Edit Queries window. Here we will open the Edit queries window.

To add/remove/change the table and data, under Applied Steps, click the icon next to Source:

From here, the same window will open, allowing you to change the table:

 

10 Responses to Power BI – Enter Data and Edit Data

  1. HI,
    im having issue to sort my x-axis data due to Power BI automatically sort it according to descending value of the data. But i want it to be sort according to its name(alphabetically).

    I used the stacked bar chart.

    Btw, im using power bi online and not the desktop version.

    please advise

  2. Has anyone had any issues publishing reports which contain these tables to Power BI Reporting Services? Since I added the table in place of an external Excel document the PBIX will not publish to PBIRS. Any ideas?

Leave a Reply

Your email address will not be published. Required fields are marked *

Carl de Souza
KEEP LEARNING. KEEP BUILDING.

Explore AI, agents & Microsoft technology.

I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.