MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Render Excel Data on an iPad Dashboard Using Power BI

November 12, 2020 - by Bill Jelen

Excel Render Excel Data on an iPad Dashboard Using Power BI. Photo Credit: Saffu at

Power BI provides a new way of creating interactive modern dashboards using data from Excel.

To get started, sign up for a free account at

Then download the free app called Power BI Desktop.

In Power BI Desktop, start with the Get Data button.

Click the Get Data button in Power BI Desktop to start.

The experience will be exactly like with Power Query, as discussed in Excel 2020: Clean Data with Power Query.

Once you have your data loaded into Power Query, choose a visualization from the top right and drag fields to the various drop zones.

After you design several dashboard tiles, you can publish your dashboard. Anyone that you invite will be able to view the dashboard in a browser or on an iPhone, iPad, or Android device.

Title Photo: Saffu at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.