Import Item Availability by BOM
Follow these steps to enable the Item Availability by BOM report in Power BI:
​
1. Open the Power BI Insights Connector app.
​
2. Select Setup per Company > Insights Setup.
3. Enable “Import Item Availability by BOM”. Keep in mind that you'll need to perform this action for each company you import into Power BI.
By clicking on the 'Show more' button, you will be presented with additional filtering options that can help refine your import:
-
Exclude Blocked Items: Enabling this option will prevent the import of the BOM (Bill of Materials) for any blocked items in Power BI.
-
Item Category Filter: This option allows you to selectively import BOM data for specific item categories. Simply choose the categories you wish to include, and only the relevant BOMs will be imported.
4. Once you have enabled this setup, please proceed to run the manual data refresh in Power BI Workspace.
If you will experience data refresh errors with the Inventory Insights app, disabling item availability by BOM may help resolve the issue.