Forum Discussion

razieh12's avatar
razieh12
Frequent Visitor
2 years ago

report failed during refreshing ( using 2 different data sources)

Hello 

I created a report I which I pull out data from two different sources ( sql and Databricks) . I pulled out data from one of the tables of each of the above datasources and joined them to create the new table which I used for my report. for sql I used gateway and for databricks since it is cloud based it did not require gateway.

My question, 

when I publish the report in power bi service the report failed in refreshing process. the error massege is about databricks error.

do you have any idea why this happens?

Need Help

2 Replies

    • razieh12's avatar
      razieh12
      Frequent Visitor
      2 years ago

      Hello 
      Error: Data Source Error : DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Error running query: org.apache.spark.SparkException: Job aborted due to stage failure