Forum Discussion

Addy2020's avatar
Addy2020
Helper I
5 years ago

PowerBi Time Out error

I'm merging couple of objects in Salesforce, around half a million records. Worked fine until last merging but when I merged a csv with it & then expanded columns, it took lot of time & ultimately ti...
Need Help
Addy2020's avatar
Addy2020
Helper I
5 years ago

Hi Anonymous 

 

Thanks for your response. But its timing out after 5 hours, it should not be taking that much time. Its half a miillion Salesforce record I'm merging with 17k csv file. Any tips to reduce that time?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Addy2020 ,

     

    I listed some optimization operations, please check the reference link for specific information.

     

    Data reduction techniques for Import modeling:

       Remove unnecessary columns
       Remove unnecessary rows
       Group by and summarize
       Optimize column data types
       Preference for custom columns
       Disable Power Query query load
       Disable auto date/time
       Switch to Mixed mode

     

    A DirectQuery model can be optimized in many ways, as described in the following bulleted list.

       Hide the one-side column of relationships
       Avoid relationships on calculated columns
       Keep measures simple
       Do not use Power Query relative date filtering
       Examine the use of calculated columns and data type changes
       Avoid complex Power Query queries
       Avoid relationships on "Unique Identifier" columns
       Set relationships to enforce integrity
       Avoid use of bi-directional relationship filtering
       Limit parallel queries

     

    Reference: Optimization guide for Power BI

                     Data reduction techniques for Import modeling

                     Optimize data source performance

                     Optimize model design

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.