Best practice on loading data to PowerBI

[Jsanjur]

Good morning all,

Id like your advise on how to load data to PowerBi.  Im using an odata query to an Azure Analytics to load information since 2020, including about 10 fields for 5 work item types.  It takes about 5 minutes to refresh the data, and im wondering if the the timing is right or if you suggest to divide the query into different small ones?  Maybe instead of pulling by Work Item type i should be creating different queries for the attributes and maybe use the ID as relationship key?

What would you suggest?

Thanks,

J

[amitchandak]

@Jsanjur , Are you using incremental refresh? Do you have the key/date to do an incremental refresh?

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE