
We implemented Dynamics 365 on the cloud for Sales, Marketing, Customer Care, Resources, Event Management, Business Central, Microsoft Portal for our website and we also have a Learning Management system with a SQL DB (all on the cloud) and we are planning to set up a DataBase for data warehousing on the cloud and to optimize reporting for internal and external customers using SSRS and Power BI. What would be your recommendation and do you know any company or expert who could work with us? Thanks
Kiko,
Look at Synapse Link into a Synapse database (which is CSV data in a storage blob). This is replacing Data Export Service. If you need it in relational format, you'll have to use ADF or Synapse Pipeline to move the data into a RDBMS.
docs.microsoft.com/.../azure-synapse-link-synapse
Jon