Forum Discussion

sfeki's avatar
sfeki
Regular Visitor
4 years ago

Schedule Refresh Power BI Service Issue

Hi Community, I'm facing the below error when trying to schedule refresh on Power BI service :    This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Po...
Need Help
Show and Tell
sfeki's avatar
sfeki
Regular Visitor
4 years ago

Hi ibarrau, 

Many thanks for your comment.

 

Unfortunately even after applying the suggested change I'm still unable to schedule the refresh.

 

I can see in the script that the parameters are being called in the highlighted line as well, do I need to proceed with any changes for that part as well ?

 

Thanks a lot.

ibarrau's avatar
ibarrau
Super User
4 years ago

You need to stick the practica on every opportunity. The highlighted line is an error because you are trying to avoid the practice sending the url all over again. You can read more about "Custom Functions". You just need a custom function that will handle the Web.Contents receiving the parameters you need instead of concatenating a big string. You can learn how here:
https://www.sqlservercentral.com/articles/create-custom-functions-in-power-query

I hope that helps,