Forum Discussion
Helper IIIHow to use refresh on web data and leave out refresh on table from Onedrive?
Hi,
I have a pbix uploaded to Service. In the pbix, I have an online source from a csv through a web-connection, and it refreshes as it should.
In the datamodel, I have added an Excel table from my OneDrive. Data here are fixed, and no refresh is needed.
I have checked the "include in report refresh" off in Power Query for the Excel table.
The problem is: In Service, I can't shedule a refresh on the dataset, as it says that a Gateway is needed. I can't use a Gateway, as my computer will be off regularily.
Furthermore, I don't need that Gateway, as I don't need to refresh the Excel data. I only need to refresh the data from the web-connection, which does not need a Gateway. When excluding the Excel data, refresh is running fine (without Gateway).
Which steps are necessary to take in order to get rid of that message and to make refresh only to be about the web-connection data?
Hi MarianneElver,
Based on my research, I am afraid you could not achieve this feature, if you want to set the refresh, it will refresh the whole data in your data source. You could not just refresh the web data.
Regards,
Daniel He
6 Replies
v-danhe-msftMicrosoft Employee
Hi MarianneElver,
From your description, if your data source includes the data from web, you need to configure a gateway for it.
Reference:https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#list-of-available-data-source-types
Regards,
Daniel He
- MarianneElverHi, thanks for your reply. I have plenty of dashboards running on these kind of web data, and they work fine without gateways. The challenge is my Excel data, that I don't need to refresh, but it seems like it requires a gateway, because Power BI service thinks that data has to be refreshed too, but they don't. I am looking for ways to avoid that! KR Marianne
- v-danhe-msft
Hi MarianneElver,
Based on my test, if your data source used the web.Page function, you need to configure a gateway for the datasource.
Reference:https://docs.microsoft.com/en-us/power-bi/refresh-data#power-bi-desktop-file
You could check it in the Advanced languae in query editor:
And it could work on my side:
I suggest you test it again.
Regards,
Daniel He
