Data Source Credentials for web

[Anonymous]

If I want to use the data source from the website how do I make it auto-refresh, because I cannot click 'data source credential' 

[Anonymous]

[v-deddai1-msft]

Did it work?

[v-deddai1-msft]

Hi @Anonymous ,

Did you use the RelativePath and Query options with Web.Contents()?

For example, use 

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

instead of

Web.Contents(
 "https://data.gov.uk/api/3/action/package_search?q=cows"
)

For more details, please refer to https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[blopez11]

It is hard to tell what your data sources are from the information provided

Can you expand the "Gateway connection" so I can see the sources needed?

If you are connecting to on-premise data sources, then you need to setup the gateway, then you should be able to expand the credentials area

Just need a little more information to tell

Thanks,