Forum Discussion

PiyushH1's avatar
PiyushH1
Helper I
6 years ago
Solved

Exchange rates Data not refresh

Hi Team, I have below code in my Exchange rate table in advance editor. Everythinng is working fine what i want but when i publish in BI service i am geeting below Error message due to not geeting d...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    You have to have a gateway installed. You cannot refresh web results directly. I cannot find the article on this but this was a change in late 2018 I believe.

     

    EDIT: Here is the ultimate list of data sources for Power BI. Scroll down to Web and you'll see that a gateway is required.

edhans's avatar
edhans
Community Champion
6 years ago

I pasted in your code and it works fine here. Two things to check:

  1. Make sure the permissions are not blocking. It is a website, so I'd set permissions to NONE unless you are combining internally with sensitive data. See image below. You get there via the Data Source icon in the ribbon.
  2. Go to Options for Power BI, then Preview Features, and make sure New Web Table inference is checked. There are some new bits in this connector that may overcome errors from previous web queries. I'm also on the Dec 2019 desktop, the latest.

 

This is a very nice function. Mind if I use it internally? We do CNY conversions all of the time.