我想知道如何使用某些编程语言从表格数据库(Power BI Service或SSA)创建TMSL脚本。这些脚本可在几种工具中获得,例如SSM或表格编辑器:
菜单的示例来创建TMSL脚本在Active DB的SSM中
创建的内容(例如)类似的内容:
示例:示例:角色的TMSL脚本标头
因此,问题是,例如,是否可以自动执行Python库 / .NET包装器。我能够使用Pyadomd发送多个DMV,以通过零件提取信息(在备用表中使用几个查找以转换ID),然后将所有内容重新组合到脚本中,但是如果在某些地方可以更轻松地创建它的方法,则可能会更少的错误和时代的储蓄器。 。
提前致谢
亚历克西斯
I am wondering how is possible to create a TMSL script from an tabular database (power bi service or SSAS) using some programing language. These kind of scripts are available in several tools, like SSMS or Tabular Editor:
Example of the menu to create TMSL script in SSMS from an active DB
What creates (as an example) something like this:
Example: A TMSL script header for a role
So, the question is if, for example, a python library / .NET wrapper could do that automatically. I am able to send several DMVs using pyadomd to extract the information by parts (with several lookups in alternate tables to transforms ids) and then recompose everything into an script, but if where a easy way to create it could less error prone and time saver.
Thanks in advance
Alexis
发布评论
评论(1)
这是一个名为表格对象模型,可用于读取表格模型元数据并使用 json scripter 。
IT's a .NET Library called Tabular Object Model, which can be used to read Tabular Model metadata and generate scripts using the JSON Scripter.