To fetch info about Gateway supported reports from power bi service

[rizwana]

Hi,

I would like to know whether there is any way that I could gather information about all the gateway supported reports and workspaces related 

[v-alq-msft · Accepted solution]

Hi, @rizwana 

I wonder if you are using on-premise gateway or personal gateway. Here are differences between two gateways.

                                                On-premises data gateway                                        On-premises data gateway (personal mode)

Cloud services supported	Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows	Power BI
Runs	As configured by users who have access to the gateway	As you for Windows authentication and as configured by you for other authentication types
Can install only as computer admin	Yes	No
Centralized gateway and data source management	Yes	No
Import data and schedule refresh	Yes	Yes
DirectQuery support	Yes	No
LiveConnect support for Analysis Services	Yes	No

I'd like to suggest you refer the following links.

Guidance for deploying a data gateway for Power BI 

Manage data sources 

Best Regards

Allan

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

[rizwana]

Hi,

Thanks for the information.

I am using on-premises gateway connection.My intention is to export all information about reports that are supported using gateway connection.I can get the information about each data source information from 'manage gateways' but I would like to get all in one excel sheet,datasource,report name and workspace name.

[Greg_Deckler]

Maybe? https://docs.microsoft.com/en-us/rest/api/power-bi/gateways

[rizwana]

Thanks,I think this information will solve this.I am currently trying to set up the solution as provided in that link.