Can't save dataflow "One or more tables references a dynamic data source

Question

The below query working fine&nbsp;but when I try to save and Close the dataflow it throughs an errorCan't save dataflow "One or more tables references a dynamic data sourcelet&nbsp; &nbsp; Source = URLTable,&nbsp; &nbsp; FirstURL = Source{0}[URL], // Change 1 to the index of the URL you want to use&nbsp; &nbsp; // Function to handle retry with exponential backoff&nbsp; &nbsp; RetryFunction = (URL) =&gt;&nbsp; &nbsp; &nbsp; &nbsp; let&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Define the number of retry attempts&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; maxAttempts = 5,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Initial wait time in milliseconds&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; initialWait = 1000,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Function to make the actual request&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MakeRequest = (retryCount, waitTime) =&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Attempt to fetch data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result = try GoogleSheets.Contents(URL)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;otherwise null,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Handle retry logic&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; nextWait = waitTime * 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; in&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if result &lt;&gt; null or retryCount &gt;= maxAttempts then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MakeRequest(retryCount + 1, nextWait)&nbsp; &nbsp; &nbsp; &nbsp; in&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MakeRequest(1, initialWait),&nbsp; &nbsp; // Invoke the retry function with the FirstURL&nbsp; &nbsp; Tb = RetryFunction(FirstURL),&nbsp; &nbsp; // Navigate and process data within the dynamically fetched table (Tb)&nbsp; &nbsp; Navigation = Tb{[name = "Members", ItemKind = "Table"]}[Data],&nbsp; &nbsp; PromotedHeaders = Table.PromoteHeaders(Navigation, [PromoteAllScalars = true]),&nbsp; &nbsp; ChangedColumnType = Table.TransformColumnTypes(PromotedHeaders, {&nbsp; &nbsp; &nbsp; &nbsp; {"Membership Number", type text},&nbsp; &nbsp; &nbsp; &nbsp; {"Membership ID", Int64.Type},&nbsp; &nbsp; &nbsp; &nbsp; {"Membership Category", Int64.Type},&nbsp; &nbsp; &nbsp; &nbsp; {"Category Name", type text},&nbsp; &nbsp; &nbsp; &nbsp; {"Member Status", type text}&nbsp; &nbsp; })in&nbsp; &nbsp; ChangedColumnType

anonymous · Accepted Answer

Hi&nbsp;Baqa&nbsp;,According to my search, dataflow does not work with dynamic URLs.&nbsp;I see that there seems to be a step in your M function that has a URL selection step, which may be the problem.You can refer to this post's solution:Solved: Error - "One or more table references a dynamic Da... - Microsoft Fabric CommunityYou can also refer to these posts:Solved: API Paginated Result 'One or more table references... - Microsoft Fabric CommunitySolved: sql.database , Can't save dataflow One or more ta... - Microsoft Fabric CommunityBest Regards,Dino TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Can't save dataflow "One or more tables references a dynamic data source

Can't save dataflow "One or more tables references a dynamic data source

1 Reply

Related content

Dataflow Gen2: Variable Library references fail in Connection Settings

Fabric Dataflow Gen 2

dataflow gen1

"Working on it" Frustration

connection to dataflows