Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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
Resident Rockstar
Resident Rockstar

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,

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

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors