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 ...
warehouse
  • yulione's avatar
    yulione
    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.... : 

     

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.... :