Accessing Azure with Power BI

[JFM_12]

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

[#2]

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)

[#3]

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

[#4 · Accepted 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)

[#5]

Hello Leon

Thank you very much.

Have great day
Juan

[#6]

May refer to this as reference:

https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-and-power-bi

[#7]

Yes, it is possible to access Azure data through Power BI to create reports. Power BI provides several connectors and methods to integrate with various Azure services, allowing you to pull in data and create insightful reports. Here's a step-by-step guide on how to connect to different Azure data sources from Power BI:

1. Connect to Azure SQL Database
Open Power BI Desktop.
Click on "Get Data" from the Home ribbon.
Select "Azure" from the left pane and then choose "Azure SQL Database".
Click "Connect".
Enter the server and database details along with your authentication method (Windows or SQL Server authentication).
Click "OK" to connect and load data.
2. Connect to Azure Data Lake Storage
Open Power BI Desktop.
Click on "Get Data" from the Home ribbon.
Select "Azure" from the left pane and then choose "Azure Data Lake Storage".
Click "Connect".
Enter the URL of your Azure Data Lake Storage account.
Authenticate using your organizational account.
Select the file or folder you want to connect to and load data.
3. Connect to Azure Blob Storage
Open Power BI Desktop.
Click on "Get Data" from the Home ribbon.
Select "Azure" from the left pane and then choose "Azure Blob Storage".
Click "Connect".
Enter the URL of your Azure Blob Storage account.
Authenticate using your account.
Select the file or folder you want to connect to and load data.
4. Connect to Azure Analysis Services
Open Power BI Desktop.
Click on "Get Data" from the Home ribbon.
Select "Azure" from the left pane and then choose "Azure Analysis Services".
Click "Connect".
Enter the server name and authentication method.
Select the database and model you want to connect to.
Load the data into Power BI.
5. Connect to Azure Synapse Analytics (formerly SQL Data Warehouse)
Open Power BI Desktop.
Click on "Get Data" from the Home ribbon.
Select "Azure" from the left pane and then choose "Azure Synapse Analytics".
Click "Connect".
Enter the server and database details along with your authentication method.
Click "OK" to connect and load data.
6. Use Azure Data Factory with Power BI
You can also use Azure Data Factory to orchestrate data movement and preparation, and then connect Power BI to the data stored in your Azure data warehouse or lake.

In Azure Data Factory, create a pipeline to extract, transform, and load (ETL) your data into an Azure SQL Database, Azure Data Lake, or other suitable Azure storage.
Connect Power BI to the output data storage as described in the steps above.
Tips for Effective Reporting
Ensure Data Refresh: Set up data refresh in Power BI to keep your reports up-to-date. You can configure this in Power BI Service.
Optimize Queries: Use query folding where possible to push data transformations to the data source, reducing load times and improving performance.
Secure Data: Use Row-Level Security (RLS) in Power BI to ensure that users only see the data they are authorized to view.
By following these steps, you can effectively pull data from various Azure sources into Power BI and create comprehensive reports.