Forum Discussion
Dataset refresh too long (Sometimes)
I am less concerned with the jump in refresh time from an hour + to 4 hours + than I am with the refresh even taking an hour +. Even the largest and most complex semantic models I have come across rarely take longer than 20 minutes. I had a client a few years ago in the Health Care sector that had a bloated 6GB model that was highly inefficient, and it never even took 40 minutes.
My first suggestion would be to look at your query design. Avoid a lot of heavy transformations. If you can set up your queries as dataflows and then ingest the data flows into your model so you are segregating the ETL from the model refresh and you can isolate inefficient queries.
Check your report settings to make sure that parallel loading of tables is enabled.
Hi MikolajSikorsk,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.