Refresh problem for a large size table in Power BI Desktop and in Power BI Services

Hell-1934 

1. Reduce Table Size:

   • Filter Data: As you mentioned, adding a filter to include only records from the last 24 months can significantly reduce the size of your table and improve refresh performance.
   • Limit Columns: Consider limiting the number of columns you're importing from each OData feed to only those that are necessary for your analysis. This can help reduce the size of your dataset.
   • Combine Similar OData Feeds: If multiple OData feeds provide similar data, consider combining them into a single query to reduce the number of API calls and improve performance.

2. Optimize Query Execution:

   • Merge Queries: If possible, try to merge similar queries or apply transformations earlier in the query chain to minimize data movement and improve query performance.
   • Data Sampling: During development, you can use data sampling techniques to work with a smaller subset of your data, which can help identify and address performance issues more quickly.
     
     Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!