Bug: Can't automatically refresh depending on char...

benbateman · ‎06-29-2016

Hey folks,

I'm getting a strange bug where my reports work fine in Power BI Desktop but when I publish it to powerbi.com the same authentication details won't work and it just timeouts, so I can't set it to automatically refresh. It's just a simple API call to a service with basic authentication. I tripple checked the authentication details and they were correct, so I tried someone elses authentication details. They, surprisingly worked. After some experimentation. I managed to figure out that if my password didn't contain an asterisks then it connected fine.

Otherwise I got the following error message:

Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.

Activity ID: aaead3dd-83dd-4845-8dba-0a72553575d1
Request ID: ba890239-41df-a6fd-33f6-ee9d349575a7
Status code: 400
Time: Wed Jun 29 2016 14:53:29 GMT+0100 (GMT Daylight Time)
Version: 13.0.1500.307
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
Details: Timeout expired. The timeout period elasped prior to completion of the operation.

To double-check it wasn't something else I reduced the number of rows the API call was going to return by ~80% and I still had the issue.

Eric_Zhang · ‎07-01-2016

@benbateman

Thanks for your feedback.

Can you be more specific on "a simple API call to a service with basic authentication" to help reproduce the same problem?

benbateman · ‎07-01-2016

Hey @Eric_Zhang, sure.

It's a third party-attribution service (Apsalar). You can read their API documentation here. Unfortunately I don't think you'll be able to set-up an account to try and reproduce the steps. I could however put you in contact with their support team.

Like I said, while it could be a problem their end, but it's odd that I don't have any issues in Power BI Desktop, only when I publish my reports and try to enable auto-refresh.

Thanks for getting back to me. Let me know if there's anything else I can do to help.