cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Moderator v-qiuyu-msft
Moderator

Re: SAP BW connector invalid MDX command

@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.

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hemantsingh Member
Member

Re: SAP BW connector invalid MDX command

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 Frequent Visitor
Frequent Visitor

Re: SAP BW connector invalid MDX command

Hi Qiuyun Yu,

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

 

Regards,

Moderator v-qiuyu-msft
Moderator

Re: SAP BW connector invalid MDX command

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: SAP BW connector invalid MDX command

Hi all,

 

Please check below information from PG:

 

The generated MDX is this:

 

EXECUTE MDX |WITH MEMBER [Measures].[Microsoft.Mashup.Engine.NullMeasure] AS null SELECT [Measures].[Microsoft.Mashup.Engine.NullMeasure] ON 0,[0PLANT].[LEVEL01].ALLMEMBERS PROPERTIES MEMBER_CAPTION,MEMBER_UNIQUE_NAME ON 1 FROM [ZTAX_REG/REP_20120526_VATREG_TS_GST] CELL PROPERTIES VALUE| WITH-OPTIONS(IgnoreEmptyResultset=true, USEFLATTENING=TRUE);

 

It turns out that "AS null" works correctly on some BW servers but not others.. As of the June release, we will generate different MDX that will avoid this problem, which should fix the issue.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
blairzy1 Frequent Visitor
Frequent Visitor

Re: SAP BW connector invalid MDX command

Thanks  @v-qiuyu-msft

hemantsingh Member
Member

Re: SAP BW connector invalid MDX command

Thanks @v-qiuyu-msft

 

   It feels good to know that the issue raised by us is being acknowleged by product development team & they are working towards its resolution. A reason why pbi stands out exceptionally well in comparision to other same category softwares in terms of issue resolution .

 

Reagrds,

Hemant

marcopa New Member
New Member

Re: SAP BW connector invalid MDX command

Hi,

 

We are trying to integrate in the same scenario and we are also getting the same error message. We have downloaded latest PowerBI version but nothing changes. Can you helps us on steps on how to get support? Do you need logs files?

 

Thanks

 

Pablo Marco

 

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: SAP BW connector invalid MDX command

Hi all,

 

Based on my test, the issue fixed in Power BI desktop newest version 2.47.4766.542 64-bit (June 2017), please test again in your environment.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hemantsingh Member
Member

Re: SAP BW connector invalid MDX command

Hi @v-qiuyu-msft,

 

   You are a real gem sir. great work by the pbi dev team. I would like to confirm that the subject mentioned issue has been resolved and now & i am able to connect to every single report & cube of sap bw flawlessly after updating pbi to the latest june-2017 update.

       I have started testing it & will keep you posted about issues that might come in different testing scenarios. As of now things are working good.

 

Regards,

Hemant

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,054 guests
Please welcome our newest community members: