Forum Discussion
SQL Server connector uncertified
I created anew blank report. Clicked on the SQLServer icon to get data from a MS Sql server and get this message. What is going on? Has my Power Bi Desktop been corrupted? Tried two computers
Thankyou, Royel, for your response.
Hi Torben01,We appreciate your inquiry through the Microsoft Fabric Community Forum.
In addition to the information provided by Royel, please follow the steps below to use an uncertified custom connector:
- Place the connector file with the extension .pq, .pqx, .m or .mez in the local folder: [Documents]\Microsoft Power BI Desktop\Custom Connectors. If this folder does not exist, create it.
- To modify the data extension security settings in Power BI Desktop, go to File > Options and settings > Options > Security.
- Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning.
- Select OK, and then restart Power BI Desktop.
The default Power BI Desktop data extension security setting is (Recommended) Only allow Microsoft certified and other trusted third-party extensions to load. With this setting, if there are uncertified custom connectors on your system, the “Uncertified Connectors” dialog box appears at Power BI Desktop startup, listing the connectors that cannot be securely loaded.
To dismiss the message if you do not need to use the connectors in the current session, select OK in the pop-up dialog box.
To prevent the message from appearing in future sessions, either change your Data Extensions security setting or remove the uncertified connectors from the Custom Connectors folder.For further information, please refer to the following documentation:
Connector extensibility in Power BI - Power BI | Microsoft LearnWe hope that the information provided will help resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
5 Replies
Hi Torben01 check out this article
https://www.sqlbi.com/blog/marco/2019/05/25/uncertified-connectors-message-in-power-bi-desktop/
the problem was solved by removing any CDSA.mez or CDSA.pqx file present on my disk. You should look at these paths:
- %LocalAppData%\Microsoft\Power BI Desktop\CertifiedExtensions
- %userprofile%\Documents\Power BI Desktop\Custom Connectors
Just in case, you could run from a command window and execute this.
DIR /s C:\CDSA.mez DIR /s C:\CDSA.pqxFind this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Thankyou, Royel, for your response.
Hi Torben01,We appreciate your inquiry through the Microsoft Fabric Community Forum.
In addition to the information provided by Royel, please follow the steps below to use an uncertified custom connector:
- Place the connector file with the extension .pq, .pqx, .m or .mez in the local folder: [Documents]\Microsoft Power BI Desktop\Custom Connectors. If this folder does not exist, create it.
- To modify the data extension security settings in Power BI Desktop, go to File > Options and settings > Options > Security.
- Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning.
- Select OK, and then restart Power BI Desktop.
The default Power BI Desktop data extension security setting is (Recommended) Only allow Microsoft certified and other trusted third-party extensions to load. With this setting, if there are uncertified custom connectors on your system, the “Uncertified Connectors” dialog box appears at Power BI Desktop startup, listing the connectors that cannot be securely loaded.
To dismiss the message if you do not need to use the connectors in the current session, select OK in the pop-up dialog box.
To prevent the message from appearing in future sessions, either change your Data Extensions security setting or remove the uncertified connectors from the Custom Connectors folder.For further information, please refer to the following documentation:
Connector extensibility in Power BI - Power BI | Microsoft LearnWe hope that the information provided will help resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
Hi Torben01,
We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you.Hi Torben01,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.Hi Torben01,
We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.
Thank you.
