cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
viveksasi94 Regular Visitor
Regular Visitor

Encryption Error while trying to load data from SAP HANA model

Hi,

When connecting PowerBI to SAP HANA and load the tables, I get the following error. I would be grateful if someone could help me with this.

Feedback Type:
Frown (Error)

Error Message:
Connection encryption for 'SapHana' isn't supported in DirectQuery mode. Turn off encryption for this data source or switch to import mode.



1 ACCEPTED SOLUTION

Accepted Solutions
SamLester Established Member
Established Member

Re: Encryption Error while trying to load data from SAP HANA model

Hi, the error message provides you with the two options you have in this case.

 

1. Turn off encryption for the data source.

 

To do this, click on the File -> Options and Settings -> Data Source Settings in the toolbar. Select your data source and edit the properties. You'll see the encryption checkbox. You can unselect this to be able to use this data source.

 

EncryptConnection.png

2. Switch to import mode. This will import the data into the .pbix file as opposed to using the live connection that you've established.

 

 

 

Good luck,

Sam Lester (MSFT)

1 REPLY 1
SamLester Established Member
Established Member

Re: Encryption Error while trying to load data from SAP HANA model

Hi, the error message provides you with the two options you have in this case.

 

1. Turn off encryption for the data source.

 

To do this, click on the File -> Options and Settings -> Data Source Settings in the toolbar. Select your data source and edit the properties. You'll see the encryption checkbox. You can unselect this to be able to use this data source.

 

EncryptConnection.png

2. Switch to import mode. This will import the data into the .pbix file as opposed to using the live connection that you've established.

 

 

 

Good luck,

Sam Lester (MSFT)

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 94 members 1,580 guests
Please welcome our newest community members: