SQL Unable to connect

[R__S]

Hi Experts,

I am very very novice at power BI, currently I'm trying to pull data from SAP B1, whe  I enter in the server name and database name it promted me to a login window. I used my microsoft creentials that I use to get into SAP B1 and then this message popped up. 

I'm not sure what this means and can't seem to find out a proper way to fix it, I'm not even too sur how to find the certificate chain or anything. Like I said I'm new to this and computers are not my thing so any help in the simplest form of english would be great. 

Thanks!

[Anonymous]

Hi @R__S 

Based on your information, You can consider to use SAP HANA database to connect it .

but  you must have the SAP HANA ODBC driver installed on the local client computer. You need to install the related files first, and you can refer to the following link.

Solved: SAP B1 and Power BI connection ERROR- since new u... - Microsoft Fabric Community

Power Query SAP HANA database connector - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.