Custom Native SQL using Databricks SQL Warehouse in Power BI: Key didn't match any rows in table

[Anonymous]

Hi! Having a hard time connecting my Databricks SQL Warehouse to my Power BI even though if I'm loading individual tables it can connect. However, if I'm using a custom sql query even if i'm only selecting one table, it shows that error with no other details.

What I did:

- Open Power BI

- Login to my microsoft account

- Clicked get data and selected "Databricks"

- Added the host name and https; Added category and database and the query

- Query written this way:

SELECT distinct doft.id
FROM hive_metastore.dw_cep.table_1 doft 
WHERE doft.received_ts::date >= '2023-06-01';

- After clicking connect, I immediately get this error. Please help.

Thank you!

Regards,

Kara

[Anonymous]

Hi @Anonymous

With reference to the information provided by you, the following is the case description: When you use a custom SQL query, you encounter an error.

You can refer to the following steps to troubleshoot the problem.

• You can test if the query statement is correct in Databricks SQL Warehouse first.
• Simplify the query to the minimum and then gradually increase the complexity to see which step is wrong.

Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Already tried a simple select * from table and tried querying first in Databricks and it works so I'm not sure what's wrong in Power BI 😞

[lbendlin]

See if this helps

Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...