Getting below error while connecting to sap hana to powerbi

[Harish85]

Hi ,

I am getting below error when I connected sap hana to PowerBi.

cannot allocate enough memory: [9] Memory allocation failed;exception 1000002: Allocation failed ; $failure_type$=STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG; $failure_flag$=; $size$=1573119; $name$=ihm; $type$=pool; $inuse_count$=75549; $allocated_size$=118847567331
exception 1000002: Allocation failed ;

[Anonymous]

Hi @Harish85 ,

Thanks for rajendraongole1's reply!
And @Harish85 , Could you please check if the solution in the link provided by rajendraongole1 can help you solve your problem? If yes, please don’t forget to accept rajendraongole1’s reply as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Also I want to ask what is your connection mode? If you are using Direct Query connection mode, then because Powerbi has limitations on the amount of data connected in Direct Query mode and requires more memory. You can try this: "Get data" -> "SAP HAHA database" -> Type your server name -> open "Advance options" and type SQL statements to filter data.
Solved: GLOBAL_ALLOCATION_LIMIT Power BI with SAP HANA Cal... - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @Harish85  - Please check this post 

Solved: Importing data from SAP database -> cannot allocat... - Microsoft Fabric Community

Solved: SAP HANA PowerBI Online error - Microsoft Fabric Community