Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Interestingly, if we try in DirectQuery it works:
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?
Solved! Go to Solution.
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.
@VP As your issue is different from this thread topic, please create a new thread in desktop forum.
Best Regards,
Qiuyun Yu
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.
As per the below microsoft step by step document Windows kerberoes authentican from Power BI to HANA is possible since Aug 2017 .
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 .
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 .
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?
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.
@VP As your issue is different from this thread topic, please create a new thread in desktop forum.
Best Regards,
Qiuyun Yu
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....
Working combination:
Version of SAP HANA Database Client for MS - 2.0.62.1478878744
Version of Power BI - May '17 2.46.4732.461
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |