Fastest way to export a list of datasets in service?

[pborah]

We have 100+ datasets in our P1 instance in Premium. This is beginning to impact scheduled refreshes as many of our reports/dashboards are near realtime. Many of those datasets overlap. I'm looking for a quick way to export a spreadsheet list of those datasets so I can create report for the director and highlight which ones are suitable for merging. Thank you.

[pborah · Accepted solution]

So apparently this can be done using Powershell, more specifically the PowerBI cmdlets.