cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Connecting to SAP HANA

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

Highlighted
Solution Specialist
Solution Specialist

Re: Connecting to SAP HANA

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
Highlighted
MVP

Re: Connecting to SAP HANA

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

Highlighted
Community Support
Community Support

Re: Connecting to SAP HANA

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

Highlighted
Solution Specialist
Solution Specialist

Re: Connecting to SAP HANA

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

Highlighted
Solution Specialist
Solution Specialist

Re: Connecting to SAP HANA

@bschafbuch

 

What sort of questions do you have?

Highlighted
New Member

Re: Connecting to SAP HANA

What drivers do I need to connect to SAP HANA?  

Highlighted
New Member

Re: Connecting to SAP HANA

What drivers do I need to connect to SAP HANA?

Highlighted
Solution Specialist
Solution Specialist

Re: Connecting 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

 

Highlighted
Solution Specialist
Solution Specialist

Re: Connecting to SAP HANA

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

Highlighted
New Member

Re: SSO connection with kerberoes -Windows Authentication to SAP HANA

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 .

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors