I think you are right. 5000 items couldn't be a big dataset. I think you need to optimize your data model.
1. What are the relationships among these data tables?
2. How about refreshing it in the PBI Desktop?
Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.