Forum Discussion
Embedding an Excel Spreadsheet in Power BI
I've seen a few posts on this but they're a few years old and I'm ambitiously hoping something may have changed.
I've been tasked with converting a mammoth Excel spreadsheet to work in Power BI using our semantic models and for all bar one of the tabs it works perfectly. However there is one sheet that just isn't going to work because it requires cross-calculation between two enormous semantic models and the sheet itself isn't laid out in an database friendly format (so new headings part way down the spreadsheet, a *lot* of cell-specific references etc).
Given it's just one sheet I think in the immediate I'd like to just embed this page into the report and manually update it until the semantic models are sorted out (we're a big company and this will take a while). Is there a tool that can do this? I've tried a few HTML visualiser plugins but the free ones don't seem to work and the good ones require a subscription. I literally just need to embed the sheet as-is (it's too big to screen grab).
Anyone know if this is possible?
Hi BUC
Embedding Excel worksheets directly into Power BI as interactive elements is not currently supported, but you can consider integrating Excel data into Power BI using several methods:
The most straightforward method is to import Excel workbooks into Power BI Desktop. but may not meet your needs in terms of layout.
Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn
If the main goal is to maintain the Excel interface while using Power BI's capabilities for other parts of your data, consider using Power BI tiles in Excel.
Some of these services may require a subscription, but they can provide the functionality you need.
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Another solution is to host the Excel file on OneDrive or SharePoint Online and use the Power BI "Web" Content Pack to display the Excel file in the Power BI dashboard.
This will not embed the worksheet directly, but will provide a quick access link in the report.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi BUC
Embedding Excel worksheets directly into Power BI as interactive elements is not currently supported, but you can consider integrating Excel data into Power BI using several methods:
The most straightforward method is to import Excel workbooks into Power BI Desktop. but may not meet your needs in terms of layout.
Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn
If the main goal is to maintain the Excel interface while using Power BI's capabilities for other parts of your data, consider using Power BI tiles in Excel.
Some of these services may require a subscription, but they can provide the functionality you need.
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Another solution is to host the Excel file on OneDrive or SharePoint Online and use the Power BI "Web" Content Pack to display the Excel file in the Power BI dashboard.
This will not embed the worksheet directly, but will provide a quick access link in the report.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.