Forum Discussion
DataSource.Error: SAP Business Warehouse: Invalid MDX command with )
- 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 ? ;)
- ozmike9 years agoResolver I
How do I raise a ticket , found the raise ticket button, and activated the pro trial...but says
Looks like you haven't subscribed to Power BI Pro
Do I need to pay to help you guys ;)
Or is it a lag ..I have activated the pro trail..
- v-chuncz-msft9 years agoCommunity Support