Dataset not refreshing because of dynamic datasource, help!

[SuperFiets_]

Hi!

I need some help, I want to refresh one of my datasets within Power BI Online with a scheduled refresh. However I am getting the following error: "You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

• Data source for Query1"

However I don't gave a query named 'Query1' and as far as I am aware I don't use an url.

What I do use though is a source parameter for some queries. And this parameter uses the function Files.Folder with the source being a folder in a OneDrive folder. So the source for example is: C:\Users\nigel\OneDrive\Development.

Could this be my dynamic data source? And if so, is there any workaround I could use to establish the same functions but with the possibility to refresh the dataset on a scheduled basis.

Thanks in advance

[ibarrau]

Hi! I think you first need to get and connect data without the parameter. If you can do that without dynmaic sources you can change some source details with parameters. Your description sounds like you are doing stuff in the param that is preventing a static connection. If you want to try a different way to connect to a drive folder, try this:
https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de

Once connected, check which value you could replace with params.

I hope that helps,