Microsoft Entra Suite Tech Accelerator
Aug 14 2024, 07:00 AM - 09:30 AM (PDT)
Microsoft Tech Community

Scan Excel/PowerPoint Data sources

Copper Contributor

Hi,

 

Let's imagine that Excel uses a database or Power BI as a data source (i.e. for a Pivot Table), will Purview scan the Excel file and visualize the lineage so that you can track which Excel document is using which Power BI data set? I know it's possible with Power BI reports to find out which Dataset they are using, but it would be super helpful to find out what data sources the world's most popular BI front-end (Excel) is using ;)
Same with PowerPoint. So you can embed a Power BI report into a PowerPoint document. Will Purview scan the PowerPoint documents and find out which report/visual they use? For Impact Analysis (I would like to change a report, what other components will be affected) this would be very important...

 

Thanks,

 

 

Thomas

0 Replies