Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |