Reply
Frequent Visitor
Posts: 6
Registered: ‎12-20-2018

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

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
Established Member
Posts: 127
Registered: ‎10-04-2016

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

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,
Highlighted
Super User
Posts: 1,562
Registered: ‎09-06-2015

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

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

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries