Forum Discussion
Advocate IExport data from Power BI Premium Capacity Metrics App via PowerShell or APIs?
Hi,
Is there a way to get 'Power BI Premium Capacity Metrics' into a SQL Server Database using APIs or PowerShell? Or can we obtain equivalent metrics using a different method? This is needed as the app only keeps a week of data and we want to do historical trend analysis.
Thanks!
Hi sb991986 ,
There is currently no clear way to export for Power BI Premium Capacity Metrics by using PowerShell or APIs, maybe you could refer to below link to have a try:
https://github.com/Microsoft/PowerBI-JavaScript/wiki/Export-Data
But also notice the Limitations and considerations.
Regards,
Lucien
3 Replies
- GilbertQ
Super User
Hi sb991986
As far as I know this is not currently possible.
You could vote for the idea on https://ideas.powerbi.com
- v-luwang-msft
Community Support
Hi sb991986 ,
There is currently no clear way to export for Power BI Premium Capacity Metrics by using PowerShell or APIs, maybe you could refer to below link to have a try:
https://github.com/Microsoft/PowerBI-JavaScript/wiki/Export-Data
But also notice the Limitations and considerations.
Regards,
Lucien
I use Powershell connected to dataset power bi
https://www.powershell.no/power/bi,/powershell/2020/02/29/power-bi-powershell.html
