SAP BusinessObjects Universe with Optional Prompts

Kirk P.

New member
Joined
Nov 4, 2016
Messages
10
Reaction score
0
Points
0
Location
Minnesota USA
Excel Version(s)
365
Connecting to a BOBJ Universe. I can connect OK, and see the measures and dimensions, but when I select something for preview, I get

DataSource.Error: SAPBusinessObjects: This query requires resolutions of prompts or contexts, which aren't currently supported

Running a query from the BOBJ side, it asks the user to respond to two optional "system" prompts before running a query. Because the prompts are optional, most people leave them blank and run it. From the PowerQuery side, I'm sure this is what the error message is telling me, but is there any way to get PowerQuery to respond to the prompts?
 
Back
Top