Power BI 更改在 Daxstudio 中显示的原始表名称 [英] Power BI change original table name which is displayed in Daxstudio

问题描述

我注意到非常奇怪的是 Daxstudio 允许您查看原始表名.这有点牛塞，因为当您重命名在 M 中创建的表时，Daxstudio 仍然使用原始表名而不是新名称来引用它.以下是如何重现该错误.

I noticed very odd thing that Daxstudio allows you to view original table name. It is a bit niuanse because when you rename table created in M then Daxstudio still refers to it using original table name, not the new name. Here is how to reproduce the bug.

Power BI > 主页 > 输入数据

Power BI > Home > Enter Data

将表命名为 RedTable.

在 Daxstudio 中运行查询:

Run a query in Daxstudio:

EVALUATE
DISTINCT('RedTable'[Column1])

现在将表格重命名为 BlueTable:

Now rename the table to BlueTable:

然后在 Daxstudio 中运行查询以获取新表名:

And run the query in Daxstudio for a new table name:

在 Server Timings 的 Query 栏中仍然可以看到原始表名.

You can still see the original table name in the Query column of Server Timings.

有没有办法改变这个用 M 创建的原始表名?

我可以补充一点，此错误仅适用于使用 M 创建的表(无论是输入数据还是插入服务器).DAX 表无法重现此错误.DAX 表在您更改名称后会更新，实际(非原始)名称显示在 Daxstudio 的 Server Timings 的 Query 列中.

I can add that this bug is applicable only to tables created with M (be it Enter Data or plug to Server). This bug is not reproducible with DAX tables. The DAX tables are updated after you change their name and actual (not original) name is display in Query column of Server Timings of Daxstudio.

推荐答案

这不是 DAX Studio 的问题，尽管我们可以尝试在 DAX Studio 中修复它.:)以下是发生的情况:表格模型(也由 Power BI 使用)具有每个对象的 ID，然后是名称.该 ID 由 Power BI 和 Visual Studio UI 在您创建实体(表/列/...)时分配.Visual Studio 将 ID 显示为只读属性，而 Power BI 根本不显示该属性.ID 在内部用于引用表格对象模型 (TOM) 中的对象.它还用于在公式引擎和存储引擎之间的交互中识别列.DAX Studio 捕获的存储引擎查询是通过连接到 Analysis Services 会话的调试会话截获的消息，在这些消息中，文本通过其 ID 而不是通过 Name 属性表示实体(特别是表名).正如微软所说，这是设计使然".到目前为止，DAX Studio 只是捕获存储引擎查询的文本并显示此信息.但是，DAX Studio 会按摩"文本，去除大量噪音"并使查询更具可读性.在此阶段，可以考虑使用名称重命名 ID.我刚刚创建了一个功能请求.那很简单.什么时候实现这个功能，找时间要难得多！

This is not a problem of DAX Studio, even though we could try to fix it in DAX Studio. :) Here is what happens: the Tabular model (used also by Power BI) has an ID for each object and then a Name. The ID is assigned by the Power BI and Visual Studio UI when you create an entity (table/column/...). Visual Studio shows the ID as a readonly property, whereas Power BI doesn't show that property at all. The ID is used internally to reference the objects in the Tabular Object Model (TOM). It is also used to identify column in the interaction between Formula Engine and Storage Engine. The Storage Engine queries captured by DAX Studio are messages intercepted with a debugging session connected to the Analysis Services session and in these messages the text represents entities (in particular table names) through their ID rather than through the Name property. As Microsoft would say, this is "by design". So far, DAX Studio simply capture the text of the storage engine queries and display this information. However, DAX Studio "massages" the text, removing a lot of "noise" and making the query more readable. During this phase, it is possible to consider renaming IDs with Names. I just created a feature request. That was easy. When to implement the feature, finding the time is much harder!

这篇关于Power BI 更改在 Daxstudio 中显示的原始表名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！