Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PowerBi Desktop App missing databricks connector

The latest version of PowerBI Desktop installed through the Windows Store: Version: 2.121.903.0 64-bit (September 2023)

 

Does not include the Databricks connector in the UI.

After a start of the product it does download the extra connectors in C:\Users\BijAJ\Microsoft\Power BI Desktop Store App\CertifiedExtensions. Including the "Databricks.pqx" it's 177 Kb.

 

I have multiple users reporting this issue.

 

Image: No Databricks Connector, but it's part of the CertifiedExtensions?

 

 

Comparable/same question:

https://community.fabric.microsoft.com/t5/Desktop/Azure-Databricks-connection/td-p/3064067

 

6 Replies

  • The absence of the Databricks connector in Power BI Desktop, even though it's present in the CertifiedExtensions folder, can be due to various reasons. Here are a few steps you can take to troubleshoot and potentially resolve this issue:

    1. **Check for Updates**: First, make sure that Power BI Desktop is up to date. Sometimes, connector availability can be linked to specific versions of the application. Go to "Help" > "Check for updates" to ensure that you have the latest version installed.

    2. **Enable the Connector**: Ensure that the Databricks connector is enabled in your Power BI Desktop. Go to "File" > "Options and settings" > "Options" > "Security" and make sure "Always enable custom connectors" is checked. This option can be helpful for allowing custom connectors.

    3. **Remove and Reinstall the Connector**: You may try removing the Databricks connector from the "CertifiedExtensions" folder and then reinstall it. Close Power BI Desktop, delete the Databricks.pqx file, and then restart Power BI Desktop. This can sometimes trigger a reinstallation of the connector.

    4. **Reinstall Power BI Desktop**: If none of the above steps work, you may consider uninstalling and reinstalling Power BI Desktop. This can resolve any potential corruption in the installation.

    5. **Check with Power BI Community**: Visit the [Power BI Community](https://community.powerbi.com/) and see if others are experiencing a similar issue. Sometimes, issues related to connectors are reported by other users, and you can find solutions or workarounds there.

    6. **Contact Microsoft Support**: If the issue persists, consider reaching out to Microsoft Support. They can provide more specific guidance and assistance for your particular case.

    Connector availability and functionality can sometimes be affected by updates or issues specific to the application version you are using. Following the steps above should help you troubleshoot and potentially resolve this problem with the Databricks connector.

  • Anonymous what version are you using? I do see it

     

     

     

    My version: 

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Alef, thanks for your quick and extensive reply.

     

    I have to say that we do have a firewall blocking non-allowed domains. I'll try to allow all for my IP to see any difference.

     

    1. It's a fresh install, from the Windows Store, the version indicates the latest release.

    2. I've allowed all (not recommended)

    3. Thats what I do normally, remove the entire CertifiedExtensions, it's get re-downlaoded.

    4. I'm trying to validate the behaviour with normal version installed from website.

    5. looking through it...

    6. Will do, first I'll investigate furter.

     

    Is there a way to start with verbose logging, to see why the extensions are not loaded? I could not find anything in the logs when enableing the trace logging in the UI.

    • soldous's avatar
      soldous
      Advocate II

      Hello Anonymous have you solved the issue? We are facing it even today with the current version on our servers. 

       

      Thanks a lot

  • Anonymous's avatar
    Anonymous
    Not applicable

    Oke, news!

     

    The PowerBi Desktop installation (PBIDesktopSetup_x64_v2.121.903.0.exe) has the same issue as the Windows Store.

     

    But, when the firewall was fully open, both the normal app and Store version show the Azure Databricks connector!

    So it's a blocked request somehow.

     

    Currently we do allow:

    - appsource.powerbi.com,

    - content.prod.powerquery.microsoft.com,

    - go.microsoft.com

     

    But one/some of these might be required, can be candidates which are blocked:

    pbivisuals.powerbi.com

    app.vssps.visualstudio.com

    - clients.config.office.net

    api.powerbi.com

     

    After adding pbivisuals.powerbi.com api.powerbi.com to the allow-list the Azure Databricks appears after a fresh install. edit: I have to investigate further which domain needs to be added... tomorrow.

     

    parry2k are you able to Firewall block some domains to see if you can replicate the issue?

  • Anonymous I will check, but seems like you already know the fix. Interesting finding.