Using rest service as data source

[segato]

This works perfectly fine in PostMan:

However I get a authentication error when trying to connect. Any ideas?

[v-shex-msft]

Hi @segato,

I'd like to suggest take a look at the following blog about use web connector and optional parameters if it suitabled to your scenario:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Regards,

Xiaoxin Sheng

[segato]

Thanks highly appreciated. But its related to handle your urls and not my issue?

[v-shex-msft · Accepted solution]

HI @segato,

In fact, I faced some credentials issue that appeared when you work with anonymous mode with credentials directly apply on the whole URL.

For this scenario, it can be fixed when you split on your URL to root URL and 'relative path' and use the root part to receive the credentials.

Regards,

Xiaoxin Sheng