Forum Discussion

blairzy1's avatar
blairzy1
Frequent Visitor
9 years ago

SAP BW connector invalid MDX command

I'm using: Power BI Desktop (April 17 release) I'm trying to connect to SAP BW using the now standard SAP Business Warehouse server connector. SAP NW RFC SDK 7.20 downloaded and extracted. The .lib a...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

blairzy1 I have reported this issue with trace log internally. If there is any information, I will update to you.

 

Anonymous I already send a email to you. You can share the trace file via email.

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-qiuyu-msft,

 

  I have just mailed you the trace files. Please analyse them & lemme know your findings.Hope to get a solution from you.

 

Regards,

Hemant

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    blairzy1 I got the information internally that they suggest to enable product traces on the Diagnostics tab of the Options dialog and then repeat the operation which produces the error. Then, send us the trace files. 

     

    Please follow above suggestion and capture trace and share it here.

     

    Anonymous Please check if the trace file is captured as I told above. If not, please send me again.

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      hi v-qiuyu-msft,

       

           The trace folder which i have sent you via mail was exactly captured the way you told. Please find below the steps i followed to capture the trace.

       

      1). Opened Power Bi.

      2) Deleted all the traces till date from the root folder of traces.

      3). checked the option for enable trace

      4). Connected to SAP BW server.

      5) Tried conencting to a SAP BW Report that has mandatory parameter selection if access through bex query analyser.

            Result :- Failed to do so. The same error repeated.

      6). Tried conencting to cubes under $infocube option. 

             Result : - Failed to connect any cube. The same error repeated.

      7). Tried conencting to a SAP BW Report that does not have any mandatory parameter selection if access through bex query analyser.

            Result :- Failed to do so. The same error repeated.

       

      Regards,

      Hemant

    • blairzy1's avatar
      blairzy1
      Frequent Visitor
      9 years ago

      Hi Qiuyun Yu,

      I've PM'd you. Have you had a chance to push the files through to the team?

       

      Regards,

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        blairzy1Anonymous Desktop trace files already sent internally, will updated here if I get information from PG.

         

        Best Regards,
        Qiuyun Yu