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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
GillesTT
New Member

PowerBi Desktop behind a proxy user with authentication

Hello I try to use PowerBi Desktop with dataverse source.

I am using a user's proxy with a pac (Zscaler) authenticated

I am not able to connect to dataverse source (SQL error).

Without proxy on my personnal laptop, I have no problem to connect.

How can I solve that ?

I already try registry key UseDefaultCredentialsForProxy=1 without success

I don't succeed to set information in .config file

I will appreciate some help

 

Regards

Gilles

2 REPLIES 2
GillesTT
New Member

Hello

 

Thank you for your response, but it doesn't help me

The connector used is Dataverse, and I need to use this connector

Regarding suggestion in your last URL, I already see it., and it does't help. 

 

Regards

Gilles

v-chenwuz-msft
Community Support
Community Support

Hi @GillesTT ,

 

  1. You need a connector for power bi desktop to connect the SQL. Please refer this article. For example, the data service is Oracle, Users need to install the Oracle MySQL Connector/NET package prior to using this connector in Power BI Desktop. This component must also be installed on the machine running the on-premises data gateway in order to use this connector in Power Query Online (dataflows) or Power BI Service.
  2. Edit the Authentiaction. If the verification is unsuccessful, please use another authentication method.
  3. Check the data source service, if it allow external ip to connect it or deny connection to this proxy.
  4. Refer the SQL error. Perhaps some of the information could suggest where the problem lies.

Or you can refer this post.

https://community.powerbi.com/t5/Desktop/AnalysisServices-The-remote-server-returned-an-error-407-Pr... 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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