Forum Discussion
PowerBI <> Synapse Serverless <> Azure Function app (Python)
Hi everyone, I am having issues while developing an Azure Function app (Python) that creates a fully automated flow that does the following, WITHOUT ANY MANUAL INTERACTION ... Create a Synapse Se...
Hi GrowthModel,
Thankyou for the update.
Based on my understanding, Power BI Service automatically converts Azure Synapse Serverless and Azure SQL Database connections to a generic “SQL” connection type when a dataset is published. Power BI stores these connections internally as type "Sql" even if the Azure Synapse or Azure SQL connector was selected in Power BI Desktop. Because of this behaviour, a gateway is automatically associated with the dataset even though Synapse is a cloud source. Credentials cannot be programmatically applied using REST APIs after deployment, which results in the “Failed to test connection” error.
Please consider the following approaches, which may help to resolve the issue:
1. Set the credentials manually once in Power BI Service for that data source. Power BI will reuse these credentials across future deployments in the same workspace.
2. Consider using Microsoft Fabric Dataflows Gen2 or Fabric Lakehouse SQL Endpoints, which natively retain credentials and support automated refresh without manual intervention.
3. Fully automating credential setup for Synapse Serverless datasets through REST APIs is not currently supported. Power BI will continue to display the connection as "Sql" and will require credentials to be provided through the user interface.
To further investigate your specific tenant configuration, please raise a Microsoft Support ticket using the following link:Microsoft Fabric Support and Status | Microsoft Fabric
Additionally, if you need native support for automated credential configuration for Synapse Serverless connections, please raise a request in the Power BI Ideas Forum using the following link:Fabric Ideas - Microsoft Fabric Community
Additionally, if you need native support for automated credential configuration for Synapse Serverless connections, please raise a request in the Power BI Ideas Forum using the following link:Fabric Ideas - Microsoft Fabric Community
We hope the information provided helps resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.