Forum Discussion
Power BI Report From Azure CLI
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.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
