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

Re: SAP BW timeout option, runtime errorcode 2147467259

I'm with the same problem. Someone discover the cause? Is it a Power BI limitation? 

mvpeterman Frequent Visitor
Frequent Visitor

Re: SAP BW timeout option, runtime errorcode 2147467259

I am also receiving the same issue! I think it's the way Power BI is calling the data or something that is maxing out our memory in SAP BW since I could see the entire InfoProvider when I looked at it in BEx Analyzer. Has anyone come up with a solution or work around?

 

Thanks,

Anonymous
Not applicable

Re: SAP BW timeout option, runtime errorcode 2147467259

no... so far, the best option is to adjust SAP BW in small cubes, this way the conversion is faster and does not run out of available memory and resources.

or use direct query in Power BI, but then you can only create measures. you cannot se data or relationship.

mvpeterman Frequent Visitor
Frequent Visitor

Re: SAP BW timeout option, runtime errorcode 2147467259

Thank you DN for such a quick response! I'll let you know if I figure out a solution.

andaloris
Advisor

Re: SAP BW timeout option, runtime errorcode 2147467259

 

 

In direct query mode, it doesn't load the whole cube, but it do many small request with few axes, one by graph or visualisation.

Same thing with analysis for office for exemple.

 

In import mode, it try to load one big set of data with many axes so it use a lot more memory on SAP application server side.

I think it's not a Power BI bug or a bad SAP configuration but more a concept weakness. Responsiveness of import mode come at a price...

Highlighted
pedro_coelho Visitor
Visitor

Re: SAP BW timeout option, runtime errorcode 2147467259

We are having the same problem in my company.

 

Is there any update on this topic? There have been some fixes implemented?

 

Kind Regards

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,741)