Can’t refresh Excel Workbook in my onedrive (Oauth) via PowerBI portal

[mvananaken]

I can’t "refresh now / scheduled refresh" a Excel (PowerQuery) workbook in my Onedrive (via PowerBI portal.) Manual refresh via Excel (local) still works without any problem. 

Hide	On demand	19/08/2015, 09:56:39	19/08/2015, 09:56:59	Failed	We couldn't refresh the workbook because one of the data connections failed to refresh. See details for more information.
Failed Connections: Power Query - XXXXX Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net Activity Id: 56340a46-9f91-27fe-61b3-3e35c4f1d29d Request Id: 11b90acc-8ccc-e37e-66ab-20e119265f18 Time: 2015-08-19 07:56:59Z Thanks a lot! Marco

[JanVW]

Same problem here, also with CRM online, same error. Tried it with a very basic report, single odata connection and still getting these errors.

[mitsu]

Same Problem here .  Has anyone found a solution to this yet ?

[Elmar]

I've got the same problem.

I'd like to refresh my data in Excel using the new Power BI Portal.

The Excel sheet is stored in my Onedrive for Business (Office 365) and is retrieving data from CRM Online (system administrator permissions). 

I've added my credentials using the oAuth2 authentication method in the Workbook -> Schedule Data Refresh -> Data Source Credentials area in Power BI.

When I download the Excel sheet and start a refresh the data is refreshed without any problems. 

[konstantinos]

Could be many reasons..First are the data sources you have supported in PowerBI?

https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi

Second if they are on premises you need Personal DMG & pro account