Forum Discussion

id013's avatar
id013
Helper V
2 years ago

Weird Semantic Model Refresh Issue

Hi, So I'm having an intermittent refresh issue with a semantic model. The dataset isn't very large and normally takes 2-3 minutes to complete when it runs nightly. However lately I've been noticing...
Need Help
SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
2 years ago

Hi id013 ,

 

Republish your report and see whether the same issue occurs or not.

 

Thanks,

Sai Teja 

  • id013's avatar
    id013
    Helper V
    2 years ago

    SaiTejaTalasila 

    So I'm replicating the issue within PBI Desktop not on PBI service. Regardless republishing the model as is did not make any difference, it still timed out. But as I said earlier if I make any change on the query (ie add in a commented line) PBI desktop will be able to load the data successfully. IF i then rever that change, in this case remove teh commented line, PBI Desktop will once again time out loading the data. I'm not discounting an issue with our source data as it seems to happen with a specific table. I'm just trying to understand why making any change to the query results in a successful data load on PBI Desktop and reversion of that change results in the data load time out again. And just to clarify if I take the data model that is loading correctly on PBI desktop (with the superflous comment added) it loads correctly on PBI desktop as well. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi id013 ,
      In response to the query loading timeout issue you are experiencing in Power BI Desktop, I have reviewed the official documentation and the following may be the reason why you are experiencing this issue:
      1. When you make any changes to the query (adding comment lines), Power BI may recompile and optimise the query execution plan. At this point, the data will load successfully, but if the changes are undone, Power BI may use the old query plan that was previously cached, which may cause a data timeout.
      2. Changes made to the query cause Power BI to reevaluate the query's metadata, which may regenerate the data model, thus avoiding the previous timeout issue.
      3. You can try splitting the query step into multiple simple steps and then loading the data incrementally to try to locate the part where the problem occurs.
      4. You can use SQL Server Profiler to monitor what happens when the query is executed with and without comments, and you can view the differences and errors in the plan.
      Below are the documents that I have found for you related to the case, I hope they are helpful.

      DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

      Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

      Hope it helps!

       

      Best regards,
      Community Support Team_ Tom Shen

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