Forum Discussion

Tedhan12's avatar
Tedhan12
Regular Visitor
6 years ago

An issue with the combination between the SAP HANA and SQL SERVER tables on direct query mode.

I am working on a report that combines databases from SQL Server and SAP HANA on direct query mode. When I add more than one table from SAP HANA and after I add a table from SQL Server, all the tables that I added disappear (both from SQL Server and SAP HANA), and the only table that shows up is the last one that I added. like you can see:

 

before I add the second table from SAP HANA (everything is working):

 

 

after I add the second table from SAP HANA (everything disappears):

 
 

Also, the last table that we can see contains all the columns that exist in this table, although I chose only two of them and not them all:

 

and when I try to see the data in this table, I got this error:

Besides, all the functions of power bi are frozen. I can't click on the "Edit Query" button or see the relationships that exist in the model:

 

I want to mention that when I add the table from the SQL SERVER, I get this message:

 

 

 

Also, all the tables on direct query mode and the tables are working if I don't combine data from SQL SERVER and SAP HANA in the same report.

 

I would like to know why it happens and how I can fix it.

Thank you.