Forum Discussion
Power BI table load
It sounds like [source name] is a high granularity field. You are likely creating a large data cache to answer the query. I would capture the query plan with DAX studio and look at the query being issued to the warehouse, and how much processing is occuring in Power BI. Ideally you'd push as much back to the warehouse as possible, this might require rewriting the DAX to force that behaviour.
You say you are not using aggregrations. If the [Soruce Name] is not too high cardinatility you could think about a import or DirectQuery aggregation to speed up the query.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.