Memory error: you have reach the maximum allowable memory allocation for your tier

Hey shailendra 

View this article here for size limitation information: https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi#:~:text=

The answer in this thread also gives some good insight into this issue: https://community.powerbi.com/t5/Desktop/Power-BI-memory-limit/td-p/206477

Basically, you are not limited on Desktop. You are limited in Power BI Service. If you need more space you will have to upgrade to premium. Consider splitting the query between workspaces and then sharing visuals in a dashboard using content packages. See this thread for an example: https://community.powerbi.com/t5/Service/How-to-share-content-from-multiple-workspaces/td-p/333282

If this helps please kudo.

If this answers your question please accept it as a solution.