Reply
Frequent Visitor
Posts: 12
Registered: ‎01-12-2017

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
Posts: 2,588
Registered: ‎03-06-2016

Re: Curly braces on unique identifiers

@lizrowden

 

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.

 

Regards,

 

Highlighted
Frequent Visitor
Posts: 12
Registered: ‎01-12-2017

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