Create table vs Excel file

[nicolast29]

hi

I was used to work with import file but i asked myself without finding the answer, for small table like mapping table less than 100 row is it a good idea to create a table an put the data in replacement of importing file

What the impact for performance ?

A Excel file is easier to modify ...

thanks for your comment

Have a nice day

Nicolas

[amitchandak · Accepted solution]

@nicolast29 , In import mode source, will not play much difference. Where it is easy to manage.

If you bring from excel, you need a on-premise gateway.  You can put it on one drive or share point.

If you bring from database , changes need to updated in database

Instead of creating a table power bi using enter data, use dataflow, you can edit the data without desktop

refer if needed

Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA

[amitchandak · Accepted solution]

@nicolast29 , In import mode source, will not play much difference. Where it is easy to manage.

If you bring from excel, you need a on-premise gateway.  You can put it on one drive or share point.

If you bring from database , changes need to updated in database

Instead of creating a table power bi using enter data, use dataflow, you can edit the data without desktop

refer if needed

Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA

[nicolast29 · Accepted solution]

thanks 

Very clear and usefull

Have a nice day