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.

DavisBI's avatar
DavisBI
Icon for Solution Specialist rankSolution Specialist
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.

  • Vishwanath29999's avatar
    Vishwanath29999
    Frequent Visitor
    2 years ago

    Hi DavisBI , How do i increase the timeout limit for the query? is it by using the command timeout at the source setting of the sql table? If yes, will that affect the scheduled refresh?
    Thanks