Query Warehouse from PHP app

[yulione]

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 lot of possibility, there is still complexe things that I would prefere to treat in a PHP app. especially for visual redenring. 

Is there any way to direct query the warehouse from a PHP app (using Doctrine as example) ? Can't find a proper ways in Microsoft guideline. 

Thank you for your help. 

[yulione]

Hi @Expiscornovus . 

Thank for the reply. 

PHP to SQL server is already done as one of my PHP app is working with it already. 

Already got the connection string as described and try to connect as for an SQL server. howeer for some reason it doesn't work.

I don't even have credential error. it is just returning no answer at all.... 

By the way, I'm on a Fabric Trial mode, if this can change anything. 

[Expiscornovus]

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]

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]

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]

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

[yulione · Accepted solution]

HI. 

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

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

[Expiscornovus]

Hi @yulione,

Haven't tried this myself, but I would suggest to look at the below pieces of documentation/information.

The options you have to connect to it:

https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

And this stackoverflow thread about using SQL server connections in PHP programming language:

https://stackoverflow.com/questions/74812451/how-do-i-connect-to-sql-server-with-php