SOLVED

PWA report to Power BI on risks - can I import the date the risk / issue was created?

%3CLINGO-SUB%20id%3D%22lingo-sub-1846608%22%20slang%3D%22en-US%22%3EPWA%20report%20to%20Power%20BI%20on%20risks%20-%20can%20I%20import%20the%20date%20the%20risk%20%2F%20issue%20was%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1846608%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20-%20relatively%20new%20to%20PowerBI%20and%20have%20managed%20to%20get%20risks%20and%20issues%20into%20my%20report%2C%20with%20mitigation%20and%20assigned%20resource%20etc%2C%20based%20on%20the%20download%20content%20pack%2C%20but%20want%20to%20bring%20in%20the%20date%20field%20for%20when%20the%20risk%20%2F%20issue%20was%20created%20so%20I%20can%20see%20in%20my%20reporting%20how%20long%20a%20risk%20or%20issue%20has%20been%20active.%26nbsp%3B%20This%20should%20help%20us%20escalate%20%22blocked%22%20issues.%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1852448%22%20slang%3D%22en-US%22%3ERe%3A%20PWA%20report%20to%20Power%20BI%20on%20risks%20-%20can%20I%20import%20the%20date%20the%20risk%20%2F%20issue%20was%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3Bthank%20you!!!%20I%20really%20appreciate%20this%20and%20it%20will%20also%20solve%20some%20other%20queries%20I%20had.%3C%2FP%3E%3CP%3EFantastic%20to%20have%20your%20help%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all - relatively new to PowerBI and have managed to get risks and issues into my report, with mitigation and assigned resource etc, based on the download content pack, but want to bring in the date field for when the risk / issue was created so I can see in my reporting how long a risk or issue has been active.  This should help us escalate "blocked" issues.

Thanks in advance

3 Replies
best response confirmed by IslaB (New Contributor)
Solution

Hello @IslaB ,

Using the default Project Online Power BI Report pack, open this in Power BI desktop and click "Transform data" on the Home ribbon tab. That will open up Power Query, click "Risks" from the left hand side then double click "Removed Other Columns" from the Applied Steps in the right hand side. This will open a new window where you will see all of the columns for Risks, in that window add the other columns that you want to use.

Paul

@Paul Mather thank you!!! I really appreciate this and it will also solve some other queries I had.

Fantastic to have your help,