Refresh Power BI dataset connected to Scopus API database

Dear Xiaoxin Sheng

Thanks so much for your answer to my question, but your recommendation can not resolve my issue. I should clarify more the problem.

I have two following queries which both of them works well and refereshed without any error in desktop Power BI. The first query also can be refereshed well on Power BI web but the second query could not referesh on web and returns credential error. The first query returns only 25 records, but because I had to return all of my records (809 records) I changed it by making a relative path using recommendation in here. I think using a relative path in second query which is my problem case, may prevent credeintial data to be detected. But I have no solution for this. ( in the queries just APIKEY should be replaced with your APIkey, you can register for api key here ). Thanks again for any help

First query:

let
source=Json.Document(Web.Contents("https://api.elsevier.com/content/search/scopus?&view=complete&query=AFFIL ({Environmental Research Center} OR {Institute for Environmental Research} )  AND  AFFIL({Tehran University of Medical Sciences} OR {Tehran University of Medical Science} )&apiKey=APIKEY"))
in
source

 Second query:

let
source=Json.Document(Web.Contents(
	"https://api.elsevier.com/", 
	[
		RelativePath="content/search/scopus/",
		Query=
		[
		 view="complete",
                 query="AFFIL ( {Environmental Research Center}  OR  {Institute for Environmental Research} )  AND  AFFIL ( {Tehran University of Medical Sciences}  OR  {Tehran University of Medical Science} )",
                 apiKey="APIKEY"           
         	]
	]
))
in
source