Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

sasmpu00

VSTS Rest API as Data source returning error

Submitted by on ‎05-03-2017 07:17 AM

While placing REST API in browser, it's returning JSON content from VSTS.

 

But the same URL used in Power BI desktop as data source (as web) is returning error (we found an extra character in JSON while making it JSON.Document at advanced editor).

 

If I save the output from browser in file, then power bi can read the content as JSON. 

 

I am not sure what is causing the problem. is the something because of secure URL? Please guide me how to resolve this issue.  

 

Status: Needs Info
See more ideas labeled with:
6 Comments (6 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-05-2017 12:33 AM

@sasmpu00

 

Could you please provide some screenshots for this issue? A sample is preferred.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-05-2017 12:35 AM
Status changed to: Needs Info
 
erikskov
Advocate II
Advocate II
‎06-08-2017 12:08 PM

Same issue:

 

Query URL: -- basic return list of queries available

https://p2rmjames.visualstudio.com/DefaultCollection/MyFirstProject/_apis/wit/queries?$depth=1&api-v...

 

VSTS REST API query result from browser:

REST API result in browser.JPG

Power BI Get Data:

Power BI Get Data.JPG

Power BI Error:

Power BI Error.JPG

 

 

 

Anonymous
Not applicable
‎07-02-2018 05:28 PM

nice that this went unanswered

arsaveli
Helper I
Helper I
‎07-03-2018 09:42 AM
@erikskov I couldn't find exact match of your first screenshot in current version of PowerBI - do you mind specifying hiow you got to that connector? In current PowerBI you just use Web connector, and it automatically recognises JSON format. The trick is using the right authentication - you can use VSTS PAT and plug it into "WIndows" authentication as the password (leaving user name empty). Alternatively, you can use VSTS.AccountContents function to hit that URL - this will take care of the login for you. @sasmpu00 can you also make sure you are using most recent version of PowerBI and make sure you log in with PAT? I think the server is actually returning a login page to PowerBI - which is not in JSON.
erikskov
Advocate II
Advocate II
‎07-03-2018 10:32 AM

Guessing that's a change in one of the last 12 or so updates to Power BI since my post...  😛

 

I honestly don't remember the exact steps nor do I still have access to the original source system.

 

I would expect the Web Connector to allow me to hit the VSTS datasource using Organization credentials...but like I mentioned, this is 12 months old and no longer an issue/priority for me...

Idea Statuses