cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MatteoColzani Frequent Visitor
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
Moderator v-yuezhe-msft
Moderator

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

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.
MatteoColzani Frequent Visitor
Frequent Visitor

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

Hi,

 

thanks for your reply Lydia

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

 

 

Moderator v-yuezhe-msft
Moderator

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

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.
MatteoColzani Frequent Visitor
Frequent Visitor

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

Hi,

 

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

 

Thanks!

Matteo

Moderator v-yuezhe-msft
Moderator

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

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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,818)