Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.