Forum Discussion

gmangiante's avatar
gmangiante
Frequent Visitor
2 years ago

Odd DISTINCT behavior from lakehouse SQL Analytics Endpoint

Hello - this is a bit of an involved issue (apologies for length!) that started in PowerBI but seems to be really a SQL Analytics Endpoint oddity. I was creating a very simple bar chart report with a...
data engineering
power bi
HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
2 years ago

Hello gmangiante , 

Thanks for the adding the ask in so much details , this aloways helps . 

I am sorry as i do not have a solution but when PowerBi is converting the SQL into DAX query I am sure , somthing is happening there . I suggest you to please see if you can simplify the query and even better if you add that in a view and call the view from PowerBI , 

I really want to help but without the data and the schema i cannot do much from myside for now .

 

Thanks 
Himanshu