cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjnshenoy Frequent Visitor
Frequent Visitor

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
2 REPLIES 2
blopez11 Established Member
Established Member

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,
Super User
Super User

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