Item Attribute Values table not found in Power BI web services

(2) Share

Report

Posted on by TS-09051001-0

I am trying to link my items with their corresponding attributes.

I have the following tables:
- Items
- ItemAttributes
- ItemValues

- ItemAttributeValuesTranslation: which is 7505 and empty

I want to know why table 7505 is not the ItemAttributeValueMapping?

How can I link items to their attributes for analysis in Power BI?

Thank you!

Categories:

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 60,818 Super User on at

Like (0)

Report

Item Attribute Values table not found in Power BI web services

Hi, hope the following can give you some hints.

Dynamics 365 Business Central: Show Item Attributes on the page (For Example: On Item List page)

https://yzhums.com/3546/

Thanks.

ZHU
Suggested answer

gdrenteria 3,108 Super User on at

Like (0)

Report

Item Attribute Values table not found in Power BI web services

Hi

I hope this can help you

How to get item attributes via api. (dynamics.com)

AL-Code-Samples-Education/qry50121.ItemAttributeValueMapping.al at AL-Queries · rstefanetti/AL-Code-Samples-Education · GitHub

BR

GR
Suggested answer

Mohamed Amine Mahmoudi 4,311 User Group Leader on at

Like (0)

Report
Item Attribute Values table not found in Power BI web services

Hi,

The values are stored in the "Item Attribute Value" table (7501)

Relation : "Item Attribute Value Mapping"."Item Attribute Value ID" = "Item Attribute Value".ID

Best regards,

Mohamed Amine MAHMOUDI