Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FabioBeka
Frequent Visitor

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

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"

 

FabioBeka_0-1625731888891.png

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!

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @FabioBeka ,

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.

vyangliumsft_0-1626160651787.png

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @FabioBeka ,

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.

vyangliumsft_0-1626160651787.png

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
Super User
Super User

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.