Azure SQL Database
An Azure relational database service.
5,285 questions
How to export the dimensions and measures from D365 F&O to datalake
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Athira Reghuraman
60
Reputation points
Hi ,
I have a requirement to export all the cubes containing dimensions and measures within the D365 F&O to datalake and move to synapses and use it in power BI . Please let me know how can I make it work .
Thank you
{count} votes
-
Oury Ba-MSFT 17,061 Reputation points Microsoft Employee2023-06-18T04:18:45.95+00:00 Athira Reghuraman Thank you for reaching out.Without the Dynamic environment, it will be difficult to tell whether the above scenario is possible or not in Azure environment.
Let us check internally and get back shortly.
Regards,
Oury
-
Oury Ba-MSFT 17,061 Reputation points Microsoft Employee
2023-06-21T23:11:37.5166667+00:00 Thank you for being patient while checking on this issue.
I was able to check this internally and we don't really have a good way to achieve this using ADF.
Dynamic 365 F&O is not a supported connector in ADF.
Regards,
Oury
Sign in to comment