Forum Discussion

oanam's avatar
oanam
Icon for Helper I rankHelper I
5 years ago
Solved

Currency code not found from xe.com connection

Hi,   I have an xe.com connection ( https://www.xe.com/currencytables/?from=GBP ) established a few months ago and I already built some measures on it using the rate of the currency exchange. All o...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi oanam ，

     

    If what you need is the Live Currency Rates table, I don’t think you need to update the date. As shown in the figure below, when you refresh the report, it will display the latest data.

     

     

    If you need Table1, then you can refer to https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters  to create dynamic M query parameters.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.