Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
And here below the screenshot of the error in Power BI.
Could you please help me?
Also, Is there a way to import a hierarchy from SAP?
Thank you very much!
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
Hi,
thanks for your reply Lydia
Unfortunately, also selecting both, the connector does not work
Hi @MatteoColzani,
Are you able to write MDX statement to import data from SAP to Power BI Desktop?
Thanks,
Lydia Zhang
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
User | Count |
---|---|
23 | |
18 | |
16 | |
13 | |
11 |