cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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

 

Captura de Pantalla 2020-01-28 a la(s) 4.34.40 p. m..png

 

Image 2: Error when trying to save

 

Captura de Pantalla 2020-01-28 a la(s) 4.34.50 p. m..png

 

2 REPLIES 2
Highlighted
Community Support
Community Support

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

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Helper I
Helper I

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

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

1.png

 

Image 2: Run the code

2.png

 

Image 3: Re name and disable the load option

3.png

 

Image 4: Create the referred Query

4.png

 

Image 5: Enable / Disable the load option

5.png

 

Image 6: Error

6.png

 

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors