Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
105 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |