Help finding the correct location to save the .pq file

[SarahHope]

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

[lbendlin]

Do you have access to a Power BI gateway?  There it is easier to check if the custom connectors are recognized

Might also be worth going through the documentation again GitHub - microsoft/DataConnectors: Data Connector SDK and samples for Power Query and Power BI

[SarahHope]

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]

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]

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. 

[lbendlin]

There is no need for guessing. It must go into 

C:\Users\[your user id]\Documents\Power BI Desktop\Custom Connectors

[SarahHope]

I wish it were recognized when I put it there.  Neither the Power BI API (beta) (mez) nor the TeamDynamix (.pq) are recognized when those files are in the specified location.  

[lbendlin]

Slightly wrong folder name. Not "Custom Connections"  but "Custom Connectors"

Connector extensibility in Power BI - Power BI | Microsoft Learn

[SarahHope]

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