Dataset not refreshing because of dynamic datasource, help!

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,