Forum Discussion
PowerQuery Essbase connector (how to get item code)
You are going to have to provide more information Anonymous - unless someone has Essbase and the same table you are working with, it is going to be very difficult to understand and resolve the issue.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Well, imagine all i have is a Table called Products and it has 6 levels of granularity.
From brands to SKU. The problem is, that i somehow only able to retrieve a description of any level, i.e. at the level of SKU: Product1 instead of P_100500 <- technical code of it. I bet there is any way to construct my query to deliver this. That is it.