Forum Discussion

JFM_12's avatar
JFM_12
Iron Contributor
Jan 04, 2024
Solved

Accessing Azure with Power BI

Hello Is it possible to access the Azure Data through Power BI. I need data from Azure to make a report. How can this be done. Regards JFM_12
Azure
Data + Storage
power bi
  • LeonPavesic's avatar
    LeonPavesic
    Jan 04, 2024

    Hi JFM_12,

    thanks for the update.

    To retrieve the User Principal Name (UPN) and Company Name from Azure, you can leverage Azure AD PowerShell commands. Here is an example:

     

     

    Get-AzureADUser -All $true | Select-Object -Property UserPrincipalName, CompanyName

     

    This PowerShell command fetches the UPN and Company Name for all users within Azure AD.

    Subsequently, you can import this data into Power BI for your reporting needs.

    As for the Direct Query, it’s not necessary but can be beneficial if you want real-time data in your reports.


    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic
    (LinkedIn)

Resources