Forum Discussion

3 Replies

  • 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