cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mardin
Advisor

Dataflow to SAP HANA unable to connect: "Please specify how to connect."

I am successfully able to connect to SAP HANA from Power BI Desktop.

I am successfully able to add SAP HANA data source to our On Premise Gateway and perform a scheduled refresh of a report.

 

But when I try create a Dataflow in Power BI Service by simply copying the query text from Power BI Desktop Advanced Query Editor and paste it into the Dataflow "Blank Query" interface I am unable to proceed and connect.

 

It keep saying "Please specify how to connect." even when I enter the same user credentials that I can successfully connect with in both Power BI Desktop and the On Premise Gateway.

 

Any suggestions?

 

Based on article below the SAP HANA connector should now be supported in Dataflows.

https://powerbi.microsoft.com/da-dk/blog/power-bi-dataflows-january-updates/

 

Untitled.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dataflow to SAP HANA unable to connect: "Please specify how to connect."

Hi @Mardin,

 

Yes, I can reproduce this issue.

 

You can refer to below steps if it works on your side:

1. Add a new entity with another type of datasource(e.g, sql) and use your gateway to manage this entity.
2. Add new entity with 'blank query' connector and manually input SAP query formula.
3. Click 'please specify how to connect' to input your credentials and you can find your gateway(which used in other dataflow) has be recognized as default gateway to handle current SAP datasource.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
4 REPLIES 4
Community Support Team
Community Support Team

Re: Dataflow to SAP HANA unable to connect: "Please specify how to connect."

Hi @Mardin,

 

Yes, I can reproduce this issue.

 

You can refer to below steps if it works on your side:

1. Add a new entity with another type of datasource(e.g, sql) and use your gateway to manage this entity.
2. Add new entity with 'blank query' connector and manually input SAP query formula.
3. Click 'please specify how to connect' to input your credentials and you can find your gateway(which used in other dataflow) has be recognized as default gateway to handle current SAP datasource.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
Mardin
Advisor

Re: Dataflow to SAP HANA unable to connect: "Please specify how to connect."

Yes!! That did the trick! Thank you!

 

Hopefully this bug will get fixed sooner or later.

vmakhija Member
Member

Re: Dataflow to SAP HANA unable to connect: "Please specify how to connect."

@v-shex-msft

do you know if this bug was fixed?

 

Regards

Mardin
Advisor

Re: Dataflow to SAP HANA unable to connect: "Please specify how to connect."

No, unfortunately the issue remains. Just tested again this morning.