Cannot connect to dev.azure.com data source.

[mscherotter1]

I have a data source at this url ({org} and {project} replaced) and accessing the source works fine from Microsoft Edge: I see the JSON in the edge browser.

https://dev.azure.com/{org}/{project}/_apis/wit/workItems/3343/comments?api-version=7.0-preview.3

When I connect to the Data source in PowerQuery to be able to connect via PowerBI, I login with my organizational account and then get an error.. How can I get this data source working in Power Query:

Error:

An error occurred in the ‘’ query. DataFormat.Error: OData: The given URL neither points to an OData service or a feed: 'https://spsprodsin2.vssps.visualstudio.com/_signin?realm=dev.azure.com&reply_to=https:%2F%2Fdev.azur...'.
Details:
https://spsprodsin2.vssps.visualstudio.com/_signin?realm=dev.azure.com&reply_to=https:%2F%2Fdev.azur... 

[artemus]

The oauth authentication doesn't allow the clientid used in Web.Contents. Replace Web.Contents with VSTS.Contents and it should work.

[mscherotter1]

The solution in this case was to use a Personal Access Token generated on AzureDevOps as a manner of authentication.

[vaibhavkale570]

To resolve this issue and successfully connect to your data source in Power Query, you can follow these steps:

1. Open Power Query Editor: In Power BI, go to "Home" tab and click on "Edit Queries." This will open the Power Query Editor.

2. Remove Existing Data Source: If you already attempted to connect to the data source and received the error, you may see a query with the error listed in the Queries pane. Right-click on the query with the error and select "Delete" to remove it.

3. Add a New Data Source: Click on "Home" tab again and select "New Source." From the options, choose "Web."

4. Enter the URL: In the "From Web" dialog box, enter the URL of your data source: 

5. Click OK and Authenticate: Click "OK" to close the dialog. Power Query will now attempt to connect to the data source. It will prompt you to enter your organizational account credentials for authentication.

6. Provide Organizational Account: Enter your organizational account credentials (Azure DevOps credentials) when prompted.

7. Load the Data: After successful authentication, Power Query should load the data from the JSON API into the Power Query Editor.

8. Close & Apply: Click "Close & Apply" in the Power Query Editor to apply the changes and load the data into Power BI.

By following these steps, you should be able to successfully connect to your data source in Power Query and use it in Power BI. If you encounter any authentication-related issues, double-check that your organizational account has the necessary permissions to access the data from Azure DevOps. Also, make sure to enter the correct URL for the data source in the "From Web" dialog box.

[mscherotter1]

In step 6, when I login with my organizational account, it returns with an error message:

[v-stephen-msft]

Hi @mscherotter1 ,

One possible solution to the issue you're facing is to clear the credentials for the data source from Power BI Desktop and try again. Sometimes, cached credentials that are expired or inaccurate can cause this issue.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.