Forum Discussion
MS Excel table within Power BI
Currently, the table and matrix visuals in Power BI are not nearly as powerful as MS excel but Power Bi is very good with large data. So why not allow a table visual within Power that can Mimic MS ex...
Wow thanks for such quick responses. I guess I forgot to mention in post earlier that Power BI has a defect. When you try to connect to the semantic model that connects to Oracle over a DirectQuery connection and you try the analyze using excel option, Excel is unable to properly pass the where clause to Oracle. Microsoft has acknowledged this as a defect but hasn't provided a fix.
Power BI Matrix and table are notoriously ill equipped for analysis when compared with MS Excel.
On a separate note, the inability to add custom columns in service (viewer role) is ununderstandable to me when it's happily allowed if we provide a desktop template with the same semantic model.