免费开发工具 · Apache Ossie / Dosi

Apache Ossie 转 Power BI 语义模型转换器

将 Apache Ossie 定义导出为离线 Power BI / Microsoft Fabric BIM JSON。检查目标元数据、生成文件并验证模型。

无需注册 · 内置测试样例 · 离线转换检查

转换工作台

源文件1样例

Omni Sales · ANSI_SQL

omni_sales.yml

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

# yaml-language-server: $schema=../../../../core-spec/ossie-schema.json
#
# Fixture A -- all-native round-trip (Ossie -> Omni -> Ossie).
# Star schema; every construct maps to a native Omni slot. Documented
# normalizations on the Ossie -> Omni -> Ossie trip: relationship names are
# regenerated (`<from>_to_<to>`), and unique_keys that merely restate the
# primary key are absorbed by it.

version: "0.2.0.dev0"

name: sales
description: Sales orders with customer attributes
ai_context:
  instructions: "Use this model for order analysis."
datasets:
  - name: orders            # fact: no incoming relationship -> topic base_view
    source: samples.tpch.orders
    primary_key: [o_orderkey]
    description: One row per order
    fields:
      - name: o_orderkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderkey
        description: Order identifier
      - name: o_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_custkey
      - name: o_orderdate
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderdate
        label: Order Date
        dimension:
          is_time: true
        ai_context:
          synonyms: [order date, date]
      - name: o_totalprice
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_totalprice
  - name: customer
    source: samples.tpch.customer
    primary_key: [c_custkey]
    fields:
      - name: c_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_custkey
      - name: c_name
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_name
        description: Customer name
relationships:
  - name: orders_to_customer
    from: orders
    to: customer
    from_columns: [o_custkey]
    to_columns: [c_custkey]
metrics:
  - name: total_revenue
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: SUM(orders.o_totalprice)
    description: Total order revenue
    ai_context:
      synonyms: [revenue, sales]
  - name: order_count
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: COUNT(*)
    description: Number of orders

源文件仅保留在内存中，请一并上传所有被引用的文件。查看原始样例

结果

选择目标平台并转换，在此预览临时文件。

点击转换时，当前源文件将发送至 Datus 服务器；不会连接数据仓库或执行 SQL。

此转换器的用途

由 Apache Ossie 定义生成离线 Power BI / Microsoft Fabric BIM 模型。此流程生成供检查的模型文件，不会将语义模型发布到 Fabric 工作区。

来源格式

Apache Ossie YAML。使用内置销售模型，或上传自己的兼容定义，再检查数据集、关联与指标。

生成产物

Microsoft Power BI / Fabric 目标的离线 BIM JSON。已部署目录会提供目标所需元数据，转换前需完成必填项。

转换步骤

检查 Ossie 销售样例，或上传准备导出的模型。
保留 Power BI / Fabric 目标，填写工作台显示的必需元数据。
转换并检查生成的 BIM 结构、原生表达式与诊断。
下载产物，在目标流程验证，并比较代表性 Power BI 度量。

使用产物前需要检查的事项

产物不是 PBIX 报表、在线工作区连接或已部署的 Fabric 项目。

请验证目标元数据和度量行为。转换不会执行 DAX、刷新模型或证明原生表达式等价。

继续探索

常见问题

Ossie 转 Power BI 会导出什么格式？

Microsoft Power BI / Fabric 目标导出离线 BIM JSON，不会创建 PBIX 报表或发布在线 Fabric 语义模型。

哪些 Power BI 目标配置是必填项？

已部署的目标目录提供必填字段。请先填写工作台显示的元数据，再执行转换，并针对目标环境核对生成模型。

BIM 导出能证明原生度量语义一致吗？

不能。请阅读表达式与兼容性诊断，在目标流程验证 BIM 定义，并比较代表性度量。转换器不会执行 DAX 或刷新模型。