Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
@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
We have the same exact problem with the SAP HANA connector!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.