Forum Discussion
Data refresh error. October 2020 last version
Hi! Com error: mscorlib, An item withe the same key has already been added. Power BI Desktop and PowerBi report server last version. Source - sql server request. Merging with a table based on a que...
table 6 - sql request:
SELECT
*
FROM (SELECT
ub1.user_id,
MAX(ub1.timestamp) AS max_timestamp_b,
ub1.week
FROM (SELECT
ub.user_id,
ub.timestamp,
DATEPART(WEEK, ub.timestamp) AS week
FROM user_barcode ub
WHERE ub.timestamp >= '2020-07-27') AS ub1
LEFT JOIN users u
ON user_id = u.id
WHERE u.regdate >= '2014-01-01'
AND u.is_active = 1
GROUP BY ub1.user_id,
ub1.week) AS ub2