Forum Discussion

yulione's avatar
yulione
Frequent Visitor
2 years ago
Solved

Query Warehouse from PHP app

Hi Everyone.    I'm trying to explore the potential of Fabric. Manage to get gen2 dataflow populating a data warehouse, with pipeline etc, and use the results in Power BI.  If this is providing a ...
Expiscornovus's avatar
Expiscornovus
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hi yulione,

 

Are you using a Entra Id user for authentication or a Entra Id service principal?

 

Have tried accessing the same warehouse via SSMS, does that work?

yulione's avatar
yulione
Frequent Visitor
2 years ago

Hi Expiscornovus 

 

Connection through SSMS is not working. Following the method described here : https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

and got an error 53 : Path to network not found (sorry translated from french ^^ )

 

But I do copy my SQL connection string has said in the method. As it doesn't seems to find the server, I was wondering if the trial mode was not in cause.... 

 

Thx

  • yulione's avatar
    yulione
    Frequent Visitor
    2 years ago

    Hi, Just adding few test results : 

    Connexion through Power BI cloud version is working

    Connexion through SSMS and Power BI desktop version are not.... got the same error on both

     

    • Expiscornovus's avatar
      Expiscornovus
      Icon for Most Valuable Professional rankMost Valuable Professional
      2 years ago

      Is TCP port 1433 open? And are you using the Microsoft Entra MFA authenticaton option in the authentication of SSMS?

      • yulione's avatar
        yulione
        Frequent Visitor
        2 years ago

        HI. 

         

        I'm using indeed the Microsoft Entra MFA et I have a valid Entra ID. 

        It seems indeed Port 1433 is not open.... :