Create Semantic Model as in Business Objects

Thankyou, samratpbi, for your response.

Hi rnola16,

We appreciate your inquiry submitted via the Microsoft Fabric Community Forum.

Based on my understanding, Power BI does not provide a Universe object model. The semantic model and organized database views serve as its replacement. Without organization, exposing 14,000 fields across 1,000 tables would be unmanageable. While Power BI/Fabric can provide a comparable semantic layer experience, it will not be a one-to-one replacement for the SAP BO Universe.

Please consider the following approach, which may help to resolve the issue:

1. Create business friendly views or materialised aggregates for the most frequently used fields and common queries, so that the heavy processing remains in Teradata.
2. Connect these organized views to a Power BI dataset or semantic model. Hide technical columns, add display folders and descriptions, and define standardised measures.
3. Maintain detailed history in Teradata via DirectQuery, and import recent or aggregated slices into Power BI to improve performance.
4. Host the dataset in Fabric or Premium, and enable the Large Semantic Model feature if required.

For further guidance, please refer to the following links:
Power Query Teradata database connector - Power Query | Microsoft Learn
Power BI Semantic Models - Microsoft Fabric | Microsoft Learn
DirectQuery in Power BI - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Composite model guidance in Power BI Desktop - Power BI | Microsoft Learn
Large semantic models in Power BI Premium - Microsoft Fabric | Microsoft Learn

We hope this information is helpful. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.