Back to the Keys of Hope story Written by volunteers. Not an official YWCA page.
For Keys of Hope staff

The Keys of Hope report: step by step

Each Friday, you export four tables from EmpowerDB, click Refresh, and the report is up to date.

Everything is in one zip file

The report template (it holds no data), this guide as two pages you can print, and an empty exports folder.

Download the zip
One honest note

So far, the report has only run on made-up data. The first run on real records is the next step. When you do it, check every number against what your staff know.

First time only

About 10 minutes. You need a Windows computer, the zip file, and EmpowerDB.

  1. Unzip the folder.

    Take the folder out of the zip file and put it on the C: drive, so you end up with C:\KeysOfHope.

  2. Install Power BI Desktop.

    Get this free program from the Microsoft Store, if it is not already on your computer.

  3. Export four tables from EmpowerDB.

    Go to EmpowerDB Administration, then Table Export, and export Clients, Move Ins & Exits, Services and Groups to Excel.

  4. Save all four files.

    Put them in C:\KeysOfHope\exports. The file names do not matter.

  5. Open the starter file.

    In C:\KeysOfHope, double-click Keys of Hope.pbit. When it asks for ExportFolder, type C:\KeysOfHope\exports and click Load.

  6. Save your own copy.

    Click File, then Save as, name it Keys of Hope, and save it in C:\KeysOfHope.

This saved file is the one you open from now on.

Every Friday

About 5 minutes. You need EmpowerDB and the Keys of Hope file you saved the first time.

  1. Empty the exports folder.

    Delete last week's files from C:\KeysOfHope\exports, so nothing is counted twice.

  2. Export the same four tables.

    In EmpowerDB, export Clients, Move Ins & Exits, Services and Groups to Excel.

  3. Save the new files.

    Put all four in the exports folder.

  4. Open the report and refresh.

    Open your saved Keys of Hope file, then click Refresh on the Home tab.

  5. Check the date.

    Find Last updated beside the page title. It should show today's date.

Share it in your Power BI portal

Four steps, right after Friday's Refresh. This is the simple way. It has only been tried with made-up data so far.

Before the first time, ask one person two things

Ask whoever manages YWCA's Power BI which workspace to use, and who has a license to view reports. A workspace is a shared area where reports are kept. A license is the permission a person needs to view one.

  1. Publish the refreshed report.

    Click Publish on the Home tab.

  2. Sign in to Power BI.

    Use your YWCA account, then pick the workspace you were told to use.

  3. Choose Replace if asked.

    If it asks to replace the existing report, choose Replace.

  4. Send people the link.

    Open the report at powerbi.com, then use Share to send the link.

Later, with help (not yet tested). Our idea is to move the exports folder to SharePoint, so the report can update without you opening it. That needs a one-time change by someone who builds Power BI reports.

If something goes wrong

Find what you see on your screen, then do what the line says.

  • Last updated shows an old date. One of the four tables was not exported this week. If you cannot tell which, do the Friday steps again from step 1.
  • It says an export is missing. One of the four files is not in the exports folder. Add it and click Refresh again.
  • The numbers look doubled. Last week's files are still in the exports folder. Delete them and click Refresh.
  • Refresh shows a folder error. The exports folder was moved or renamed. Put it back where it was, named exports.
  • Services saves as two files. That happens when the table is large. Put both in the exports folder.
  • Unzipping to C: does not work. Unzip it anywhere. In First time step 5, type the full location of that exports folder.

If your screen does not match a step, the instructions are at fault, not you.