Showing posts with label Enterprise. Show all posts
Showing posts with label Enterprise. Show all posts

Wednesday, 25 January 2017

Use tags to drill into Azure Enterprise Billing with Power BI

Whilst Power BI's Azure Enterprise Content Pack gives you pre-built dashboards to expose your Azure Enterprise costs, it may not provide the level of detail required to really drill-down into the finer detail of resource costs for your Azure subscriptions.

What if you wanted to tag resources to identify those that belong to your enterprises products or services and report on costs for each. For example, perhaps you'd like to be able to find out how much was spent on Azure Compute resources (Virtual Machines) and storage during the first month of an online service that you've just launched. Your VMs might be spread across Resource Groups, with their storage being held in storage accounts in multiple regions. In order to easily differentiate those resources that are dedicated to the new service from existing resources you could tag those resources as follows:

"service" : "ournewservice"

Using Microsoft's Power BI you can then connect to your Azure Enterprise billing data via the Azure Enterprise (Beta) Data Connection, see here.


The Power BI approach then enables reports and dashboards to be built that display Azure Resource costs per service, by grouping and filtering on resource tags. If you have multiple tag names, then Power BI gives you the ability to split these out into dedicated columns from which tag-specific reports can be built.

Friday, 12 August 2016

Debugging the PowerBI Enterprise Gateway

I recently configured the PowerBI Enterprise Gateway to connect to two different types of data source:
  • A local File on the same server as the gateway, and
  • A Web datasource, a URL reachable from the gateway server 
I added the data sources to PowerBI Online via "Manage Gateways". I could see the data sources refreshing and available within PowerBI Online. So I built a report that used the data sources and published the report to PowerBI Online.I then configured the datasets to use the Gateway connection and also scheduled a daily refresh.

A day later, I revisited my reports to check that the data sources had successfully refreshed overnight, but instead had a failure as follows:

The data gateway abcdef is offline, so refresh scheduling is currently disabled. Last refresh failed: Fri Aug 12 2016 17:09:06 GMT+0100 (GMT Summer Time)
Cannot connect to the mashup data source. See error details for more information.

Concerned that the gateway service had gone down I logged onto the server running the gateway and checked the service was running and the logs files here:

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log
See this link for more troubleshooting tips.

It turned out that even though the File data source was still available, the Web data source had become unreachable.
Therefore, rather than just indicate that one data source was unavailable, PowerBI Online appears to report the entire data gateway as offline. Which isn't entirely true, the gateway service was running, but one of the data sources was unavailable.