Forum Discussion

MHadi's avatar
MHadi
Frequent Visitor
6 years ago

Refresh Power BI dataset connected to Scopus API database

I prepared a scientometric dashboard using Power BI which is connected directly to Scopus database by calling API keys. On my Power Bi desktop it can refresh data without any error but after publishi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI MHadi ,

Maybe you can contact ImkeF to get some suggestions about power query web connector with rest API.

Regards,

Xiaoxin Sheng

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi MHadi  

the first query is not working for me. This is the errror I'm getting in the browser:

 

Could you please check the code? (I've created my own API key)

 

  • MHadi's avatar
    MHadi
    Frequent Visitor
    6 years ago

    Hi Dear  ImkeF 

    Thanks for your answer, I checked it. It works for me with no problem. I think  your case may be due two possible things:

    - You may not pasted your APIkey in username box in credential Basic setting.

    - Your system may not subscribed to Scopus. Our university has purchased Scopus subscription.

     

    Thanks again.

     

      • MHadi's avatar
        MHadi
        Frequent Visitor
        6 years ago

        Hi ImkeF 

        Thanks for refereing me to the blog address,

        but I myself previously followed the recommendation in that blog as you can see in my query 2 at above which I used a relative address for Scopus but finaly it returns a credential error on web refreshing trial. I also tried followig query using header but this one also could not resove the refereshing issue on web.

        By the way I think I tried all ways but ineed I am bigneer in PBI and my mind is confused completely for this problem. Thanks anyway...

         

        Query 3

        let
    Source =  25, //the total value from a total rows api?
    Starts = List.Generate(()=>0, each _ < Source, each _ + 25),
    #"Converted to Table" = Table.FromList(Starts, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Json.Document(Web.Contents("https://api.elsevier.com/",
          
    [RelativePath="content/search/scopus", Headers = [#"X-ELS-APIKey"="APIKEY" ,#"Accept"="application/json"], 
    Query=[query="AFFIL ( {Environmental Research Center}  OR  {Institute for Environmental Research} )  AND  AFFIL ( {Tehran University of Medical Sciences}  OR  {Tehran University of Medical Science} )",
        view="complete",
        limit="40",
        start="&[Column1]",
        count="25"]])))
in
#"Added Custom"