Forum Discussion

Amar-Agnihotri's avatar
Amar-Agnihotri
Icon for Resolver I rankResolver 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's avatar
    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's avatar
PhilipTreacy
Icon for Super User rankSuper 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

Amar-Agnihotri's avatar
Amar-Agnihotri
Icon for Resolver I rankResolver I
4 years ago

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 . ðŸ™‚