Forum Discussion

Power Participant

4 years ago

Solved

SQL Syntax incorrect when using DISTINCT -PowerBI Report Builder

I am using Power BI Report Builder. I am querying data being held in SSMS. My SQL syntax seems to be incorrect when I use DISTINCT: SELECT [Sheet1$].ID ,[Sheet1$].Player ,DISTINCT([Shee...

Tips and Tricks

HamidBee
4 years ago
I realised that DISTINCT should come directly after the SELECT statement inorder for it to work.

SELECT DISTINCT [Sheet1$].Nationality, [Sheet1$].ID, [Sheet1$].Player FROM [Sheet1$]

Power Participant

4 years ago

I realised that DISTINCT should come directly after the SELECT statement inorder for it to work.

SELECT

  DISTINCT [Sheet1$].Nationality,

  [Sheet1$].ID,

  [Sheet1$].Player

FROM

  [Sheet1$]