Power Pivot or BI

[Drexl88]

Hi

What is the best option for creating a live dashboard linked to several excel files (stored on same location) that hold the same data sets/fields just for different departments. The data is not in SQL.

Any advice would be greatly appreciated.

Thanks

 

[cyrilbrd]

Hi,
BI works well with Excel tables, you can easily set a model (layout) and create several visualizations in a dashboard.
Do you plan to share said dashboard?
BI requires a subscription for this.