Power BI Usage Metrics Report

Hi all,

I am trying to create a Power BI Usage Metrics Report to be sent via email. I know I can do a subscription but I want it in a different format. Thanks for your help. I am learning about Power Automate.

Below are screenshots of my power automate:

1. My query against the dataset.

2. Created my html table

3. My send email.


  1. here is the output i am gettting.

@ysherriff Works fine for me:

Thanks @AntrikshSharma. I need tonsee why this is not working for me. Could it be a network security issue from my company?

What is your recommendation fir further testing?

@ysherriff Maybe the DAX query isn’t returning any result.

1 Like

Hello @ysherriff

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you