Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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?
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.
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.