Direct Query on SAP HANA - ODBC syntax error after last update

[Anonymous]

Good Morning,

after the last Power BI Update we are facing some issues with our Direct Query reports based on SAP HANA.

It seems that after the last Update the query execution plan create SQL query with wrong syntax every time we interact with a slicer on a report.

We analyzed the On-Premise Data Gateway logs and we found that SQL query like these raise errors:

SELECT "basetable0"."c97","basetable0"."c98"
FROM
(
(

SELECT "t4"."Esercizio Sales" AS "c96","t4"."Data Sales" AS "c97","t4"."Mese Sales" AS "c98"
FROM
(
(select "DueYear" as "Esercizio Sales",
    "C1" as "Data Sales",
    "DueMonth" as "Mese Sales",
    "DueWeek" as "Settimana Sales"
from
(
    select "DueYear",
        "DueDate",
        "DueMonth",
        "DueWeek",
        cast("DueDate" as DATE) as "C1"
    from "_SYS_BIC"."sap.sbo/SALES_ANALYSIS"
    group by "DueYear",
        "DueDate",
        "DueMonth",
        "DueWeek"
) as "ITBL"
where "C1" >= date'20120101' and "C1" <= date'20181231')
)
 AS "t4"
WHERE
(
"t4"."Esercizio Sales"            =        '2017'
)

GROUP BY "t4"."Esercizio Sales","t4"."Data Sales","t4"."Mese Sales"
)
 AS "basetable0"INNER JOIN
(

(SELECT '2017' AS "c96",'10' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'11' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'12' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'01' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'02' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'03' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'04' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'05' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'06' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'07' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'08' AS "c98" )  UNION ALL
(SELECT '2017' AS "c96",'09' AS "c98" )
)
 AS "semijoin1" ON
(

("semijoin1"."c96" = "basetable0"."c96" OR "semijoin1"."c96" IS NULL AND "basetable0"."c96" IS NULL)
                AND        
("semijoin1"."c98" = "basetable0"."c98" OR "semijoin1"."c98" IS NULL AND "basetable0"."c98" IS NULL)

)
)

GROUP BY "basetable0"."c97","basetable0"."c98"
LIMIT 1000001

the error occurs at the highlighted statement and seems related to the SELECT statement without FROM clause created by THE Power BI engine which SAP HANA cannot manage.

We are facing the same issue in Power BI Desktop

How is it possible?

Regards

Power BI Desktop error

[RafalK]

same problem:

http://community.powerbi.com/t5/Service/Different-Power-BI-instances-generate-different-SQL-codes/m-...

[v-qiuyu-msft]

Hi all, 

Please check if you have set any visual / page / report level filter in the report. There is a known issue that the visuals fail to render when using filter in SAP HANA DirectQuery mode. You can see from Support site: 

Best Regards,
Qiuyun Yu