Power BI dataset refresh failing - AppAnnie

[horizondave]

Last week I setup a dashboard using the built-in AppAnnie connector from app.powerbi.com.

However, it refuses to refresh - it fails every time whether it runs from a schedule or I click "refresh now".

I've re-entered the Oauth2 credentials, and it still fails.....It isn't the same error every time - the table name referred to changes:

See below for an example:

What can I do to investigate / fix this?

Last refresh failed: Mon Nov 20 2017 09:32:56 GMT+0000 (GMT Standard Time) 
There was an error when processing the data in the dataset.Hide details

Message:	The command has been canceled. Table: usage.
Cluster URI:	WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID:	da3ccc85-5c75-49bf-9e83-d90e73da9a6a
Request ID:	22677e41-2c5b-5ee6-0965-b20190f0d404
Time:	2017-11-20 09:32:56Z

[v-yuezhe-msft]

@horizondave，

I connect to App Annie in Power BI Service and refresh the dataset, everything works well. The above error message is a generic message which can be caused by several reasons, for example, you dataset contains high density of data and you have low network bandwidth.

To troubleshoot this issue, I would recommend you connect to App Annie in Power BI Desktop by using Web.contents method suggested by Bjoern in this idea, then check if you can refresh the dataset in Power BI Desktop. If there is no issue in Desktop, reduce the dataset size by filtering limited rows,  then publish the PBIX file to Power BI Service and check if you can refresh it in Service.

Regards,
Lydia