cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heman
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
mahoneypat
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.