>>Yes, you can use Power BI to show tabular lists of data as well. I wouldn't say that's the strongest feature of PBI, but yes, you can show lists and it also has basic matrix support.
>
>I am assuming it is possible to click on a field and obtain detailed information about the related data.
Yes, Power-BI has all sorts of native abilities for you to set up pages with cross-filtering and drilldown capabilities.
So imagine a page with a list of customers on the left and their aggregate sales dollars. And then another list (or chart) on the right with weekly sales for a customer.
As you click on customers on the left, the chart on the right can auto-refresh for the customer you selected on the left.