Power BI – Enter Data and Edit Data

2 Comments

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:

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, BI, Web, Cloud and Data Science.

carldesouza.comLinkedIn Twitter | YouTube

 

2 Responses to Power BI – Enter Data and Edit Data

    • Hi,

      How do we replace the manually entered data with excel data source if excel has same structure.
      when I tried doing it it didn’t show under data source settings because of it’s manual entered data.
      Explanation:
      Suppose we have manually entered the data in power BI , later we would like to replace it with excel source having same structure and data. What is the best possible way to do that?

      Regards
      Harsha

Leave a Reply

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