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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
marcopa
New Member
9 years ago

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

 

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

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

  • sukajalan2's avatar
    sukajalan2
    Frequent Visitor
    9 years ago

    I have installed the June version and I still cannot import the data. Here is the error message.

     

    DataSource.Error: SAP Business Warehouse: RfcInvoke failed(RFC_ABAP_RUNTIME_FAILURE): TSV_TNEW_PAGE_ALLOC_FAILED
    Details:
        DataSourceKind=SapBusinessWarehouse
        DataSourcePath=10.135.70.104/00/005
        ErrorCode=-2147467259

     

    Can you help? Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sukajalan2,

     

       It seems this is the first time you have installed pbi & tried to connect SAP BW, Is it?? 

     

      If this is the case then kindly send me your email id, i will send you few dependent files which are required to be placed in windows system32  folder. There are SAP NWRFC library files that are required to connect to SAP Bw . Also , make sure you have installed latest gui in your local machine from where you are trying to connect the SAP bw.

     

    Regards,

    Hemant

  • sukajalan2's avatar
    sukajalan2
    Frequent Visitor
    9 years ago

    Hi Anonymous, I have sent you my email address.

     

    Regards,

    Johannes