Shared Data Source Limitation for Azure Synapse Serverless in Power BI Service

Hi Simple_tuition1 

Yes, this is a known limitation in Power BI Service. When connecting to Azure Synapse Serverless SQL in Power BI Desktop, you're allowed to leave the database field blank. However, in Power BI Service, when creating a shared data source, the database field becomes mandatory. This causes a mismatch, and as a result, your semantic model cannot use the shared data source because the metadata does not match. A simple workaround is to manually specify the database name in Power BI Desktop before publishing the report. This way, the connection string matches exactly with the shared data source created in the Power BI Service. Once both use the same server and database name, the semantic model should be able to connect without issues.