Forum Discussion

ozmike's avatar
ozmike
Resolver I
9 years ago
Solved

DataSource.Error: SAP Business Warehouse: Invalid MDX command with )

HI Strange error with ) ?

 

If I filter a column in the query editor - in most columns I get the below error ')'. Filter by selecting an item from the list check box, or entering search text. Some  columns do work.

 

 

DataSource.Error: SAP Business Warehouse: Invalid MDX command with )
Details:
DataSourceKind=SapBusinessWarehouse
DataSourcePath=sXXXX
ErrorCode=-2147467259

 

In another column i type search filter text "Tax" - ok , but if I select an item or type an item I get ,(comma) error!

 

DataSource.Error: SAP Business Warehouse: Invalid MDX command with ,
Details:
DataSourceKind=SapBusinessWarehouse
DataSourcePath=XXX
ErrorCode=-2147467259

 

 Power Bi Version

Version: 2.48.4792.721 64-bit (July 2017)

btw How do I find out what version of dlls..if relevant..

This is a showstopper we can't use this product.

 

Interestingly the slicer in the visualisation has no problems..

Need Help

7 Replies

  • ozmike's avatar
    ozmike
    Resolver I
    9 years ago

    One work around seems to be to use the text filters -> contains search seems to work (slow) but does not get these syntax errors.

      • ozmike's avatar
        ozmike
        Resolver I
        9 years ago

        Hi thanks for the clue,

         

        I think i've narrowed down the issue. But can't explain it as i'm no guru in the M language. Looks like a bug.

         

        ok if you select 2 filters your ok..if you select only one you dead!  when I enter the word Tax as filter it selects multiple check items (4)

         

         

        eg this fails check 'X Tax' as filter

            #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each (Cube.AttributeMemberId([Category Level 1.Category Level 1 Level 01]) = "[XXLV1].[84349712BABA1ED593A328A6DFE28346]" meta [DisplayName = "X Tax"] ))

        .

         

         

        This does not error , typing 'tax' returns 4 selections

            #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each (Cube.AttributeMemberId([Category Level 1.Category Level 1 Level 01]) = "[XLV1].[84349712BABA1ED593A328A75FF10344]" meta [DisplayName = "X Tax"] or Cube.AttributeMemberId([Category Level 1.Category Level 1 Level 01]) = "[XLV1].[84349712BABA1ED593A328A76B5E0344]" meta [DisplayName = "YTax"] or Cube.AttributeMemberId([Category Level 1.Category Level 1 Level 01]) = "[XLV1].[84349712BABA1ED593A328A6DFE28346]" meta [DisplayName = "Z Tax"] or Cube.AttributeMemberId([Category Level 1.Category Level 1 Level 01]) = "[XLV1].[84349712BABA1ED593A328A71D41C346]" meta [DisplayName = "Tax XX"]))

         

        Similarly if I select /check 2 items it works..

         

        filtering multiple items returns more rows..and works ..so its not a resource issue.

         

        This seems to be a bug, whether MS can fix or its a SAP driver issue..who knows .Can you fix it ? ;)