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.
Have been seeing the same issue for the last 2 weeks or so and ussually around the same time everyday (10am). Thin reports, the visuals just sit and spin. Dataset is import and all ETL is up in dataflows. We're also using a PPU license. However, dataflows refresh in 1-2 minutes, datamodel in 2-4 minutes and model size is 28k in size.
Normal refresh