In Power BI Desktop, click on File > Options and settings. Go to Data source settings > Global Permissions. Select the listed SharePoint, and click on Clear Permissions.

Now your Excel workbook is ready to be linked to Power BI. If you do not prepare your workbook in this way Power BI will just ignore it, so this process can’t be avoided. The Power BI how-to series ...

Learn how to export Microsoft Power BI data to Excel using this step-by-step guide with examples. ... but you don’t have the original .xlsx file, you can create one using Power BI Desktop.