Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Automation - BUG] Power BI Dashboard is showing First Row values instead of Relative Values in page 'DLP Action Decomposition Tree Analysis' #269

Open
KoteshMCGit opened this issue May 23, 2023 · 1 comment
Assignees
Labels
bug Something isn't working powercat-automation-kit

Comments

@KoteshMCGit
Copy link
Contributor

KoteshMCGit commented May 23, 2023

Describe the issue

Recently it is observed that Power BI Dashboard is showing First Row values from table "Desktop Flow Actions" instead of relative values for selected desktop flow on page "DLP Action Decomposition Tree Analysis". It is happening in drill down from Environment to Desktop Flow to Desktop Flow Action Module. But it is showing proper values from Action module to Action to occurrences.

We need to show Frist row values in relative values from both tables "Desktop Flow DLP Impact Profiles" and "Desktop Flow Actions". Like how many occurrences found for each desktop flow and Desktop flow Actions. similarly, each Action should show how many occurrences found for each Desktop flow Action. It is like drill down values from Environment to Desktop flow to DesktopFlow Action Module to Action to Occurrences count.

Screenshot of issue, showing First row values from "Desktop Flow Actions"
image

Screenshot of tool tip values, which are not used in respective desktop flow.
image

Expected Behavior

The drill down values should show relative data set from both tables "Desktop Flow DLP Impact Profiles" and "Desktop Flow Actions" instead of first row values on page 'DLP Action Decomposition Tree Analysis' for drill down from Environment to Occurrences count.

What component are you experiencing the issue with?

Automation Project

What solution version are you using?

April 2023

What app or flow are you having the issue with?

Power BI Dashboard

Steps To Reproduce

  1. Open power Automate Desktop flow Application and choose any one of Automation Kit Satellite environment.
  2. Create one PAD flow with one Action "Display message box"
  3. Ensure to sync newly created this desktop flow to Main environment.
  4. Open Power BI dashboard and configure with Main environment.
  5. Ensure to load all the data on dashboard.
  6. Navigate to page "'DLP Action Decomposition Tree Analysis'"
  7. Select True for "Only Actions Configurable in DLP Policies" dropdown
  8. You can find tool tip for "Occurrences" like "Activate cells in Excel work sheet\n Active Directory", which are not used in our Desktop flow

Anything else?

No response

AB#480

@KoteshMCGit KoteshMCGit added the bug Something isn't working label May 23, 2023
@KoteshMCGit KoteshMCGit self-assigned this May 23, 2023
@Grant-Archibald-MS Grant-Archibald-MS moved this to Testing 🤞 in Automation Kit May 25, 2023
@KoteshMCGit
Copy link
Contributor Author

Development is completed and validation is in progress.

KoteshMCGit added a commit that referenced this issue Jun 13, 2023
Issue fix for #269.Power BI Dashboard is showing First Row values instead of Relative Values in page 'DLP Action Decomposition Tree Analysis.
@Grant-Archibald-MS Grant-Archibald-MS moved this from Testing 🤞 to Done ✅ in Automation Kit Jun 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working powercat-automation-kit
Projects
Status: Done ✅
Development

No branches or pull requests

3 participants