Import Excel data vs create table in Power BI

Hi Apple08 ,

Their differences are as follows:
(1) Due to the design, creating a table in Power BI Desktop only supports input data, does not support drop-down or use functions to quickly input data, you can clean the data in Power Query, or use convenient drop-down in Excel to create a good table, directly copy it in the interface of "Enter Data".
(2) Create a table in Power BI desktop, his data source data can be modified at any time (Once you are in the Power Query Editor, under the query for that table, click on the setting icon for the Source step), but import Excel data, the data source is displayed as the excel path, you need to modify the data source in Excel and refresh it.
(3) Create table data in Power BI Desktop cannot exceed 3000 cells.
(4) To update, add, or delete data within items created by Enter Data, changes must be made in Power BI Desktop, and published. Data updates cannot be made directly from the Power BI service.

Please refer to the following document for more information.

Create a Table in Power BI using Enter Data, and How to Edit it - RADACAD

Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn

Enter Data In Power BI: How To Use It For Data Entry - Enterprise DNA

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.