ODATA Getting Invalid Data Source

Document ID : KB000097163
Last Modified Date : 18/05/2018
Show Technical Document Details
Issue:
I am able to get a connection when I enter the URL for our ODATA v2 and v4 Endpoint, i.e., the XML page comes up fine with both versions. However, I cannot get connect to our Production Environment via PowerBI. ( I have connected to other environments such as in training). I am getting the following error: Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (Invalid data source).....
Resolution:

PowerBI not prompting for application credentials for O-Data

From Power BI

A) Go to options and settings

B) Data source settings

C) Select "global permission" on data source settings

D) Select your data source and click "clear permissions"

After the above steps, Please perform the following:

A) Restart the Power BI

B) Log back in

C) Connect to O-Data

D) It will prompt you for the "UserID and Password"