Direct Query report on SAP HANA - ODBC 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

[v-yuezhe-msft · Accepted solution]

@Anonymous @RafalK,

According to Power BI Support, this is a known issue, and the fix is in progress.

"Users may experience issues rendering visuals when applying filters on SAP HANA Direct Query sources. Engineers are aware of the issue and are working on a fix. Next Update 01/11/2018 @10:00 PST."

Regards,
Lydia

[RafalK]

We have the same exact problem with the SAP HANA connector!