Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PBI Desktop connect to Azure via Proxy

We've just set up an Azure Data warehouse and i'm making my first connections to this data.  Connecting to this Data Warehouse via Power BI service was fine.  Trying to connect via the Desktop is pro...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    I am afraid that Power BI Desktop is not proxy aware, there is a similar idea about this issue, please vote it up.

    Meanwhile, please check if  the solution described in this similar thread works for you.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

It didn't work for me, but perhaps i've done something wrong.  This is the steps i took:

 

  1. Created a new empty file called Microsoft.Mashup.Container.exe.config
  2. Using Notepad++ i've copied in the code from your link into this config file and saved
  3. I've coped this config file into C:\Program Files\Microsoft Power BI Desktop\bin
  4. I've loaded up Power BI and opened a project file whose connections are to a database in Azure
  5. I have gone into Edit Queries to test the connection, recieving the usual error.  (This file works on my Azure VM)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Ross73312, that process looks correct. The only potential gap I see: the solution I proposed assumes you are able to authenticate through your proxy via the Windows Active Directory credentials associated with the user session you're using Power BI Desktop on (which implies that Power BI Desktop reads those same credentials as the "default credentials".

     

    If that's not the case in your environment, then I'd recommend:

    A) Determing how you can authenticate through the proxy in your environment.

    B) Using these docs to modify the proxy config file you created.

     

    This solution takes advantage of the same method used to configure the On-Premises Data Gateway for proxy awareness.

     

    It's too bad Power BI doesn't yet have a front-end UI interface for configuring proxy awareness. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Anonymous  Yes thats how our environment works, sadly the process doesn't work for me.

      • clementsmadja's avatar
        clementsmadja
        Regular Visitor
        8 years ago

        Hi,

         

        I'm running into the same issue with PBI and the Big Query connector.

         

        I created the Microsoft.Mashup.Container.exe.config file with no success...

         

        My proxy is using NTLM.

         

        I tried two solutions:

         

        1:

        <?xml version="1.0" encoding="utf-8" ?>
        <configuration>
          <system.net>
            <defaultProxy useDefaultCredentials="false">
              <proxy
                usesystemdefault="true"
                proxyaddress="http://user:password@mycompanyproxyaddress:80"
              />
            </defaultProxy>
          </system.net>
        </configuration>

         

        2:

        <?xml version="1.0" encoding="utf-8" ?>
        <configuration>
          <system.net>
            <defaultProxy useDefaultCredentials="true">
              <proxy usesystemdefault="true"/>
            </defaultProxy>
          </system.net>
        </configuration>

         

        Where could I go now.... ?