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.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors