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

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

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