Data refresh error. October 2020 last version

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

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

I'm also encountering this same error in one of my report.

However in my research I've seen that it could potentially be caused by having 2 columns with the same name, which would be the case in your "table 6" (both user_id and week). You could try renaming both of them in the query and see if it fixes the issue.

If it ends up being the solution it's a real problem that Desktop and Report Server do not have the same behavior.

Hi Jean. This is the first thing I tried. Unfortunately, not working for me.

Hi declanR ,

The latest version has been released. Version: 1.9.7675.15620 (Build 15.0.1104.300), Released: January 8, 2021*

It fixed some bugs:

        - Fixed issue with refresh of reports with two or more data sources that differ only by the casing of the letters.
        - Fixed issue with refresh of reports certain combinations of nested joins.

Please update and check if it solves the issue you are experiencing.😊

Reference: Power BI Report Server October 2020 update 2 - Microsoft Power BI Community

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Thanks, MS. My big pain is resolved (maybe). Testing now

Power BI Report Server

• Version: 1.9.7675.15620 (Build 15.0.1104.300), Released: January 8, 2021
  • Bug fixes
    • Fixed issue with refresh of reports with two or more datasources that differ only by the casing of the letters.
    • Fixed issue with refresh of reports certain combinations of nested joins.