Forum Discussion
Complex ETL/preprocessing pipeline
I have several data coming from Dynamics 365 Business Central. Most of those data I can process/visualize directly using Power BI and dax, but a unfortunately remains a part that requires a complex ...
Another possibile way is to use Azure Data Factory to copy Business Central data using OData connector to csv then execute an Azure Functions to do my stuff, save it back to csv and connect it to Power BI dataflows. It could works but I will lose the Power BI integration and there may be synchronization issues between Power BI and Azure Data Factory.