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 ：

并在Daxstudio中运行查询以获取新表名：

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

您仍然可以在服务器时间的查询列中看到原始表名。

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

是否可以更改使用M创建的原始表名？

我可以补充一点，该错误仅适用于用M创建的表（输入数据或插入服务器）。 DAX表不能重现此错误。更改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屋！