topic Re: Exporting Powerbi data gateway from Powershell in Report Server

Exporting Powerbi data gateway from Powershell

Anonymous — Mon, 28 Sep 2020 12:02:30 GMT

Hello All,

My query would be simple to most of you.

I being a rookie, need help on exporting of PowerBI datagateway details as shown in image DGPBI.jpg

I have referred this article, I get 2 worksheets created, but they only display Datagateway clusters:- ID, Name, Description, type, permission but not the list of fields as given in GUI like: contact info, users, status, version etc...

Please let me know how can I fetch that. Any help would be appreciable.

Thank you in advance

Re: Exporting Powerbi data gateway from Powershell

Anonymous — Mon, 28 Sep 2020 13:50:21 GMT

d_gosbell Greg_Deckler FarhanAhmed KBO

Re: Exporting Powerbi data gateway from Powershell

d_gosbell — Tue, 29 Sep 2020 01:12:46 GMT

Why not just post a comment asking this on the gist you linked to? The author of the script is probably best placed to answer whether or not you can get the additional information you are looking for.

Re: Exporting Powerbi data gateway from Powershell

Icey — Thu, 01 Oct 2020 09:45:42 GMT

Hi Anonymous ,

Maybe this post could also meet your requirements: Power BI On-premises Gateway Cluster Monitoring (Power Platform API).

Best Regards,

Icey

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

Re: Exporting Powerbi data gateway from Powershell

Anonymous — Mon, 05 Oct 2020 07:28:59 GMT

Icey d_gosbell

thank you again for your responses.

I was able to figure that out using:

Get-DataGatewayCluster -scope organization | Select -ExpandProperty MemberGateways

The infomation was hidden under Annotation

Re: Exporting Powerbi data gateway from Powershell

Icey — Wed, 07 Oct 2020 09:09:32 GMT

Hi Anonymous ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey