Partial Load or Limit Load

[AvPowerBI]

Hi,

Is there way to do a partial load of the data when refreshing a pbix file? 

I have an issue where I am using DevOps and when I try and upload my pbix file it exceeds the 20MB total size.

I don't want to go in to my queries and mess around with the SQL to do a Top 10 because other users may forget that I have applied this if they needed to make a change and publish the document.

Thanks

[V-lianl-msft · Accepted solution]

Hi @AvPowerBI ,

For queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report. In this scenario, you can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

Any queries excluded from refresh are also excluded in automatic refresh in the Power BI service.

Another you can try to select the multiple tables by holding down the CTRL button and selecting the tables->then right clicked and selected Refresh data.

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

[amitchandak]

@AvPowerBI , You can limit using power query  parameter

refer if needed

Premium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0

[AvPowerBI]

@amitchandak Thanks for your reply

How do you do this? Do you have to do something on every query used in the Power Query or is it a seeting on Power Query itself?

[amitchandak]

@AvPowerBI , I followed the incremental load approach.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

Rest I explained in the video