cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angith_Nair
Resolver II
Resolver II

Options to decrease the time of initial refresh.

Hey folks,

I have a shared dataset with many tables. I have Incremental Refresh (IR) configured in the tables where I know there will be huge data.

I have a Pro license. So, I know that the initial refresh takes time every time I re-publish the dataset. So, here, the refresh continues for 2 hours and then gives a time-out error. When I refresh it again on service (On demand), the dataset gets refreshed successfully.

 

So, for that, to avoid this, there is one option - to have premium capacity.

But in premium capacity also, the first refresh would always take time. To avoid initial refresh taking time, I have one solution - the ALM toolkit. This would publish and refresh the differential changes in the service.

 

Are there any other options by which we can decrease the initial refresh taking time?

1 REPLY 1
najmead
Frequent Visitor

If you have Premium, you are able to use Tabular Editor to apply the refresh policy to the empty data (ie, deply the dataset, but don't refresh it).  By applying the policy, the partitions are set up, but not actually populated.  You can then connect to the dataset via SQL Server Management Studio where you can access the table and it's partitions, and you can manually refresh the partitions one-by-one (or in batches).

 

IIRC, this requires Premium, because you need write access to the XLMA endpoint.

 

Microsoft have more information here: https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#prevent-timeouts-on-...

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors
Top Kudoed Authors