Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
User | Count |
---|---|
97 | |
76 | |
76 | |
47 | |
26 |