Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Holguinmora
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

 

3 REPLIES 3
Hexekutive
Advocate II
Advocate II

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

v-jayw-msft
Community Support
Community Support

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.

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors