Data Refresh keeps forgetting credentials - OData

[Anonymous]

The refresh fails with this error:
Processing error: The credentials provided for the OData source are invalid.
When I go to Schedule Refresh - I see errors with some sources.
Then I enter them one-by-one untill there are no errors, but when I again open some source that I've just entered valid credentials for (Basic authentication) - it shows "Anonymous" as if it has forgotten what I've just entered...
Sometimes, when trying a lot - I do succeed, but rarely.
It looks like a bug, but I doesn't allow me to go Production and all the Power BI project is a NO GO 😞
Please help
Thanks, Michael

[v-qiuyu-msft]

Hi @Anonymous,

Which data source did you connect to? Based on my test, if connect to Dynamics CRM use OData data source, entered OAuth2 credential will change to Anonymous automatically when we back to Data Source Credential settings, but the refresh can also work.

Best Regards,
Qiuyun Yu

[Anonymous]

My sources are 13 OData (REST API) urls (with parameters) that return JSON.

I also have 5 OneDrive simple Excel files connections.

For OData I have to use Basic authentication and for OneDrive - OAuth2.

All the sources return at most 12 K rows. I have only 35K rows in my model. Tiny.

I publish from Desktop .pbix file (which is working).

**By the way - in Desktop I only have to define the credentials twice - once for OData and once for OneDrive (because it asks on which url level to use credentials and I choose www.highestlevel.com, so that all the sub-pages use the same credentials). I didn't see this convenient option in the PowerBI.com service.**

So, the refresh fails with this error:

"Something went wrong.

There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details.

Data source type

Processing errorThe credentials provided for the OData source are invalid. (Source at https://www.TheSourceOfMyAPI.com/....)

Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net

Activity IDb91025a4-60ab-4bd3-a457-49b9de9c608f

Request ID9477c5ef-e015-4725-093f-38c2e470ef59

Time2017-01-03 19:54:55Z"

I go to DataSet credentials and it says:

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

There is an X next to 2 of my OData sources (out of 8). I notice it only shows 8 OData sources out of 13, probably because some of the, differ only in parameters with the same url.

Anyway, I go to these two and I see "Anonymous" instead of Basic. So I change, enter the right credentials, it accepts, says "datasource was updated" and the X is removed. So far so good.

I do "Refresh now", it thinks 10-20 seconds and fails again with the same error.

I've tried tens of variations - spent almost three days and nothing....

Please help. The whole power BI project is in danger since it cannot refresh.

Thank you

Michael

[bpalermo]

Hi, 

Did you ever resolve this?  I'm getting an issue where the odata credentials are being forgotten everytime you enter them.  It used to work, and then a few months ago it stopped.  Very frustrating!

[YashnaSaxena]

 Was this issue resolved? I'm facing the same issue . Only difference is with my data source. I am using an excel doc as my data source.