Forum Discussion

sam245gonsalves's avatar
sam245gonsalves
Icon for Helper I rankHelper I
5 years ago
Solved

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][Hardy] (80)

I am connecting to a database in Databrick & creating a bar chart. I am counting accountid's by year(table A). However when I change to count(distinct) & use a filter from (Table B) accountid (Table...
Need Help
  • sam245gonsalves's avatar
    sam245gonsalves
    5 years ago

    I changed the accountid data type in table A to decimal & the chart seems to have rendered correctly.
    accountid in table B is still whole number.

    So weird...

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi, 

I'm also getting a similar error,

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.sql.AnalysisException: Table or view not found: u_sc_planning_preprod_frp.u_inventory_actuals_data; line 12 pos 0 at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:47) at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org$apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:435) at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2$$anon$3.$anonfun$run$2(SparkExecuteStatementOperation.scala:257) at

 

 

I'm trying to connect to databricks cluster, i was able to do it successfully before, suddenly i am getting this error, these tables exist in the dataset idk why its showing not found

  • jhyaikuti's avatar
    jhyaikuti
    New Member
    3 years ago

    hi Surabhi_p22, I am running into a similar issue. I can query the db directly, but getting error in PBI Desktop/PBI Service. Were you able to resolve your issue...if yes, can you share your learnings? Thanks, Jhyaikuti

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, Yes, my issue was resolved as we are connected to azure databricks for our source, the refreshes were failing because there was not enough memory in cluster, azure admin had to increase the memory and had to restart the cluster after that tables started refreshing at power bi end as well

    • Shivam_Kathpal's avatar
      Shivam_Kathpal
      Frequent Visitor
      3 years ago

      Hi jhyaikuti , I am also facing the same error while connecting power bi with My sql, query is working fine in my sql, but while fething data from my sql to power bi similar error is coming, any help who solved this error, 

       

      Thanks,

      Shivam