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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Anonymous
Not applicable

Direct Query adding curly brackets to Test GUID Field

I had a source table that was IMPORT mode and took it out and reloaded as DIRECT.

 

The GUID text field for My Item ID field started getting a Curly Bracket {} added around it. 

Now that field doesnt join to my Item table.

 

When I go to Edit Query I dont see the Brackets. But in my report and data view on Desktop I see the brackets.

 

I found one article on google about this but the question never got answered.

7 REPLIES 7
daniel_leite
New Member

I fixed this by forcing the unique value column to be text in Power Query. In fact it was yet text, but I added a new step "changing" it's type to text. 

adil_sdj
New Member

Hi, 

 

I encountered the same problem and in my case I realised that once I converted a field to date in the table where I had my UUID, PowerBI no longer identified the UUID as an ID with the curly brackets but kept is as normal text, so I simply added an arbirtrary date field which I do not use in my table where I had the brackets on the UUID table and it worked. Hope it helps!

Anonymous
Not applicable

@Anonymous @jxu @d_gosbell I am experiencing the same problem. Did you report this as a bug? Or found a workaround? I will also try your suggestion d_gosbell

I never had a model that reproduced this issue so I was just suggesting some options. Without being able to reproduce the issue it's pretty hard to figure out what the root cause might be

Anonymous
Not applicable

I've just stumbled across the same issue, I was using a GUID as a relationship and I couldn't figure out why the filtering wasn't working! So annoying! I've literally got 2 files with identical queries in them producing different results.

 

Has this been reported as a bug? I'd like to endorse it if possible...

jxu
New Member

I encountered the same issue. Hope that it can be resolved shortly.

 

Judy

d_gosbell
Super User
Super User

This does look a bit like a bug. My guess would be that in Direct Query mode the conversion from Guid to Text is done in a different layer, while in import mode it's done by the PowerQuery engine. 

The only quick fix I can think of is to force the formatting to be consistent. Probably the best thing for performance would be to add the { } braces around the guids in the import table. Or you could use a view for you direct query source and do a "CAST( guidcol as VARCHAR(50))" in that view to force SQL Server to do the conversion to text (which does not include curly braces). The down side of this is that it has to do that conversion for every query.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.