Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm using PowerBi Service with Direct Query to Spark HDinsight. One of my fields in table is timestamp - but when I try to filter my report by specific date, I got blank values.
I've checked the query sent to Spark and see next:
SELECT (...) `t4` WHERE ( `t4`.`tsday` = CAST( '4/21/2016' AS timestamp) ) or SELECT (...) `t4` WHERE ( (`t4`.`tsday`) >= (CAST( '4/21/2016 12:00:01 AM' AS timestamp))
Both cases are unacceptable for Hive, it expects specific format: "yyyy-MM-dd HH:mm:ss.SSS"
I don't have any idea what to do, using time features is very powerful option and it seems like no walkarounds to do it
@romank May I ask how were you able to check the query DirectQuery feature sents to HDInsight ?