Forum Discussion

Jsanjur's avatar
Jsanjur
New Member
3 years ago

Best practice on loading data to PowerBI

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