Azure reports in PowerBi

[Lats]

Hello,

We use Azure in multiple regions (3) and in each region we have multiple subscriptions (8).

We have recently started backing up some of the VM's in these regions/subsriptions and would like to have all displayed in one Power BI report. No issues creating individual reports, but having so many backups would mean so many different reports.

How do we merge or have PowerBi to show all reports in one screen? 

[v-juanli-msft]

Hi @Lats

Would you like to connect reports in the Azure VM with Power BI Service?

How do you create this reports, do you host a SQL Server database in your VM or anything else?

I find some links, could you check whether they meet your scenario?

how to connect to SQL Server database in Azure VM step by step

https://github.com/Microsoft/AzureUsageAndBillingPortal

Best Regards

Maggie

[henriquesilveir]

@Lats hello,  hope that the better choice for you is use Dynamic RLS integrated with AD using security groups.

take a look in this article and it will help you how to do step by step to create a Dynamic RLS integrated with AD.

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

please let me know if it help you! 

Best Regards from Brazil!