The report template (it holds no data), this guide as two pages you can print, and an empty exports folder.
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.
- 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. - Install Power BI Desktop.
Get this free program from the Microsoft Store, if it is not already on your computer.
- Export four tables from EmpowerDB.
Go to
EmpowerDB Administration, thenTable Export, and exportClients,Move Ins & Exits,ServicesandGroupsto Excel. - Save all four files.
Put them in
C:\KeysOfHope\exports. The file names do not matter. - Open the starter file.
In
C:\KeysOfHope, double-clickKeys of Hope.pbit. When it asks forExportFolder, typeC:\KeysOfHope\exportsand clickLoad. - Save your own copy.
Click
File, thenSave as, name itKeys of Hope, and save it inC:\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.
- Empty the exports folder.
Delete last week's files from
C:\KeysOfHope\exports, so nothing is counted twice. - Export the same four tables.
In EmpowerDB, export
Clients,Move Ins & Exits,ServicesandGroupsto Excel. - Save the new files.
Put all four in the
exportsfolder. - Open the report and refresh.
Open your saved
Keys of Hopefile, then clickRefreshon theHometab. - Check the date.
Find
Last updatedbeside 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.
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.
- Publish the refreshed report.
Click
Publishon theHometab. - Sign in to Power BI.
Use your YWCA account, then pick the workspace you were told to use.
- Choose Replace if asked.
If it asks to replace the existing report, choose
Replace. - Send people the link.
Open the report at
powerbi.com, then useShareto 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 updatedshows 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
exportsfolder. Add it and clickRefreshagain. - The numbers look doubled. Last week's files are still in the
exportsfolder. Delete them and clickRefresh. Refreshshows a folder error. Theexportsfolder was moved or renamed. Put it back where it was, namedexports.Servicessaves as two files. That happens when the table is large. Put both in theexportsfolder.- Unzipping to C: does not work. Unzip it anywhere. In First time step 5, type the full location of that
exportsfolder.
If your screen does not match a step, the instructions are at fault, not you.