Sql request gives a data source error

[NeedMorePower]

When I import data from Sql Database it would work without problem. When I split a colum an ODBC data source error occurs. 

Why this happens?

Regards 

[v-juanli-msft]

Hi @NeedMorePower 

What is the error message?

Could you show me the code in Advanced editor?

Best Regards
Maggie

[NeedMorePower]

Hi Maggie

Thanks for your reaction. I was in holiday. I can load the data form SQL to power bi with the following querry:

SELECT TOP 1000000 lv.[LinkID], s.SensorID,s.Auftragsnummer ,lv.[VORNR],j1.[StatusID],j1.[Timestamp],j2.[StatusID],j2.[Timestamp],CAST(j2.[Timestamp] - j1.[Timestamp] as time) as Diff_h, afvc.LTXT, makt.MATNR, makt.MAKTX
FROM [P76].[SensorIDLink] as s
INNER JOIN [P76].[LinkVorgänge] as lv ON s.LinkID = lv.LinkID
INNER JOIN [P76].[StatusJournal] as j1 ON j1.LinkID = lv.LinkID AND j1.VORNR = lv.VORNR AND j1.StatusID = 'RDY' AND j1.Timestamp > '01.01.2019'INNER JOIN [P76].[StatusJournal] as j2 ON j2.LinkID = lv.LinkID AND j2.VORNR = lv.VORNR AND j2.StatusID IN ('FAIL') AND j2.Timestamp > '01.01.2019'
INNER JOIN SAP.[P76].AFKO as afko ON afko.AUFNR = s.Auftragsnummer
INNER JOIN SAP.P76.AFVC_STR as afvc ON afko.AUFPL = afvc.AUFPL AND '0200' = afvc.VORNR
INNER JOIN SAP.P76.RESB as resb ON afko.RSNUM = resb.RSNUM AND resb.POSNR = '0130'
INNER JOIN SAP.p76.MAKT as makt ON resb.MATNR = makt.MATNR and makt.SPRAS = 'D'
WHERE lv.ShopfloorId = 'EL104'

I can load the data in Power BI. But when i change Datatype or take away duplicates it is not possible to save an close the datasource. then the following failure comes back

OLE DB- oder ODBC-Fehler : [DataSource.Error] Fehler beim Lesen von Daten aus dem Anbieter: "Ein Element mit dem gleichen Schlüssel wurde bereits hinzugefügt.".

Have you an explanation for this behaviour and what should I change, the query works in SQL 

Thanks and Regards

Adrian