Showing results for 
Search instead for 
Did you mean: 
lizrowden Regular Visitor
Regular Visitor

Curly braces on unique identifiers

I am getting data from SQL server 2014 import mode. When I do a query select from a table function, unique identifiers do not have curly braces. But when I select/invoke the function from the list, curly braces are there. Is there some explanation for this?

Moderator v-sihou-msft

Re: Curly braces on unique identifiers



In Power Query, you always need to use Curly braces on a List Object. For table object, you just need to give a table name. For more details, please refer to Power Query document.




lizrowden Regular Visitor
Regular Visitor

Re: Curly braces on unique identifiers

I really appreciate your help, but I was unable to understand the answer from the link. I attached some screen shots to further explain



select.png#1 - use select statementselectdata.png#1 - no curly bracessearch.png#2 - select from listsearchdata.png#2 - data has curly braces


Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 198 members 2,256 guests
Please welcome our newest community members: