Is there any way to connect OTM db to Power BI?
Summary:
Hello team,
I was exploring the capability of integrating the OTM database with Power BI for visualization, is there any way to do it without any middleware or in between system?
The goal is to get the orders/shipments/events data on report for better visualization, I tried BI publisher but it seems little old and works slow due to so much data. Currently, we have to extract it manually every week and then append it to the BI report that we have, it will be great if this can be automated.
Thanks!
Aditya
Content (please ensure you mask any confidential information):