- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Image 2: Error when trying to save
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Having the same issue with oData connection. Is there any solution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If this post helps, then please consider Accept it as the solution to help the other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-23-2024 01:01 AM | |||
03-11-2021 12:47 PM | |||
06-02-2024 11:01 PM | |||
07-01-2023 03:57 AM | |||
11-07-2023 02:21 AM |
User | Count |
---|---|
54 | |
51 | |
49 | |
13 | |
11 |