Forum Discussion
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), ...
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
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 Thanks a lot . Finally it got resolved by your help. I have sent you arequest on Linkedin. It would be great if you accept that . 🙂