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
