Forum Discussion
Using Python + StreamLit to connect to a Fabric SQL database/lakehouse
Hi v-sdhruv , yes thanks for your help, have now connected to Fabric via Streamlit.
Community SupportHi chapperscobbler ,
In order to connect to SQL database in fabric using Python/streamlit you can follow this latest article which describes in detail how to connect to a SQL database.
Connect to a SQL database in Fabric with the Microsoft Python Driver for SQL Server - Microsoft Fabric | Microsoft Learn
One of the reasons why you are facing authentication issue could be due to improper configuration of
- Azure AD App Registration (for authentication)
- Python environment with required packages
Ensure your app registration has API permissions for Microsoft Fabric and SQL.
For authentication using Python, make sure to install proper packages and then authenticate.
Also, refer - Build a Streamlit application with Fabric SQL Database - Azure SQL Devs’ Corner
If you would like to share the error details and your code it would be great since it will help to point out the issue better.
Hope this helps!
v-sdhruv wrote:Hi chapperscobbler ,
In order to connect to SQL database in fabric using Python/streamlit you can follow this latest article which describes in detail how to connect to a SQL database.
Connect to a SQL database in Fabric with the Microsoft Python Driver for SQL Server - Microsoft Fabric | Microsoft Learn
One of the reasons why you are facing authentication issue could be due to improper configuration of- Azure AD App Registration (for authentication)
- Python environment with required packages
Ensure your app registration has API permissions for Microsoft Fabric and SQL.
For authentication using Python, make sure to install proper packages and then authenticate.
Also, refer - Build a Streamlit application with Fabric SQL Database - Azure SQL Devs’ Corner-Slope Game If you would like to share the error details and your code it would be great since it will help to point out the issue better.
Hope this helps!Okay, let's untangle this authentication knot! Is your Azure AD App Registration feeling lost? Perhaps Python's missing a crucial piece of its puzzle? Hmm, API permissions, a common culprit indeed. Remember that time my smart fridge wouldn't connect to the Wi-Fi? Turns out, I hadn't granted it network access.
