Forum Discussion

SarahHope's avatar
SarahHope
Icon for Helper II rankHelper II
2 years ago

Help finding the correct location to save the .pq file

Hello,

 

According to my documentation and to articles found in this forum.  I need to save my .pq file to 
C:\[user]\Documents\Power BI Desktop\Custom Connections.

I have no Power BI Desktop folder there.   I created one and then a subfolder called Custom Connections, but Power BI does not see my custom connection. 


Where do I find the correct location for this .pq file?

 

Thank you.

Sarah

Need Help

8 Replies

    • SarahHope's avatar
      SarahHope
      Icon for Helper II rankHelper II
      2 years ago

      For anyone else who may bump into this, the proper path for my instance is:  C:\Users\[my-directory]\OneDrive - OurOrg\Documents\Power BI Desktop\Custom Connectors

  • SarahHope's avatar
    SarahHope
    Icon for Helper II rankHelper II
    2 years ago

    Yes.  I followed this instruction:

    1. Put the connector .pq, .pqx, .m, or .mez file in your local [Documents]\Power BI Desktop\Custom Connectors folder. If the folder doesn't exist, create it.

    The Power BI Desktop folder wasnt' there either.  I created the directory listed above and put the custom connector in the directory.  it still wasn't recognized.

    I have changed the setting to allow custom connections without verifying.

    It would be very helfpul to get this working.  Thanks!

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Maybe start small, with a known good configuration.  Put the attached .mez into the Custom Connectors folder (remove the .zip part, it is only used to trick the forum software as it doesn't allow .mez files). Start a new Power BI Desktop instance. Click on Get Data...More and then search for Power BI API (beta)

       

       

      If you can see that and use it then the mechanics work an the issue is with your .pq file.

       

       

       

      • SarahHope's avatar
        SarahHope
        Icon for Helper II rankHelper II
        2 years ago

        Thank you for this troubleshooting step. I also can't find the Power BI API (beta) from within the desktop app.  So I think the location is not right.  

        I have also tried: C:\Users\Default\Documents\Power BI Desktop\Custom Connectors
        I tried the place where I save my reports - a network drive
        Lastly, I tried here: 

        C:\Users\[my userid]\AppData\Local\Microsoft\Power BI Desktop\Custom Connectors

        After each time I moved the .mez or .pq, I restarted the desktop application. 
        I'm at a loss as to where this file should be placed.