Forum Discussion
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.
1 Reply
- v-frfei-msft
Community Support
Hi Tedhan12 ,
When you use multiple data sources, it's important to understand how data is moved back and forth between the underlying data sources, and the security implications it brings.
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about