Forum Discussion

nicolast29's avatar
nicolast29
Helper V
4 years ago
Solved

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 repl...
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
    nicolast29
    4 years ago

    thanks 

    Very clear and usefull

    Have a nice day

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    nicolast29
    Helper V
    4 years ago

    thanks 

    Very clear and usefull

    Have a nice day