Forum Discussion

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , prefer import mode as far as possible

Try not to have any new column in power query or DAX, Try to have that in DW

Prefer to use Star schema with single direction join 

Do not bring unnecessary rows or columns in the power bi dataset

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Amit.

     

    But when it comes to import with so many records how do I set it for schedule refresh because it would take a lot of time for refreshing the datasets when we publish it to Service. What do you suggest. There could be multiple tables and records in them so when it comes to refreshing them automatically wont it fail?

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi， Anonymous 

      For the refresh of large datasets, Incremental refresh and real-time data will help you to some extent.

      Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data. 

       

      Best Regards,
      Community Support Team _ Eason