Microsoft Fabric Updates Blog

Pin a range from Excel to your dashboard!

Excel has always been an honorable member in Power BI, as one of the popular ways to bring data into Power BI.

We are excited to announce that now you can use your existing Excel workbooks, with the features and formatting you have learned to use and love over the years, and create dashboard tiles from within an embedded Excel workbook in Power BI.

You can select ANY range from a workbook that you uploaded to Power BI, and pin it as a tile to a dashboard:

 

Figure 1 Excel workbook viewed inside Power BI, with range B14:H39 selected containing a chart inside.

Click the “Pin” button on the top right of the menu bar to pin the selection to the dashboard

You can select ranges containing charts, tables, Pivot tables, Pivot charts, and many other Excel parts and pin them to your dashboard, to create beautiful dashboards like this:

 

Figure 2 Dashboard with Excel tiles

 

The tiles are connected to the workbooks in OneDrive for Business, and are being refreshed automatically every few minutes.

Furthermore, dashboards containing Excel tiles, as well as Excel workbooks themselves, can be added to organizational content packs for easy sharing with your colleagues.

Go ahead and give it a try! Create dashboards using your Excel workbooks with your favorite look & feel!

Gerelateerde blogberichten

Pin a range from Excel to your dashboard!

juni 16, 2024 door bagweb

Testing Cascading Messaging portal changes

november 20, 2023 door Anshul Sharma

As part of the One logical copy effort, we’re excited to announce that you can now enable availability of KQL Database in Delta Lake format. Delta Lake  is the unified data lake table format chosen to achieve seamless data access across all compute engines in Microsoft Fabric. The data streamed into KQL Database is stored … Continue reading “Announcing Delta Lake support in Real-Time Analytics KQL Database”