How to refresh Web Contents using Power Query without the Query parameter in header?

[Anonymous]

Hi Team, I am currently working on Tempo Timesheet API integrated with JIRA. I am successfully able to refresh Time sheet data in Power BI cloud extracted from Tempo worklogs using the below Query. let Source = Json.Document(Web.Contents("https://api.tempo.io", [Headers=[Authorization="Bearer xxxxxxxxxxxxxxx"],RelativePath="rest-legacy/tempo-timesheets/3/worklogs", Query=[projectKey = "HSI",diffOnly="true",addApprovalStatus="true"]])) in Source My next requirement is to create relationship between Tempo Teams Table and worklogs Table. I am using the below API call to get the Teams Data but unable to schedule the same in Power BI cloud. Can you please suggest me the correct approach to create a schedule using the below API call. let Source = Json.Document(Web.Contents("https://api.tempo.io", [Headers=[Authorization="Bearer TXwZRhrKlBP2l85xDsDo7LCV6FlVsD"],RelativePath="/rest-legacy/tempo-teams/2/team/34/member"])) in Source Many Thanks, Arjun

[blopez11]

Can you provide a screenshot of the error you are seeing when refreshing in the service? Would it be possible to post the M code for each of your queries, you can anonymize any data deemed private Thanks,

[ImkeF]

Maybe this article contains the solution: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...