topic Help finding the correct location to save the .pq file in Developer

Help finding the correct location to save the .pq file

SarahHope — Tue, 10 Oct 2023 19:26:57 GMT

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

Re: Help finding the correct location to save the .pq file

lbendlin — Wed, 11 Oct 2023 22:06:34 GMT

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

Connector extensibility in Power BI - Power BI | Microsoft Learn

Re: Help finding the correct location to save the .pq file

SarahHope — Thu, 12 Oct 2023 12:13:09 GMT

Yes. I followed this instruction:

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!

Re: Help finding the correct location to save the .pq file

lbendlin — Thu, 12 Oct 2023 13:22:02 GMT

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.

Re: Help finding the correct location to save the .pq file

SarahHope — Thu, 12 Oct 2023 14:23:39 GMT

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.

Re: Help finding the correct location to save the .pq file

lbendlin — Thu, 12 Oct 2023 14:28:05 GMT

There is no need for guessing. It must go into

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

Re: Help finding the correct location to save the .pq file

SarahHope — Thu, 12 Oct 2023 14:53:15 GMT

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.

Re: Help finding the correct location to save the .pq file

lbendlin — Thu, 12 Oct 2023 15:24:39 GMT

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

Re: Help finding the correct location to save the .pq file

SarahHope — Mon, 16 Oct 2023 17:17:29 GMT

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