Hi all,
I have a report that has an API data source that looks like the following:
Source = Json.Document(Web.Contents("https://api.company.com/dapi/v1/xxxxxxxxxxxxxxxxxxxxxxxxx?$top=1000000&$skip=0&apikey=xxxxxxxxxxxxxx...")),
This essentially returns a list of values that I then transform in power query.
The data source works fine on Desktop but once I upload it to service it throws the following error:
DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server.. ;The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server.. The exception was raised by the IDbCommand interface. Table: tablename
I tried changing the privacy levels still the same.
Any ideas what it could be?
Thanks in advance!
