The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I know there are lot of solutions regarding this but I have been banging my head against the wall but unable to convert this json into a format that can be used for auto refresh.
Can someone please help me out?
Source = Json.Document(Web.Contents("https://api.xxx.com/v1/objects/object_21/records?page="&Page&"&rows_per_page="&AmountOfRecords&"", [Headers=[#"X-xxxx-Application-ID"="61c2c3c4cd8888xxxx", #"X-xxxx-REST-API-Key"="xxxxx-xxxxx-xxxx-xxb-xxxx9"]]))
I saw a video where the link was segregated into different paths like:
I tried this, but no sucess. Does anyone has an idea how to tranform the link to allow it to refresh on itis own.
"convert this json into a format that can be used for auto refresh"
Do you mean this Power Query code? You are missing the RelativePath component.