SOLVED

Accessing Azure with Power BI

Iron Contributor

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

5 Replies

Hi @JFM_12,

you can use Power BI to access Azure data through various methods.

Here are some possible approaches:

  1. Azure SQL Database Integration: Establish a direct connection to an Azure SQL Database, enabling the creation of insightful reports for business monitoring.
    Azure and Power BI - Power BI | Microsoft Learn

  2. Data Transformation with Power BI Desktop:
    use Power BI Desktop to seamlessly connect to Azure SQL Database, Azure HDInsight, Azure Blob Storage, or Azure Table Storage within the same query for data transformation and merging.
    Azure and Power BI - Power BI | Microsoft Learn

  3. Azure Data Explorer Connectivity:
    use Azure Data Explorer as a data source in Power BI by either initiating the connection in the Azure Data Explorer web UI and then transferring the data to Power BI Desktop, or starting directly in Power BI Desktop and adding the Azure Data Explorer connector.
    Use data from Azure Data Explorer in Power BI - Azure Data Explorer | Microsoft Learn

  4. Azure Blob Storage Access:
    retrieve data from Azure Blob Storage using Power BI for comprehensive data analysis.
    How to access data from Azure Blob Storage using Power BI (sqlshack.com)

  5. Azure Analysis Services Integration:
    establish a connection between Power BI and Azure Analysis Services.
    Learn how to connect to Azure Analysis Services with Power BI | Microsoft Learn

Yu can select the appropriate connectivity mode based on your specific requirements. Import mode copies data to Power BI, while DirectQuery mode allows querying data directly from your Azure Data Explorer cluster.


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)

Hello Leon
Thank you very much for your answer.
I would like to get the UPN and Company from Azure.
The data should not be older than a week. Means 

Direct Query is great but not necessary.
Regards

JFM_12

 

best response confirmed by JFM_12 (Iron Contributor)
Solution

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)

Hello Leon

Thank you very much.

Have great day
Juan

1 best response

Accepted Solutions
best response confirmed by JFM_12 (Iron Contributor)
Solution

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)

View solution in original post