Forum Discussion
Create table vs Excel file
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
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
thanks
Very clear and usefull
Have a nice day
2 Replies
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
thanks
Very clear and usefull
Have a nice day