/
Pulling Organization Data using Power BI

Pulling Organization Data using Power BI

Owned by Sarah Jane Salvatierra
Last updated: Nov 12, 2024
3 min read

Background: Support agents sometimes receive requests from Org Admin to obtain data, such as a list of active users for their downstream channel partners. This can be done using Power BI.

The request can only come from users with org admin permissions. If the request is coming from sales reps, please refer them to their org admin.

 

Step

Action

Reference

Step

Action

Reference

1

  • Confirm that the request is from an Org Admin

If YES proceed to Step 2

If NO proceed to Step 3

 

2

  • The support agent needs to create a case and assign it to the Lead Specialist to process the request

Creating and Assigning Cases - Installer Knowledge Base

3

  • Advised the sales rep/requester to contact their org admin to place the request.

STOP

 

How to pull the organization’s data using Power BI?

Step

Action

Reference

Step

Action

Reference

1

  • The Lead Specialist needs to access Power BI

ONLY authorized leads and support agents to process this request:

@Eric Suarez
@Ruel.Balicas
@Nathan Dubbs
@Carl Mampay (Unlicensed)
@Daniel Pena

“In PowerBI, select Compliance > Platform User report > Platform User > then pick the needed "Channel Manager Org".
Power BI .

The action button is hiding behind the channel Manager Organization box

image-20241102-201202.png
image-20241102-200309.png

2

  • Export the Report

Finalize the view, and export the data using the more option field. Select Export Data > Data with current layout

 

 

 

 

 

3

  • Remove Filters: If any filters were applied during the export, they may show up at the bottom of the exported file. Delete any unnecessary filter information before sharing the file with others, as filters used internally are typically not relevant to the customer.

 

4

  • Send the file

Attached the file and send the response via email