Can I connect my web page with dynamic data from reporting services like Power BI or data sources like Azure SQL?

Background
This topic answers a question submitted at one of our quarterly product update events - Open Studio. To view a list of all the questions submitted at our July 2024 edition, visit this topic.

Question
Can I connect my web page with dynamic data from reporting services like Power BI or data sources like Azure SQL?

Answer
Yes, there is a way you can use external databases, using Velo. The External Database Collections SPI describes the API requests your SPI needs to expect from your Wix site and the responses your Wix site expects in return. This enables you to build your endpoints that translate the requests and responses between your site and your external database.

As part of Open Studio, we want to give you a peek into exciting new features, share what we’re working on, and showcase recently released features that enhance your efficiency. We also take the questions you submit and answer them all here in the forum, like the one above. To view a list of all the other questions submitted for the July 2024 edition, along with their answers, visit this topic.