Power BI Dashboard

Hello everyone,

I have a scenario where I would like to bring metrics from many different reports in different workspaces into one workspace with a dashboard. I have created the workspace and the dashboard but when I go to add I tile there is not an option to add it from a report. So, I decided to go to one of the reports in another workspace and try to use the 'pin' icon to pin the visual to the dashboard. However, the dashboard I created is not showing up under the "Existing dashboard" section of the prompt. I suspect I may have to have the report in the same workspace as the dashboard but I would like to avoid that if possible because I have a lot of reports spread across multiple workspaces.

All insight welcome! Thanks!