Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
First time poster, long time browser
I'm connecting PowerBI Desktop to our SAP BW. I'm able to successfully use the data browser that comes up, but it's extremely slow. As a result, amongst some other benefits, I've decided that MDX queries might be the better way for me to go.
Below is a sample syntax that works flawlessly via the SAP transaction MDXTEST, but it throws an error in PowerBI
Any help to a BI noobie would be greatly appreciated.
SELECT NON EMPTY { Except( [4IV1MKFTHL2RJCNHHIZTMGD3L].Members, { [4IV1MKFTHL2RJCNHHIZTMGD3L].[4IV1MKV6JIA6KLQDT74I6KAJ5], [4IV1MKFTHL2RJCNHHIZTMGD3L].[4IV1ML2V2GVW389TZ16UGM98X], [4IV1MKFTHL2RJCNHHIZTMGD3L].[4IV1MLPWNCP0N3W6GJDVAS5E9] } ) } ON COLUMNS, NON EMPTY { Order( [0MATERIAL__YBV1PHE2], [0MATERIAL__YBV1PHE2].[20MATERIAL__YBV1PHE2], ASC ) } ON ROWS FROM [YUB6AUPGI/YUB6AUPGI] SAP VARIABLES [YCALMO_M] INCLUDING 01.2019
Did you solved the MDX statement issue..im facing teh same issue now and not able to solve it..any ideas would be greatly appreciated..
Hi Maran,
I believe it was a permissions issue, if i remember correctly
Do you remeber ,if its related to BW query access permission level? Thanks!!
Hi @BiMark ,
I think it might be caused by the vision. Please try to install the vision of Power BI Desktop 2.71.5523.941 and use the latest sample of the SAP transaction MDXTEST to connect.
If you failed again, please enable the Enable tracing in the desktop and share the trace file around the time that the error throws out for our analysis: Power BI Desktop Trace Logs Analyser.
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.