I cannot name a table "Measures", throws error, is it a reserved name?

[Anonymous]

I'm trying to load some tables from SQL Server, one of these is a measures table, and it should be named accordingly as "Measures", but PBI throws me the following error:

The name of the object "Table" cannot be the reserved string "Measures"

What does this mean? Is "Measures" a system name that can't be used for naming tables? Is it a bug? Or did I break something?

Please help me!

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Measure is equivalent to a special mark of this power bi. If the table named as measure is loaded in, it will conflict with the default setting.

For example, there is a Sum function in the Dax function, so when we use Var, we cannot use Sum to name.

You can add a prefix symbol or letter in front of "Measure" and it can be used normally.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , Yes, I think table name can not be measures. It can be measure or KPI. It seem like a reserved word