Forum Discussion
ame54
Advocate II
Advocate IIPower BI as operational reporting
Have a use-case currenlty in our company where we are trying Power BI as a tool for operational reporting, most of our reports currently are built on QlikView & Sense. We are in the process of migra...
ame54,
Please take a look at the following articles about limitations in DirectQuery mode and how to optimize data model in DirectQuery mode.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
Regards,
Lydia
Hi,
I was just wondering on your approach to this. Did you have a data model built against the ERP structures will all the transactions (versus a star schema approach for analytics)? Did you denormalize any of it? Or was it just live connect to the operational data and any joins were done in the reports?
Tina