cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Getting huge volume data from SAP Business warehouse Application server

Hi Team,

 

I am trying to get data from SAP Business warehouse Application server to Desktop through Import option.I am getting the below memory issue error as it is huge volume of data(definitely More than 1 GB) as I need to fetch more than 100 columns with 4 years of  transaction data.And Direct query option is not enabled for me.Is there any solution to resolve the same.

 

heman_0-1605430249011.png

heman_1-1605430361572.png

 

Thanking  you in anticipation,

Regards

 

 

1 REPLY 1
Super User IV
Super User IV

A couple ideas to consider.

1. Hopefully you have a source where query folding occurs (haven't used that one so not sure).  If so, make sure you put your Filter and SelectColumns (button in ribbon, or use Remove Other Columns) steps first to reduce the data actually returned.

https://visualbi.com/blogs/microsoft/powerbi/tips-best-practices-using-sap-bw-sap-hana-connectors-po...

 

2. Consider trying it as a Dataflow in the service, then make a report from that and publish it so you have a dataset you can build a report against.

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors