Forum Discussion
Long Time Waiting
- Create partitions and load simultaneously. If you can't create partitions like in SSAS, then you can create several tables in Power Query with exactly the same spec apart from a filtering condition. I don't know what fields you have in the big table, but you could certainly retrieve a portion of rows based on some condition(s). Just retrieve different portions into different tables. If you have a date field, then you could create partitions based on year or month...
However, if the problem is with your data source not being capable of retrieving rows quickly enough... You're out of luck. There are system performance counters that are able to tell you what the true speed of retrieval is. Use it to diagnose the problem.
Best
D
How many columns are in each dataset? As Greg_Deckler it's often more about what is going on in the query and the number of merges and columns than the rows. Power BI is generally ok with lots of rows, but the columns, calculations and merges are what can slow it down.
Have a look at some suggestions in this article to reduce the size of the dataset you're pulling through: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.