Forum Discussion

Amar-Agnihotri's avatar
Amar-Agnihotri
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'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
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

  • Amar-Agnihotri's avatar
    Amar-Agnihotri
    Resolver 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 . ğŸ™‚

  • Amar-Agnihotri's avatar
    Amar-Agnihotri
    Resolver I
    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  - 

     

    I clicked OKay then it is asking for credentials  - 

     

     

    Then i Logged in using anonymous because i always use this option. 

     

     

    Now it shows this message  - 

     

     

    Currency_ are coming from this source  - 

     

     

    NOW PLEASE TELL ME HOW TO RESOLVE THIS ISSUE ?

  • Syndicate_Admin's avatar
    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  - 

    Error-1.png

     

    I clicked OKay then it is asking for credentials  - 

     

    Error2.png

     

    Then i Logged in using anonymous because i always use this option. 

     

    Error3.png

     

    Now it shows this message  - 

     

    Invalid_Credentials.png

     

    Currency_ are coming from this source  - 

     

    Cur-Symbol1.pngCur_Symbol.png

     

    NOW PLEASE TELL ME HOW TO RESOLVE THIS ISSUE ?