Forum Discussion

leandroduarte's avatar
leandroduarte
Icon for Helper I rankHelper I
5 years ago
Solved

PowerBI Desktop - refresh too long under evaluating

Dear Colleagues,

 

I'm facing issues with Desktop with refresh taking too long.

 

Basically it a simple model with one excel table of about 200mb without any data transformation in PowerQuery and it is keep under evalating for at least 1-2 minutes, after it start to refresh.

 

The model contains this excel and other SQL tables.

 

Could you please assist with some ways to speed up this process? Please see in this picture the status:

 

 

Need Help

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi leandroduarte ,

    Too large data model and complex relationships could cause power bi load data models slowly.

    Besides trying to disable Auto detect relationships in power bi, you can try to reduce the size of your data model for unnecessary data, optimize data types etc.

    Plesae refer these documents about optimize data model in power bi:

    1. Data reduction techniques for Import modeling 
    2. Optimization guide for Power BI 
    3. Optimize a model for performance in Power BI  

     

    Best Regards,
    Yingjie Li

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

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    leandroduarte 

     

    Disable the following properties:
    - File -> Options and Settings -> Options -> Data Load - > "Import relationships from data sources" and "Autodetect new relationships after data is loaded"


    - Disable privacy check for the report
    - Clear PBI Desktop cache
    - Refresh all queries in preview
    - Clean cache then refresh all in preview