Forum Discussion

Nsr_1975's avatar
Nsr_1975
Regular Visitor
3 years ago

Power BI Connection to DataVerse giving Error

I m trying to connect to dataverse from PowerBI Desktop. Initially it got connected and was able to load the data , but in subsequent attempts it is showing the below error. No change in connection details or permissions after the initial attempt.
 

 

 
The data source is given without any https:// or / as suggested in the KB articles and also the PowerApps Environment settings the TDS Endpoint is enabled. But still i am getting this error.
Tried using older common data service connection and it is working without any issue. But as it does not support direct query, i can not use it.
Could someone help me to fix this ?


Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Nsr_1975 

     

    How about try the solution listed below? Reference: Power Query Dataverse connector - Power Query

    SQL Server connection issue due to closed ports

    When connecting with the Dataverse connector, you might encounter an Unable to connect error indicating that a network or instance-specific error occurred while establishing a connection to SQL Server. This error is likely caused by the TCP ports 1433 or 5558 being blocked during connection. To troubleshoot the blocked port error, go to Blocked ports.

     

    In addition, which subsequent attempts did you do? In DirectQuery mode, the transformation is limited. If some transformation steps break query folding, DirectQuery will be not supported. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

  • bhawnaA's avatar
    bhawnaA
    Frequent Visitor
    3 years ago

    I am facing the same issue , My TDS is aready enabled . Also in some posts i see they ask us to fix teh URL but when i connect to Dataverse (latest Pbi ) doesnt give me an option to enter an instance URL . ANy help is much appreciated 
    Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    ErrorCode=******************
    Number=*******
    Class=***