Forum Discussion

EdouardLC's avatar
EdouardLC
Frequent Visitor
1 year ago
Solved

Error configuring Azure Databricks datasource using an On-Prem Data Gateway

Hello, We are currently configuring a Datasource to connect Power BI to an Azure Databricks SQL Warehouse throught a Power BI Data Gateway installed on a Azure VM.   The gateway is well installed...
  • EdouardLC's avatar
    1 year ago

    Answer from Microsoft :

    Cause \ Resolution

     

    This error is because you are not able to access a CRL (certificate revocation list ) URL. The customer will need to find out why they are not able to access the CRL URL. This URL was added to the new driver as a security feature update. Most likely, the customer will need to include it in their allow list.
    This behavior will not be reverted in future releases of the GW, hence the justification for the GW versions behavior and the solution moving forwards is what is mentioned in the statement above.

    The CRL URL you need to allow is  http://*.digicert.com/*

     

    This change will be permanent, that means all the Gateway versions will have this setting set to False:
    <setting name="MashupFlightUseOldSparkDriver" serializeAs="String">

                 <value>False</value>

    </setting>

     

    If you don’t to allow that CRL URL, the workaround is to change that setting to True, on the C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file