Forum Discussion
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
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, CompanyNameThis 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)
Hi JFM_12,
you can use Power BI to access Azure data through various methods.
Here are some possible approaches:
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 LearnData 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 LearnAzure 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 LearnAzure 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)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. MeansDirect Query is great but not necessary.
RegardsJFM_12
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, CompanyNameThis 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
