Dashboard subscription: Is there a way to get useful values instead of pictures?

[Anonymous]

Hi,

I'm looking for a way to be able to gather chosen metrics from different reports across different workspaces on a regular basis (let it be daily), to be able to create Executive dashboard with those numbers presented in a slightly different form.
What I came up with is:

1. creating dashboards gathering those metrics (not available in app),
2. subscribing to those dashboards to receive e-mails with snapshots of those metrics daily,
3. storing PNG files from attachments in a SharePoint folder,
4. Power Automate flow is sending those PNG files with metrics values to online OCR API which reads the actual values and add the values and a date to a new row in excel file

So I'm wondering if there is no easier way getting those values directly in usable form instead of a picture, for the process not to be such pain in the ass.

I was reading about how to reach to the values using Power BI REST API, but I have no time to learn how to use this.

Any help?  

[v-jayw-msft]

Hi @Anonymous ,

Please check the document below about  using dataset across workspaces and see if it helps.

https://docs.microsoft.com/en-us/power-bi/service-datasets-across-workspaces.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous]

Hi @v-jayw-msft ,

unfortunately in my case that will not help. The Report is showing current situation for present day, every night whole dataset changes to show updated situation, and there is no point keeping previous versions of whole dataset just to have its state at some point in time. I just need to store few measures value for each day to be able to track their performance over time.