Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Source Credentials for web

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' 

Need Help

4 Replies

    • blopez11's avatar
      blopez11
      Super User
      5 years ago

      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,

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      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