Forum Discussion

Resolver I

4 years ago

Solved

Error - "One or more table references a dynamic Data Source ". Not able to save Dataflow

let DatesFrom = Text.End("0"&Text.From(Date.Day(DateTime.LocalNow())),2)&"%2F"&Text.End("0"&Text.From(Date.Month(DateTime.LocalNow())),2)&"%2F"&Text.From(Date.Year(DateTime.LocalNow())-2), ...

Need Help

PhilipTreacy
4 years ago
Hi Amar-Agnihotri

The issue is that Data Flows don't work with dynamic URL's, that is where you supply parameters in the actual URL. So if you use [RelativePath] and change your code to this (just one line needs to change), you should be able to save it.

Source = Web.Contents("https://www.mnb.hu/en/arfolyam-tablazat/",[RelativePath="?deviza=rbCurrencyAll&devizaSelected=ZAR&datefrom=" & DatesFrom & "&datetill=" & DatesTo & "&order=1"]),

NOTE that I'm using Web.Contents

Regards

Phil

PhilipTreacy

Super User

4 years ago

Hi Amar-Agnihotri

The issue is that Data Flows don't work with dynamic URL's, that is where you supply parameters in the actual URL. So if you use [RelativePath] and change your code to this (just one line needs to change), you should be able to save it.

Source = Web.Contents("https://www.mnb.hu/en/arfolyam-tablazat/",[RelativePath="?deviza=rbCurrencyAll&devizaSelected=ZAR&datefrom=" & DatesFrom & "&datetill=" & DatesTo & "&order=1"]),

NOTE that I'm using Web.Contents

Regards

Phil

Syndicate_Admin

Administrator

4 years ago

Hi @PhilipTreacy . Now i am facing another issue . I have 3 tables. Currency Exchange Rates, USD_Rates and Currency_Symbol. Currency Exchange Rates and USD Rates are coming from the same source but Currency_Symbol is coming from a different source. Now i want to merge Currency Exchange rates and Currency Symbol. But it is showing this message -