Power BI Report From Azure CLI

[anilelmastasi]

Hello,

I have a script that we run in Azure CLI to export data. We want to automatically retrieve this data, create a data source in Power BI, and build a dynamic report. However, when using the Power BI connector, we cannot pull data from two different tenants into the same dataset in Azure.

I would like your support in evaluating possible options and selecting the best-practice approach.

[abhivic_fabric]

I’m not familiar with using Azure CLI for two different tenants, but your requirement can be addressed using Power Automate.

You can use the "Run query against a dataset" option in Power Automate and direct the output to your desired location, which can then be used as a source for the dynamic PBI report. This method supports multiple tenants simultaneously.

Feel free to reach out if you need further assistance.

[Anonymous]

Hi @anilelmastasi ,

You seem to want to connect to Azure Database in Power BI. You can refer to below offical blogs.

For reference:

Azure and Power BI - Power BI | Microsoft Learn

Learn how to connect to Azure Analysis Services with Power BI | Microsoft Learn

Use data from Azure Data Explorer in Power BI - Azure Data Explorer | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.