User cost attribution export feature

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.

To export a user cost attribution report as a CSV:

1. Navigate to Insights > Cost & efficiency.

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.

   

Setup 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 Insights > Costs & efficiency.

2. Select the User cost attribution tab.

3. At the top, beneath the Per-User Costbox, select Power BI.

4. When prompted, select Enable.

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

   

6. Download Power BI Desktop.

7. Install Power BI Desktop.

8. Download the setup PowerShell script.

9. 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 Insights > Costs & efficiency.

2. Select the User cost attribution tab.

3. At the top, beneath the Per-User Cost box, select Power BI.

4. When prompted, select Enable.

5. In Setup process type, select Manual.

   

6. Download Power BI Desktop.

7. Install Power BI Desktop.

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

9. Optionally, download the .PBIX template.

10. Download the Connector.

11. Copy the Connector from the download folder to Documents > Power 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 data > More...

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.