SQL Server Database Connection String for Power BI (Business Central SaaS Project)

Hi alpesh_chauhan, 
Thank you for reaching out to the Microsoft Fabric Community Forum.

Microsoft Dynamics 365 Business Central SaaS does not expose the SQL Server layer, so SQL connection strings cannot be generated or used. This is expected behaviour and aligns with Microsoft’s cloud security architecture. The supported and recommended approach is to integrate Microsoft Power BI using Business Central APIs or OData web services, authenticated via Microsoft Entra ID. Power BI reports can be developed in Power BI Desktop using the Dynamics 365 Business Central connector or the OData Feed and then published to Power BI Service. Since both services operate in the cloud, the dataset refresh works through cloud-to-cloud connectivity, and an on-premises data gateway is not required.

For better long-term stability and performance, Microsoft recommends using API pages or API queries instead of standard page-based OData services. This approach provides a more secure, scalable, and supported method for building Power BI reports on top of Business Central SaaS environments.

Please refer to the following documentation for more details:
Enabling Power BI integration with Business Central - Business Central | Microsoft Learn

I hope this helps. If you have any further questions, please feel free to reach out.
Thank you for participating in the Microsoft Fabric Community Forum.