Forum Discussion
Unable to schedule refresh for dataset with excel parameter
The use case. I have a PBIX file that contains a SQL query which has a "WHERE" clause that is parameterized. The parameter is derived from an excel workbook that user updates. https://docs.microso...
v-lili6-msft
Community Support
Community Supporthi SV_community
If you have set up the gateway for the datasurce?
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth
Regards,
Lin
Hi
For datasets that connect to excel on onedrive as a web link, I always add my credenials in Data Source Credentials and dont add it to gateway as the url cannot be directly used in gateway.
In this instance, data source credential option is greyed out