Refresh data in a published report done in Desktop

---

v-juanli-msft wrote:

Hi ramiroferrando 

It is possible with schedule refresh in Power BI.

You need to configure Gateway connection->Data Source Credentials->Schedule Refresh.

See more details here.

 

Please look at my test below: 

1.Get data from Web using Anonymous authetication,

2.publish to Service, find this dataset, go to Setting,

Add a on-premise gateway and provide correct credential.

3.set schedule refresh time

 

Please note, the credentialS used in Power BI Desktop and under gateway in Power BI Service should be the same type and same one.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

---

Hi, this was really useful. Thank you so much.

However, I'm still having an issue understanding which datasets need a Gateway connection and which don't.

For example, I have two similar reports whose only data sources are: Get data -> Web (I'm getting tables from multiple websites)
In one of the reports I get several tables in the data model, append some of them and then, I make a couple of visualizations. That report, once published in the Power Bi Service asks me to set the  Gateway connection.

But in another similar report, which is almost the same, but it's just getting data from one website  (Also Get data -> Web) is working differently. Because once I've published it to the Power Bi Service is telling me "You don't need a gateway for this dataset".

So, summing up, I'm not sure if the Gateway requirement is based on the fact that I'm using several Web sources in one of the reports and just one in the other, or if it's because I'm making multiple connections among the tables in one of the reports and I'm just using the data without modeling it in the other.
Would you know the answer to this?