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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
praveenthalati
Frequent Visitor

power bi service refresh not working when connected to sap hana

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

1 ACCEPTED SOLUTION

@praveenthalati 

 

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
🙂


Regards,
Nandu Krishna

View solution in original post

5 REPLIES 5
nandukrishnavs
Community Champion
Community Champion

@praveenthalati 

 

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
🙂


Regards,
Nandu Krishna

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

@praveenthalati 

 

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
🙂


Regards,
Nandu Krishna

Hi, After using the IP it worked. Thank you.

 

Regards,

Praveen

@praveenthalati 

 

Please mark my previous post as accepted solution. That will help others who are facing the similar issues.


Regards,
Nandu Krishna

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors