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 3 - sql request:
SELECT
ul.user_id,
ul.timestamp AS timestamp_st,
ul.value_new
FROM user_log_data ul
LEFT JOIN users u
ON ul.user_id = u.id
WHERE ul.field = 'level'
AND u.regdate >= '2014-01-01'
AND ul.timestamp >= '2020-07-27 14:30:30.0000000'
AND u.is_active = 1