Forum Discussion

AlexF_HH's avatar
AlexF_HH
Frequent Visitor
4 years ago
Solved

Dataset refresh takes too long error (PowerBI online)

Hi Community,   since 16.02.2022 we suddenly experince troubles updating our datasets connected to dynamics 365 (without any recent changes of the dataset or model). The size of the concerned d...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi AlexF_HH 

     

    How are you refreshing your dynamics 365 data?


    It appears to be a timeout issue more than a sizing issue?

     

    Have you tried using incremental refreshing to solve this and refresh per day instead of the entire dataset?

  • DavisBI's avatar
    DavisBI
    4 years ago

    Hi AlexF_HH 

     

    First, try to use dynamic 365 query function in Power Query to filter the dataset instead of full load.

    Second, you can increase the timeout limit for the query.

     

    Another solution is you can migrate your dynamic 365 data to Azure SQL DB by using Data Factory, then Power BI can get data from SQL DB, which you can enable query folding as well as incremental refresh.

     

    Best.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
4 years ago

Hi AlexF_HH 

 

How are you refreshing your dynamics 365 data?


It appears to be a timeout issue more than a sizing issue?

 

Have you tried using incremental refreshing to solve this and refresh per day instead of the entire dataset?

  • AlexF_HH's avatar
    AlexF_HH
    Frequent Visitor
    4 years ago

    Hi GilbertQ ,

     

    thank you very much! Of course i didn't try that 🙂
    Will do right away. That should solve my problem in the short run.

    But still, my main problem will come back as soon as i have to update the whole dataset. E.g. because some
    of my data hat to be updated ex-post for any reason.