Error: "Can´t Save Data Flow" One or more entities reference a dynamic data source

[Holguinmora]

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

[Hexekutive]

Having the same issue with oData connection. Is there any solution?

[Anonymous]

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.

[Holguinmora]

Jay hi@Anonymous 

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