cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diwakarjha Frequent Visitor
Frequent Visitor

Guid import in PowerQuery from SQL View becomes lowercase, hence join fail in report

Hello team,

 

I replaced the source of one query from SQL table to SQL View. When I import the view, GUID column is shown in lowercase even though in SQL it is uppercase. Because of this,the join is failing. I can now make both joining column same case but is this the work around ? I have so many other reports with View as source, which has been working fine before. Is it something in the latest update ? I see on the PowerBI support said about GUID case sensitive but it is not exactly related to my issue and also not my region. Please the see text below from powerbi support page

 

"Some customers in the India West region that use applications that call the GetReports API or GetReports in a Group API will receive the Report ID GUID back in upper case letters and not in lower case letters as it was previously. This may cause an application comparing report Object ID to a pre-defined Object ID to fail getting the report if the comparison is case sensitive. As a workaround, customers can change the report Object ID comparison to not be case sensitive. Engineers are working on a fix and will provide and ETA shortly. "

 

Do i have to always convert guid column if it is used in any kind of join ? Please advice

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Guid import in PowerQuery from SQL View becomes lowercase, hence join fail in report

Hi there

The support page that you got was for the GetReports API and would not relate to your GUID from your dataset.

I would suggest just to ensure that joins always work, is to ensure that you make them both uppercase or lower case. In doing so will mean that it always works.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
1 REPLY 1
Super User
Super User

Re: Guid import in PowerQuery from SQL View becomes lowercase, hence join fail in report

Hi there

The support page that you got was for the GetReports API and would not relate to your GUID from your dataset.

I would suggest just to ensure that joins always work, is to ensure that you make them both uppercase or lower case. In doing so will mean that it always works.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 132 members 1,909 guests
Please welcome our newest community members: