Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
POWER BI desktop-- SAP HANA, Refresh is working fine in both dev and prod of hana.
Power bi service - SAP Hana refresh is working with DEV but not on prod server of hana.
Note
role of both dev and prod is same.
Cluster URIWABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
Activity ID3f2209dd-63d6-443d-9eab-497cae54dad8
Request ID04467744-ebe2-540c-3c47-a08661148088
Time2020-08-05 09:56:38Z
Solved! Go to Solution.
Verify your credentials once again.
If you are using the hostname in the source, try to use IP address and republish it into Power BI. Then add the source into gateway.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Assuming that you are using a gateway to enable the connection. Then, make sure the gateway is online and the prod source is added to the gateway.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi, Yes, we do have a separate gateway and in this gateway we have 2 data source.
one to DEV - which is working fine.
Other to prod - which has same settings as dev but when we pass the credentials and click on apply we get below error.
Note:
we tried the same with other user who has more roles than my id but still the same issue.
ODBC: ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10719 Connect failed
Verify your credentials once again.
If you are using the hostname in the source, try to use IP address and republish it into Power BI. Then add the source into gateway.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi, After using the IP it worked. Thank you.
Regards,
Praveen
Please mark my previous post as accepted solution. That will help others who are facing the similar issues.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
38 | |
27 | |
17 | |
16 | |
8 |
User | Count |
---|---|
46 | |
38 | |
34 | |
16 | |
16 |