MS Excel table within Power BI

[Anjan_Madhwesh]

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 excel. For e.g. user can setup auto filter on columns and search what they want (instead of the separate filters visuals that is quite annoying to use). Another thing that the users would like to do is vlookup feature.

[lbendlin]

There are plenty of custom visuals that will happily take your money to provide that functionality.  What's the business value though?

[sergej_og]

You can connect to your semantic model via Excel and work as usual with Excel pivot table.
Have you tried it yet?

Regards