Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
On the next lines a code to connect to an API using the white Query option. Unfortunatelly althoug I´m getting the data (Image 1) I can´t save the Query, I´m getting the error that you can see on the image 2.
Important to mention that I´m creating different entities / tables that connect to the same company using different url endpoints. Also is important to mention that the API gets new data every time.
Any ideas?
@Jimmy801 maybe can you save me again?
Code:
let Final = List.Generate ( ()=> [ Result= Json.Document(Web.Contents("https://api.repsly.com/v3/export/clients/0", [Headers=[Accept="application/json"]])), TotalCount = 1 ], each [TotalCount]>0, each [ Result= Json.Document(Web.Contents("https://api.repsly.com/v3/export/clients/" & Text.From([Result][MetaCollectionResult][LastTimeStamp]), [Headers=[Accept="application/json"]])) , TotalCount = [Result][MetaCollectionResult][TotalCount] ], each [Result][Clients] ), FinalTable = Table.FromRecords(List.Combine(Final)) in FinalTable
Image 1:
Info dowloads ok
Image 2: Error when trying to save
Having the same issue with oData connection. Is there any solution?
Hi @Holguinmora ,
Please refer to the document below.
https://ssbipolar.com/2018/11/23/power-bi-dataflows-reuse-without-premium/.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jay hi@v-jayw-msft
Thank you for your help
On the next images the step by step that I follow from the link that you sent me, on the refer table I tryed with enable / disable load data with the same error, any ideas?
Image 1: Paste the code
Image 2: Run the code
Image 3: Re name and disable the load option
Image 4: Create the referred Query
Image 5: Enable / Disable the load option
Image 6: Error
Image 1: Paste the code
Image 2: Run the code
Image 3: Re name and disable the load option
Image 4: Create the referred Query
Image 5: Enable / Disable the load option
Image 6: Error
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.