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
