Share via

How to transform D365F&O data before connecting to power BI from synapses

Athira Reghuraman 60 Reputation points
2023-06-16T09:03:29.9733333+00:00

Hi ,

I have created view in Azure synapses using CDMUtilSolution for data's exported from D365 F&O . Please help me understand how can I transform these data's and model this data in a better and cost effective way before loading and transforming data in power BI to increase the dashboard performance . Please suggest a way to model and transform the data within azure in a less cost

Thank you

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,743 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,457 questions