User Cost Attribution Export Feature

User Cost Attribution Export Feature

This feature is only available in the Nerdio Manager Premium edition.

Nerdio Manager allows you to export User Cost Attribution reports. The export can be a CSV file , Power BI, or debug details for technical support.

Note: Before you can export to Power BI, you must configure the Power BI Connector. See Set Up and Configure the Power BI Connector below for details.

To export a user cost attribution report as a CSV:

  1. Navigate to DashboardUser cost attribution.

  2. Run the report as desired. See User Cost Attribution Analytics for details.

  3. At the bottom of the screen, from the Select export action menu, select the desired download.

Set Up and Configure the Power BI Connector

Before Nerdio Manager can export a User Cost Attribution report to Power BI, you must set up and configure the Power BI Connector.

The setup can be done using a Nerdio-provided script (automatic) or done manually.

To set up the Power BI Connector using the automatic setup process:

  1. In Nerdio Manager, navigate to DashboardUser cost attribution.

  2. At the top, beneath the cost summary, select Power BI.

  3. When prompted, select Enable.

  4. In Setup process type, select Automatic (using PowerShell script).

  5. Download Power BI Desktop.

  6. Install Power BI Desktop.

  7. Download the setup PowerShell script.

    Note:

     

  8. Run the PowerShell script.

    ./Nerdio_User_Cost_Attribution.ps1

    Note: If the script does not run successfully, expand Troubleshoot: The script does not run to see troubleshooting steps.

    • If you get the "Nerdio_User_Cost_Attribution.ps1 cannot be loaded because running scripts is disabled on this system" error, run the following command to allow unsigned scripts:

      Set-ExecutionPolicy RemoteSigned

    • If you want to disable unsigned scripts once again, run the following command after the installation process:

      Set-ExecutionPolicy Default

To set up the Power BI Connector using the manual setup process:

  1. In Nerdio Manager, navigate to DashboardUser cost attribution.

  2. At the top, beneath the cost summary, select Power BI.

  3. When prompted, select Enable.

  4. In Setup process type, select Manual.

  5. Download Power BI Desktop.

  6. Install Power BI Desktop.

  7. Add the certificate thumbprint to the registry. See this Microsoft article for more details.

  8. Optionally, download the .PBIX template.

  9. Download the Connector.

  10. Copy the Connector from the download folder to DocumentsPower Bi Desktop > Connectors.

To Configure the Power BI Connector:

  1. Start Power BI Desktop.

  2. Optionally, open the downloaded .PBIX template.

  3. Navigate to Get dataMore...

  4. Search for NerdioReporting and select Connect.

  5. Copy the following information from Nerdio Manager:

    • Configuration Name

    • Base URL

    • Power BI Access Key

  6. Once you have entered all the desired information, select OK.

  7. In the Navigator window, select the AVD and MAU rows.

  8. Once you have made the selections, select Load.

    The Power BI Connector is configured and ready to use.

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request

Comments (0 comments)

Please sign in to leave a comment.