Forum Discussion
Display or Embed Excel Sheet in Power BI
Hi HersonD
Yes, you can pin an Excel sheet or a specific range of cells to a Power BI dashboard, but it comes with some limitations:
-
It updates dynamically: Every time there’s a change in the Excel file, the pinned tile in the Power BI dashboard updates as well. However, it acts only as a static image on the dashboard, which can be clicked to open the Excel file, but it does not support interactive functionality within Power BI.
-
File storage: The Excel file must be stored either on OneDrive for Business or SharePoint. It cannot be stored locally or on other external storage platforms.
-
Pinning applies only to dashboards: The pinning feature is only available for dashboards in the Power BI Service, not for embedding directly within a report. So, this functionality won’t work inside a Power BI report—only in the dashboard view.
This is how it can work :
1. save the Excel in one drive.
2. from Power BI service go to the wanted workspace anf upload the Excel:3. open the Excel from power bi, select the wanted range, and pin it to a dashboard:
Result (on dashboard)
If I update the Excel after refreshing of the dashboard it will update the tile
more information about pinning Excel is here :
https://www.youtube.com/watch?v=E11dduMbsbs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Hi HersonD
Yes, you can pin an Excel sheet or a specific range of cells to a Power BI dashboard, but it comes with some limitations:
-
It updates dynamically: Every time there’s a change in the Excel file, the pinned tile in the Power BI dashboard updates as well. However, it acts only as a static image on the dashboard, which can be clicked to open the Excel file, but it does not support interactive functionality within Power BI.
-
File storage: The Excel file must be stored either on OneDrive for Business or SharePoint. It cannot be stored locally or on other external storage platforms.
-
Pinning applies only to dashboards: The pinning feature is only available for dashboards in the Power BI Service, not for embedding directly within a report. So, this functionality won’t work inside a Power BI report—only in the dashboard view.
This is how it can work :
1. save the Excel in one drive.
2. from Power BI service go to the wanted workspace anf upload the Excel:
3. open the Excel from power bi, select the wanted range, and pin it to a dashboard:
Result (on dashboard)
If I update the Excel after refreshing of the dashboard it will update the tile
more information about pinning Excel is here :
https://www.youtube.com/watch?v=E11dduMbsbs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 ,
Thanks for your help.
However, I was planning it to use it in a report. I did not know that dashboard and reports have different functionality until today.