Getting Data from Lessonly API using Web Data Source

[emartchenko]

Hi all,

I've been attempting to use the Web API in PowerBI to get JSON formatted data from Lessonly, however having tried numerous URLs I keep getting the same error - 

I've confirmed that there are contents to get via cmd, which spits out the JSON output as you'd expect.

The only real difference between this API and others I've seen is that the subdomain is meant to be input alongside the API key, like so:

So in the dialog window for the api key, I've input it as such:

Without the " " on either side, the credentials are invalid. 

I don't think this is a Lessonly issue, as the data is present, however any input regarding why PowerBI can't seem to find it would be appreciated. 

Thank you!

[JanMichaelBeran]

Did you ever get this resolved? Started trying to call the API from PBI today and getting the same issue.

[lbendlin]

please show a sanitized version of your Power Query code

[V-pazhen-msft]

@emartchenko 

Check the post to find out how to add the credential into the Headers[].Solved: Remote API Access to data source sudden errors - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Use Anonymous connection and specify the credentials in the Headers section or the Content section of the Web.Contents() call

Web.Contents - PowerQuery M | Microsoft Docs

[emartchenko]

Hi there,

Here is my query:

But the results are now:

Am I doing something incorrectly?

Thank you for your help!