Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aron_Moore
Solution Specialist
Solution Specialist

Connecting to SAP HANA

Hello all,

 

Any have experience with connecting to SAP HANA? Our models were working fine until the last two updates (June '17, July '17).

 

Managed to roll back to the May '17 build but still get an error:

Capture1.PNG

Interestingly, if we try in DirectQuery it works:

Capture2.PNG

 

I feel like it's a size limitation issue. When selecting just a few columns from the cube it works, get to a certain number of selections and it errors. Need to use Import to mash-up with other sources.

 

Thoughts? What else should I check?

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

Hi @Aron_Moore,

 

The PG team has investigated the same issue and suspect the error to be coming from HANA driver as no changes had been made in Power BI. To understand the issue better could you also provide a desktop trace while accessing the report both using the Power BI desktop July and May versions? You can enable tracing on the Diagnostics tab of the Options dialog.

 

q2.PNG

 

@VP As your issue is different from this thread topic, please create a new thread in desktop forum.

 

Best Regards,
Qiuyun Yu

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

View solution in original post

Aron_Moore
Solution Specialist
Solution Specialist

Looks like we finally have a solution. Seems we need to set the calculation views to Data Category: Dimension for the HANA connector to work properly. I can't find where it says that in the Microsoft documentation and am waiting for a reply.

View solution in original post

10 REPLIES 10
bheem4ut
New Member

As per the below microsoft step by step document  Windows kerberoes authentican  from Power BI to  HANA is possible since Aug 2017 .

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-kerberos-for-sso-pbi-to-on-premise...

 

I have followed the same steps but it did  not work .

 

Pls advise . if any latest blogs  with more working examples and cases with HANA .

 

 

Aron_Moore
Solution Specialist
Solution Specialist

Looks like we finally have a solution. Seems we need to set the calculation views to Data Category: Dimension for the HANA connector to work properly. I can't find where it says that in the Microsoft documentation and am waiting for a reply.

Hi

 

I was trying to Configure  HANA   SSO using  kerberoes  windows athentication got issues .

 

Microsoft says  its possible from Aug 2017  but  , we are not able to Connect  using  step by step guidance  given in the below url  .

 

https://docs.microsoft.com/en-us/power-bi/service-gateway-kerberos-for-sso-pbi-to-on-premises-data

 

If anyone configured got success  on the same pls advise me .

Aron_Moore
Solution Specialist
Solution Specialist

@bschafbuch

 

What sort of questions do you have?

What drivers do I need to connect to SAP HANA?

The SAP HANA database client contains the drivers you need. Instructions in the link:

 

https://archive.sap.com/documents/docs/DOC-60373

 

What drivers do I need to connect to SAP HANA?  

v-qiuyu-msft
Community Support
Community Support

Hi @Aron_Moore,

 

The PG team has investigated the same issue and suspect the error to be coming from HANA driver as no changes had been made in Power BI. To understand the issue better could you also provide a desktop trace while accessing the report both using the Power BI desktop July and May versions? You can enable tracing on the Diagnostics tab of the Options dialog.

 

q2.PNG

 

@VP As your issue is different from this thread topic, please create a new thread in desktop forum.

 

Best Regards,
Qiuyun Yu

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

Great idea. I did update the driver. Rolled back to the previous version and it now works.

So much for keeping software up to date.... Smiley Frustrated

 

Working combination: 

Version of SAP HANA Database Client for MS -  2.0.62.1478878744

Version of Power BI -                                           May '17 2.46.4732.461

VP
MVP

I have similar issue plus

 

-I do not see all HANA datasource using Power BI after latest update.

-I can see all data source using Excel > SAP HANA Database

 

VIvek Patel

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.