https://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/?utm_source=book&utm_medium=short-code&utm_campaign=scpbi-book I think this may be unnecessary now that you can add Analyze in Excel to external tools. See https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/