Forum Discussion
Sql database in Fabric
Thank you for the response.
I followed all the suggested steps:
- Confirmed DNS and network connectivity (nslookup, Test-NetConnection).
- Verified I have ODBC Driver 18 and pyodbc installed.
- Ran my Python script with ActiveDirectoryInteractive and also tried other auth methods.
- Checked my Azure tenant and found I have no valid subscription assigned or active.
It turns out my subscription status is causing the issue. I don’t have any active Azure subscription in my tenant.
Hi Mr Levy
I am a Power BI developer for a design company and look after their Power BI data in the Power BI Service.
I do not log in to their domain from my machine, but log in to app.powerbi.com from my browser and import data through the data gateway.
I have also installed the CLI Azure login tool and have logged in from the VS Code terminal.
Should this be sufficient to connect to a Fabric SQL Database? Are there any settings I need to make in the Fabric SQL Database? I have added myself explicitly as a db owner and also a reader. Not sure if that is necessary, but I thought I may as well do it anyway whilst trying to get it to connect.
I am pretty good at SQL coding, but not at the workings of Entra!
Many thanks for your help, Oliver