Power Automate Desktop | User intefaces (UIs) exercise | Open Power BI Desktop and connect to an Excel worksheet

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Power Automate Desktop  (18 exercises)
Version ==> Latest version
Topic ==> User intefaces (UIs)  (2 exercises)
Level ==> Harder than average
Subject ==> Power Automate training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

The aim of this exercise is to get to this state:

Loading Excel table

Your flow should open Power BI, clear the splash screen which appears, choose to connect to the Excel workbook in the above folder and load the list of films.  The answer doesn't then expand the Top films table to show the fields in it (as shown in the diagram above), but you could do this as an optional extra!

Listed below are the ways that Wise Owl managed to get this to work, but our solutions aren't necessarily the best ones, and you'll get much more out of this exercise if you try working out how to solve all the problems yourself without reading on.

Here are the steps Wise Owl took to solve this problem, using a new flow called Open Power BI and connect, with notes of where we got stuck.  There are almost certainly better ways to create this flow:

Step Solution
Open Power BI We couldn't find the executable for Power BI, so instead ran it by clicking on one of our Windows task bar icons (cheating a bit!).
Clear the splash screen This was hard!  The splash screen seems to run in the background, so we ended up creating an image showing the cross in the top right corner, then selecting this (with a left click following).
Choose to load an Excel workbook This was easy: just create a UI element for the ribbon tool, and click on it.
Choose the file This was relatively easy: create a UI element for the file name box, go to it and use a Send keys action to type in the file name and to then press Enter.
Choose which table to load Search as we might, we couldn't find a short-cut key to accomplish this (and even had we done so, we couldn't find a way to send keystrokes to the right window).  We ended up using two images: one for the check box next to the table name, and one for the Load button.  Not a good solution!

If you get this all working and still have spare time and energy, you could always try creating a Power BI visual (probably best to stick to a table) showing each film title with its number of reviews.  Still have time?  You could try formatting this!

When you're happy with the state of your flow (and you've checked it works OK) save it and close it down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only. Our Power Automate exercises answers are provided as text files - you can see how to assemble these back into PAD flows here.
This page has 0 threads Add post