Forum Discussion
Helper IIIHow to use refresh on web data and leave out refresh on table from Onedrive?
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
Microsoft EmployeeHi 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
Helper III- 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
- MarianneElverHi, thanks for the reply. I am not using the web.page for my web data but another solution, and my web data is not at all the problem! My web data works and refreshes automatically without problems. My big challenge is the data from Excel that I have on my Onedrive. This data does not need to be refreshed, but it is part of a pbix that has other sources (hence the web data, that works fine). Once uploaded to Service, the pbix now asks for a gateway. Most likely because of the Excel data. So the question is: Can I get rid of having the Power BI Service asking for a gateway to data on my Onedrive, now that this Excel data does NOT need refresh? In other words, I need to leave out the refresh of the table that is built on Excel data, as data is static here. Is that possible?
- v-danhe-msft
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