2
Have a native connector in Azure Data Factory for Business Central.

This could go through the published API's (standard or extensions).

As with other ideas to e.g., replicate to an Azure SQL DB, this would provide the flexibility for customers and partners to create full BI solutions with the flexibility to ETL as part of that process. It also allows end customers to choose the appropriate data sink for their requirements using the flexibility of ADF.
Whilst Power BI is an option the limits on data throughput as a database grows or multiple companies are in a tenant is significant.

We currently have NAV clients who are concerned about upgrading to BC SaaS because there is no "easy" way for them to get access to their data as they can with an on prem solution.
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team