Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connecting to web api

Hi  I am very new to using Power bi, so this might be a very basic question, but hope someone can help me.  Until now I have only created dashboards based on data from our local server. However now...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thansk Jayendran!

 

I have been provieded with a token form the web service, where does that fit in ?

 

If you open the link, then i though i shoul build a Url like this: 

 

Web.Contents("https://api.onlinepos.dk/api/getCardsList/{debtor}/{type}/{offset}")

 

Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi Anonymous 

 

As SteveCampbell  mentioned you can pass the token in the Headers,

In Power Query this will be like

Web.Contents("https://api.powerbi.com/v2.0/",[Headers=[Authorization=Bearer 412sdsx1....]])

Making much simpler you can also provide your query parameters lilke the below

Web.Contents(
    "https://data.gov.uk/api", 
    [
        RelativePath="3/action/package_search", 
        Query=
        [
            q="cows", 
            rows="20"
        ]
    ]
)

Some References:

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics-sweden/

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

  • Jayendran's avatar
    Jayendran
    Solution Sage
    6 years ago

    Hi Anonymous ,

     

    Do you have any update ? If you solved your problem, please accept the answer so that it will help other community members