Power bi not finding custom connector. PQ in Excel has far fewer connectors.
Power bi not finding custom connector. And that is what I will discuss in this article. This guide can be used to help troubleshoot common issues. Mar 12, 2025 · Hi, We have a Power BI Custom Connector and we would like to create a custom connector the Online verion of Power BI. mez, Oct 31, 2018 · Summary Custom and Certified connectors for Power BI are now generally available! We encourage the community to use them and experiment with them, and we would love for vendors to reach out to us about certifying their connector. Once I installed a third-party connector it created a folder without the 'Microsoft' word: [Documents]\Power BI Desktop\Custom Connectors. Feb 17, 2023 · The method for implementing TestConnection functionality is likely to change while the Power BI Custom Data Connector functionality is in preview. Simplify reporting and make data-driven decisions with ease. Apr 2, 2025 · Hi, I'm trying to follow the instructions from Kasperonbi (Building the Power BI Strava data connector - Kasper On BI) to connect to Strava. In Power Automate, PQ only connects to SQL Server for now, whereas PQ online in DataFlows has many more connections, but still not nearly as many as Power BI Desktop. Oct 16, 2022 · My Custom connectors folder is under C:\\Users\\USER\\Documents\\Power BI Desktop\\Custom Connectors and I'd prefer it at another location. I tried to set thte Data Extensions to the second option, but it's not coming up. The problem Power BI is a suite of business analytics tools to analyze data and share insights. These connectors are often referred to as custom connectors or Power Query extensions. 1261. Its a mystery. Note The Excel column in the following table indicates all connectors that are available on at least one version of Excel. Oct 12, 2022 · However when I tried to access it via Power BI Desktop, I couldn'rt find the connector. Sep 25, 2025 · Learn about connector extensibility features, security settings, signing, and certification so you can safely use custom data connectors in Power BI. Basic Authentication does work on a Custom Connector, but Basic is not an option for my project. Disclaimer I have developed a simple data connector which make Jul 28, 2021 · Just installed Power Bi and was looking to add a data connector in the documents folder and for whatever reason there is no power bi desktop folder in documents. Sep 15, 2017 · In celebration of the start of the Power BI World Tour, and thanks to the new Power BI custom connectors, I was able to create my own custom connector, get the data from the PUGs that I found on meetup. mez) to your Custom Connectors directory. In my case I was using time and list data types which works fine in Power BI Desktop but not in Power BI Service. Mar 14, 2019 · Has anyone foud a way to permanently disable the options for Data Extensions in Power BI Desktop? We don't want users to be able to select the "Not Recommended" setting but can't find a group policy or registry key we can use to disable that, similar to how we can disable the check for updates, the Feb 13, 2023 · Use custom data connectors with an on-premises data gateway [!INCLUDE gateway-rewrite] You use Power BI data connectors to connect to and access data from an application, service, or data source. pbx file is for this connector or any other native connector, I have found the certified connectors/extensions folder (C:\Users\PC1\Microsoft\Power BI Desktop Store App\CertifiedExtensions) but the native are not there. I go to get data and I cannot find it. Windows: When you choose to use Windows authentication, Power BI Desktop connects to Virtual DataPort using Kerberos authentication. Any idea where I can find them? Feb 4, 2021 · Solved: Hi All, I have a custom connector file (. Feb 21, 2021 · A new Power BI Custom Connector for the Power BI REST API. You must deploy your solution and test is in the Power BI Desktop and Power BI Service. This article contains frequently asked questions about developing Power Query custom connectors that are collected in one spot. I narrowed the problem down to the "TestConnection" part of the connector code, but I cannot figure o Feb 13, 2023 · Use custom data connectors with an on-premises data gateway [!INCLUDE gateway-rewrite] You use Power BI data connectors to connect to and access data from an application, service, or data source. The process includes verifying connector installation and confirming the gateway's online accessibility. Is this a chance or there are limitations for Custom Data Connector ? Dec 2, 2019 · Have you developed your own custom data connector and you think the work is done? Well, it is not. Oct 21, 2025 · Power BI Desktop: Pull data via the SafetyCulture connector Learn how to connect your organization's data to Power BI Desktop. Oct 18, 2022 · The Power BI On-Premises Gateway now supports loading custom connectors. Jul 22, 2025 · Query Folding is not enabled for custom connector with source as API 07-22-2025 02:18 AM I am following the query folding apparoch and having below version of TableView. This article includes procedures for a tool that is outside of SafetyCulture. Jul 22, 2025 · From what I understand, the . 0, which allowed Sharperlight to integrate with Microsoft’s popular BI tool. And you also need to build the project to produce an extension file, then copy the extension file into the [Documents]\Power BI Desktop\Custom Connectors directory. I have also prepared the necessary documentation and set up a testing environment to meet the certification requirements. pqx file Learn how to use the 'create from blank' option to create a custom connector for Power Automate and Power Apps. Nov 27, 2024 · I have successfully developed a custom connector app for Power BI, which currently functions as intended in Power BI Desktop. This post attempts to (unofficially) document the basics of these formats. Notably, searching on it here after refreshing still didn’t find it, but when I scrolled down the list it was right there: May 21, 2024 · To use your extension in Power BI Desktop, you'll need to copy your connector project's output file (TripPin. 126. 1 Download the connector file (either a *. Learn how to call Power BI REST APIs with Custom Connector and Postman. As a general rule, when the security for loading custom connectors is set to 'Recommended', the custom connectors won't load at all, and you have to lower it to make them load. Aug 16, 2021 · The various version of Power Query are not all the same. This guide will walk you through downloading, installing, and setting up the connector. Apr 10, 2024 · Power BI Custom Connectors: Unlock the full potential of your data with our easy guide on activating and using custom connectors effectively. But when I try to find the connector in the Get Data window, I don’t see it as a selectable option. APIs allow Power BI to go beyond basic reports, provide real-time data updates, automate data refresh, and connect with custom or third-party data sources. This involves using Power Query M Language to define data sources and transformation processes. Adjust the data extension security settings in Power BI Desktop. All I did is copied my connectors into that new folder and now it works well. But I cannot find where the . If you do not have either of these, please get in touch with your Enterprise Account Manager, or contact su Sep 7, 2020 · The PowerBI Custom Connector was released in Sharperlight 5. I was wondering whether there is an alternate way to deploy custom connectors? Dec 9, 2021 · Hi community, I have developed a custom connector which I tested in PowerBI Desktop. What variable is Aug 6, 2023 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Information on the certification process can be found here, and you can nominate your connector for certification here. Create a [My Documents]\Power BI Desktop\Custom Connectors directory. Type(schemaPreview) in Jan 20, 2025 · Hello! I'm new to creating connectors, and I'm asking for your help! Previously, I wrote a request to share the experience of connecting to SendPulse, and now I ask to share the experience (pitfalls) of creating a connector. I've changed the security settings to allow custom connectors, but nothing works. To me, looks like a bug as in according to documentation connectors must be placed in the [Documents]\Power BI Desktop\Custom Connectors folder. Just check the box for “Custom data connectors. PBI. '. Sep 8, 2021 · I have 2 other custom connectors, varying in complexity and using Web or Folder/File options and both are the same. mez file and put it in the following "Custom Connectors" folders on my computer: C:\Users\OneDrive - jason Company\Documents\Power BI Desktop\Custom Connectors C:\Users\jason\Documents\Power BI Desktop\Custom Connectors The first one is a OneDrive for my company. Basically there are datatypes that are allowed as parameters in power bi desktop that aren't allowed in Power BI service. After a while I found out the the Power BI Desktop was now looking under OneDrive\Documents instead. As is the trend in the Microsoft world, typically an archive file is used, with the connector’s components stored as individual files inside the archive Sep 11, 2025 · The Denodo Power BI custom connector supports two authentication types: Windows and Basic. Dec 17, 2019 · I was following the install steps, but I cannot locate the Custom Connectors folder. Now, however much I try to complete these steps, it always fails to show my custom connector in the list. I mean yeah it´s custom, but is there any way to remove this? Mar 12, 2024 · Solved: Hello all! I am hoping that someone has a solution or guidance. What exactly is needed to configure a custom connector in Power BI? Apr 1, 2025 · Hey guys, I want to remove the "(custom)" keyword from my Power BI custom connector. But I just cannot find any documentation anywhere how to do this. Reftab offers an integration with Microsoft Power BI. I had my custom connectors in the folder [Documents]\Microsoft Power BI Desktop\Custom Connectorsand PBI desktop saw them without problem. Apr 9, 2025 · Hello, I have a custom connector which uses OAuth2 with my Django web app. The documentation for using OAuth in custom connectors for Power BI leaves a Jun 10, 2025 · If you don’t find a connector for your data source in the “Get Data” menu, your best chance for automatically extracting data is by building Power BI API connectors. Dec 10, 2024 · This guide is for customers who have been provided with the Power BI Nexar Connector, and are set up with the Octopart Partner Portal. mez file is not working in Power BI Desktop because the old project was not fully updated to match the new Power Query SDK in Visual Studio Code. Even if the M code looks correct, the . Just download the file and start using it! Is that easy! Jul 27, 2017 · One of the recent features in Power BI Desktop is the ability to create your own custom connector and use it when connecting to the data source. mez file must be built using the new SDK’s structured project setup to work properly. Jan 16, 2025 · Hi @ArvindBhatt - Power BI does not automatically refresh access tokens for custom connectors. Both Then, select “Allow any extension to load without validation or warning. I think my issue is that I can't find the "/Docu Aug 6, 2023 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Hi, I am a Power BI Dashboarding addict and I want to learn how to create custom connectors from the bottom up. I made sure to allow unverified connectors in the settings. Mez file for custom connector and it will work with power bi desktop but it will not work for power bi services as authentication method will not work as on prem gateway will not able recognise the connector. May 17, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. This connector is available in the following products and regions: Creating custom connections in Power BI enables you to access data sources not covered by built-in connectors. Oct 3, 2019 · Most of this solutions tell me that I should put my mez file in Custom Connectors folder in the following path - Documents -> Power BI Desktop -> Custom Connectors. It works correctly with Power BI desktop and in the Visual Studio Code Power Query SDK. Power BI has the most connectors, including custom connector capability. I've tried installing the exe file as admin. TIA. Mar 27, 2024 · After installing PowerBI Desktop, I always set "Security" -> "Data Extensions" to "Not recommended - allow any extension". Fit to window view Deploy Power BI connector Configure Power BI connector Perhaps you can try to remove these connectors from the installed folder and remove the corresponding data connector configuration Jul 24, 2025 · I compiled the code to a . Oct 7, 2019 · Just need some help! I have followed all the steps but some how Power Bi desktop doesnt show the custom connector. Connector. It works fine perfectly in Power BI desktop. Read more about custom connectors! Feb 13, 2025 · I had the following problem after I installed Power BI Desktop app on new system: I created the Documents\Power BI Desktop\Custom Connectors directory and dropped the . mez file in Documents\\Power BI Desktop\\Custom Connectors, without any l Jul 17, 2019 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. mez file under Documents\\Power BI Desktop\\Custom Connectors I have updated the security setting in the PowerBI desktop options and have restarted the PowerBI. If not, create this folder. Power Query online isn't even the same across products. We've developed a custom connector that you'll need to download and configure. Here we explain how to create certified and non-certified custom connectors in Power BI with examples. You could refer to Dec 13, 2021 · I already had the "Allow user's custom data connectors" setting checked, and I also tried with the other 2 settings checked, but unfortunately it's still not showing in the dropdown. Create a folder named "Power BI Desktop" in the Documents folder. Common use cases include: Creating a business analyst-friendly view for a Nov 13, 2024 · Discover how custom connectors in Power BI enhance access, security, and usability for complex data sources. Open Windows Explorer and go to the Documents folder. 3. Is there any other way to enable my Custom connector. Liongard is in the process of getting our Power BI data connector signed and certified by Microsoft. The exception to this is trusted, 'signed connectors'. Could someone point me in the right direction. You Feb 13, 2024 · If you went looking to create a custom connector and had trouble finding the button, you’re not alone. Here is my desktop version Anyo Jun 26, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Third-party tools can change without notice, so steps or screenshots may differ. ” Note: In some versions of Power BI, you might find this feature under File > Options and Settings. Get tailored authentication, smoother transformations, and connect to sources not natively supported—maximizing your Power BI integration. Users will now be able to use the Power BI Custom Connector, to utilise Sharperlight’s advanced query capabilities as a data […] Aug 28, 2024 · Hi, we developed a custom connector for Power BI. See steps below. You must handle token refreshing manually within your custom connector. Oct 7, 2022 · Hello! I have a custom connector that can't get past the data source credentials on PowerBI Web version in order for me to schedule a data refresh, even though it works fine on the Desktop version. To support scheduled refresh through the on-premises data gateway, your connector must implement a TestConnection handler. mez file into the Custom Connectors folder. Background: We have many people who use this custom connector without any problem at all. So far everyting works fine. GetTableView = (tableName as text) as table => let schemaPreview = GetTableData(tableName, [PageNumber = 1, PageSize = 100]), schemaType = Value. I have set up an On-Premises Data Gateway to use it in the Power BI service, but I cannot get it to work. How do I access the Power BI connector in Power BI, or how do I make the CData connector appear in this window? Jan 8, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Everything seems fine, except for finding my Custom Connector when selecting "Get Data" in Power BI Desktop. Thanks! Jun 13, 2024 · Power BI offers a variety of data connectors, which can generally be grouped into three main categories: native connectors, third-party connectors, and custom connectors. What variable is PowerBI looking for to enumerate the My Docs folder so it can find this? Nov 18, 2019 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Guide to Power BI Custom Connector. Apr 19, 2023 · Hello! I'm new to creating connectors, and I'm asking for your help! Previously, I wrote a request to share the experience of connecting to SendPulse, and now I ask to share the experience (pitfalls) of creating a connector. However, not all Excel versions support all of these indicated Power Query connectors. Mar 18, 2020 · Hi! We are trying to use a custom connector with Power BI Desktop and normally, putting the file in this path works: My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Aug 4, 2025 · Azure Logic Apps, Microsoft Power Automate, Microsoft Power Apps, and Microsoft Copilot Studio offer over 1,000 connectors to connect to Microsoft and verified services, but you might want to communicate with services that aren't available as prebuilt connectors. Nov 14, 2020 · I've tried: \Documents\Microsoft Power BI Desktop\Custom Connectors \Documents\Power BI Desktop\Custom Connectors I've saved there different . Hello World![…] Jun 27, 2023 · I managed to figure out why my connector was working. I’ve just finished installing a Power BI connector from CData. Trouble starts when I try to configure a refresh using a standard gateway as described Aug 14, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. If you’re still having trouble finding it, make sure you’re looking for the “back end” schema name, not the display name. How to set up a mez file for the below code with Apr 2, 2019 · Hi! We are trying to use a custom connector with Power BI Desktop and normally, putting the file in this path works: My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn' Learn how to use the Power BI custom connector to transfer your procurement data and analyze all company indicators in one place. However the connector never appears on Power BI Desktop. Feb 17, 2024 · When you refresh the connector panel in Power BI Desktop, the table should show up. Oct 28, 2021 · Issues connecting power bi and clockify connector 10-28-2021 01:08 PM Hi all, I initially connected the clockify connector with an api, but now it's giving me this error message when I go to refresh the data. May 21, 2024 · Seek Help from Documentation and Support: Review the official documentation for the Salesforce connector in Power BI for any specific setup details you might have missed. Once I Oct 1, 2025 · The Power Query SDK is a set of tools designed to help you create Power Query connectors. com, create a really simple data model, and then create the report included in this post. Using a standard Power BI Connector like SQL Server, the Authentication options are all working perfectly and as expected. Do you happen to know if the location is different for Windows 10 Power BI Desktop App? Aug 1, 2025 · Configuring the Data Gateway for Power BI requires placing all custom connectors in the designated folder. What variable is PowerBI looking for to enumerate the My Docs folder so it can find this? May 19, 2023 · We are developing a custom connector to read a JSON file from a local location and send it to Power BI. I successfully added it to my power bi desktop file and published to service. Please see the technical documentation for more information, and the TripPin Sample for an example of how to add gateway support to your connector. May 29, 2020 · Hi @astoz , Did you mean that you can't view your custom connector icon in powerbi , right? If so, please check whether you Allow any extension to load without warning or validation in Option-Security in desktop. Oct 7, 2024 · The process for installing a custom connector and adjusting security to enable use of the connector is described in detail in the Power BI documentation. Copy the CMiC. Nov 14, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Get started. Connect to get easy access to the data in your Power BI dashboards, reports and datasets. Step 2: Install the Data Connector 1. Create a folder named "Custom Connectors" in the Power BI Desktop folder. However, I cannot find clear and detailed instructio Would you like to bring your Simplesat feedback data directly into Power BI for analysis? With the Simplesat Power BI connector, you can seamlessly import customer satisfaction data to visualize trends, generate reports, and create impactful dashboards. . How can I best learn this, where do I start, what skills are required and where can I find some blogs about getting started from scratch? Feb 18, 2022 · Power Query custom data connectors, including certified connectors, can consists of multiple components which are distributed using one of three file formats. pqx file). But connector did not show up. This is done by placing the . My suggest Aug 25, 2025 · Not sure which Power BI connector to use? Here, I’ll break down all connector types and show you how to use them in the most effective way. What exactly is needed to configure a custom connector in Power BI? Aug 4, 2017 · It seems to work with Custom Data Connector HelloWolrd (just published it on Power BI Service and used successfully this DataSet on a Dashboard). It is necessary to configure the Power BI Desktop app to allow unsigned custom connectors. This feature looks just one feature, but it opens doors to many possibilities. For a complete list of the Power Query connectors supported by all versions of Excel, go to Power Query data sources in Excel versions. Nov 3, 2021 · Hello there, We are having some odd issues with a custom connector not showing up in the "Get Data" menu. With this feature you can write your own custom connector to any types of data Read more about Power BI Custom Connector: Connect to Any Data Sources. In this case: Kerberos authentication must be enabled in the Virtual DataPort server. We tried putting it in the redirected location as well as the local path. Apr 3, 2019 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. I've tried adding a Power BI Desktop\Custom Connector\ and putting the pqx file there. But, it doesn't work so in Power BI service. For the sake of simplicity, here's a quick explanation: Check to see if your computer already has a [Documents]\Power BI Desktop\Custom Connectors folder. mez or *. Jan 21, 2021 · Hi @Anonymous, According to the following blogs, I found power bi custom connectors seem installed on 'C:\<user_dir_on_powerbi_desktop_machine>\Documents\Power BI Desktop\Custom Connectors. What variable is PowerBI looking for to enumerate the My Docs folder so it can find this? Jan 8, 2020 · My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn't work. Custom connectors address this scenario by allowing you to create (and even share) a connector with its own triggers and actions. Nov 28, 2021 · This article will present lessons learned while creating a new Power Apps custom connector with Azure AD authentication. You’d probably expect the option to be in the “connectors” menu option in the Power Apps maker portal, but no! The connectors page will only let you create a connection from an existing connector. Does anyone have an idea on why this is? Mar 27, 2024 · I had the following problem after I installed Power BI Desktop app on new system: I created the Documents\Power BI Desktop\Custom Connectors directory and dropped the . I'm using Version: 2. MEZ file in the path Documents/Power BI Desktop/Custom Connectors and i Mar 14, 2023 · See how you can use custom data connectors with an on-premises data gateway in Power BI. Below I have added the code for the pq file, the same code runs as a blank query in Power BI. Custom connectors let you create new data sources or customize and extend an existing source. 0 64-bit (February 2024). Once I Dec 13, 2021 · This program will allow owners of data sources to deliver connectors seamlessly via Get Data in Power BI, making it easy for you to take advantage of the capabilities of Power BI and the breadth of our audience. Visit the Power BI Community forums or Salesforce Community forums to see if others have encountered and solved similar issues. In the Power BI service, when May 16, 2023 · I hope that you have got the . It’s time to make space for your most essential Power BI reports. You can develop custom data connectors and use them in Power BI Desktop. I also managed to publish to the PowerBI Service and schedule a refresh using a personal gateway. Apr 2, 2019 · Hi! We are trying to use a custom connector with Power BI Desktop and normally, putting the file in this path works: My Documents -> Microsoft Power BI Desktop -> Custom Connectors But we are finding that on a machine with OneDrive installed and redirecting My Documents to the cloud, it doesn' Jan 8, 2020 · I am working on the custom connector and for some reason the PowerBI desktop is not able to recognise the . Jan 30, 2020 · But, I am currently Using September 2019 version of Power BI Desktop hence those Preview Features are Missing . Click OK and restart the Power BI Desktop app. This means that any Sharperlight published report can be used as a dataset in Power BI. Saved the . May 21, 2019 · After that PBI Desktop takes a custom connectors from this folder and ignores my connectors. Dec 21, 2022 · In Power BI, the loading of custom connectors is limited by your choice of security setting. Is there any way to change that location or is that path actually hardcoded? (in this forum post it seems so) Could I just remove the folder and set it up again m Sep 6, 2022 · Custom Connectors Path I've found out what the issue was by myself. mez connector file there. PQ in Excel has far fewer connectors. But we are facing an issue with creating a MEZ file. bbmodgofsqurtclw3lh8vl0vnsrcxibr4xjravmuv2xw0yga