Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MatteoColzani
Frequent Visitor

Expression.Error: We cannot apply field access to the type List. BEX SAP

 

Hello,

 

I am trying to import the data from a BEX Query but every time I get the following error

"Expression.Error: We cannot apply field access to the type List."

 

As you can see below, the BEX query is very simple.BEx Query.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

And here below the screenshot of the error in Power BI.

 

Capture.PNG 

 

 

 

 

 

 

 

 

 

 

 

 

 

Could you please help me?

 

Also, Is there a way to import a hierarchy from SAP?

 

Thank you very much!

5 REPLIES 5
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @MatteoColzani,

From your second screenshot, I note that you are only select Dimension of SAP in Power BI Desktop. However, in your Bex Query Designer, you select both dimension and key figures to combine a valid table.

In Navigator of Power BI Desktop, please select both Dimension and key figure(Gross Sales) to import data from SAP , then check if you have any issues.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

thanks for your reply Lydia

Unfortunately, also selecting both, the connector does not workCapture.PNG

 

 

Hi @MatteoColzani,

Are you able to write MDX statement to import data from SAP to Power BI Desktop? 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

sorry I don't know MDX, could you please send me an example of the script?

 

Thanks!

Matteo

Hi @MatteoColzani,

You can check the following blog and similar thread.

http://bhargavgandhi.blogspot.sg/2011/07/capturing-mdx-statement-in-sap-bw-for.html
https://archive.sap.com/discussions/thread/29622


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors