67
Hi,
I built a Power BI model for a client and am using the Item card in the data model. The Item card use to contain Dim 1 and Dim 2 but BC was recently updated to version 18 and now Dim 1 and Dim 2 are no longer showing any data. I tried merging the item table with the Item Ldeger Entries get the Dims but there seem to be a lot missing. How can I get a full mapping of items and Dims?
Global Dimension 1 Code and Global Dimension 2 Code is still there on the Item table, but not on Item card.
There are a few options you can do:
1) Add the fields to the Item Card using AL
2) Use Item List for Power BI
3) You can pull and lookup at Default Dimension table. The dimension is stored there.
Share
Report
All responses (
Answers (
