SAP BW direct query Error: visit the SAP support site and search for 'SY 530' SAP Note '2031796'

[Anonymous]

Hi

i'm trying to connect to the SAP BW cube by direct query

when i try to apply a filter by a dimension value 

during the search into the filter i receive an error :

OLE DB or ODBC error: [DataSource.Error] The SAP BW server reported an error: 'An exception occurred '

. To find more information about this error, visit the SAP support site and search for 'SY 530'. Additional information may be available in SAP Note '2031796'..

Query Text:
<pii>EVALUATE
TOPN(
501,
FILTER(
KEEPFILTERS(
SUMMARIZE(
'Materiale',
'Materiale'[Materiale.Materiale Livello 01.UniqueName],
'Materiale'[Materiale Livello 01]
)
),
ISONORAFTER(
'Materiale'[Materiale.Materiale Livello 01.UniqueName],
"[0MATERIAL].[B802092]",
ASC,
'Materiale'[Materiale Livello 01],
"VIRTUAL HEAVY FAST MULTIPACK 12x50ML",
ASC
)
),
'Materiale'[Materiale.Materiale Livello 01.UniqueName],
1,
'Materiale'[Materiale Livello 01],
1
)

ORDER BY
'Materiale'[Materiale.Materiale Livello 01.UniqueName],
'Materiale'[Materiale Livello 01]</pii>

seems that filter can read only first 501 values

does anyone has my same issue?

are there a solutions?

thanks a lot

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best Regards,

Cherry

[gollamla]

Hi,

I am also having same issue, not able to access some of the BW querues which is having Hierarchy in side the design.

Kidnly advise the solution.

Thanks

Narayana

[v-piga-msft]

Hi @Anonymous ,

It seems that your problem should be caused by the MDX query in the Advanced option when you get data.

Please check if you could get the filter data when you use the MDX query in your SAP BW cube.

In addition, if you do not use the query to filter data, could you get data from SAP BW cube successfully in Power BI?

Best  Regarsds,

Cherry

[Anonymous]

hi Thanks a lot 

for you reply i'm checking if i could not use a filter to get data

thanks a lot