report failed during refreshing ( using 2 different data sources)

[razieh12]

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?

[aj1973]

Hi @razieh12 

What is the message?

[razieh12]

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