Forum Discussion
Helper VPower 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.
Hi Hussein_charif
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.