Forum Discussion

MatteoColzani's avatar
MatteoColzani
Frequent Visitor
9 years ago

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, th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

MatteoColzani's avatar
MatteoColzani
Frequent Visitor
9 years ago

Hi,

 

thanks for your reply Lydia

Unfortunately, also selecting both, the connector does not work