Integrations with Files and Services

[GavinClark]

Hi All,

We're looking for a "fair" method to recover the IT costs for Enterprise Gateway (infrastructure, maintenance, admin etc.) from the business units so they know what they should budget for.

Personally, I'd prefer something more consumption based (e.g. largest volume data transfer) and charge a flat fee per Mb or Gb. I think this method is fairer to the business rather than based on number of users (which doesn't correlate to Enterprise Gateway useage anyway).

What I'm trying to find out is whether the Enterprise Gateway logs (or some other Power BI log) contains the amount of data transferred per refresh ?. I've had a look around the logs, but I can't see anything obvious ?. Wondered if anyone else has similar needs ?.

Or, is there some way to identify Enterprise Gateway traffic in normal Windows event logs ?

Failing that, is there a way to get the dataset size via an API ? (again, checked the API's available but nothing obvious)

thanks !

[v-yuezhe-msft · Accepted solution]

@GavinClark,

You can use performance counters to monitor gateway traffic. There are some videos and blog for your reference.

https://guyinacube.com/2016/09/troubleshooting-gateway-performance/
https://www.youtube.com/watch?v=IJ_DJ30VNk4
https://insightsquest.com/2016/08/08/monitor-on-premises-data-gateways/

Regards,
Lydia

[GavinClark · Accepted solution]

@v-yuezhe-msft thanks ! , I'll take a look sometime today and let you know. I've scanned the document and it looks like I should be able to get what I need.

[v-yuezhe-msft · Accepted solution]

@GavinClark,

You can use performance counters to monitor gateway traffic. There are some videos and blog for your reference.

https://guyinacube.com/2016/09/troubleshooting-gateway-performance/
https://www.youtube.com/watch?v=IJ_DJ30VNk4
https://insightsquest.com/2016/08/08/monitor-on-premises-data-gateways/

Regards,
Lydia

[GavinClark · Accepted solution]

@v-yuezhe-msft thanks ! , I'll take a look sometime today and let you know. I've scanned the document and it looks like I should be able to get what I need.