Forum Discussion
Datasource rendering
Thnaks it solved my other problem.
But the problem remains unsolved...
I want everytime user to load new data from new datasource. Like the one there is a feature in PowerBI Get DATA which asks which datasource to use.
One way to get that functionality is to create a Parameter in the query editor to hold the datasource path/file/etc., and the replace the hardcoded path/file/etc. in your query with the name of that parameter. If you then save your pbix as a pbit file (template file) and send that to your user. When they open it, they will get prompted to fill in that parameter before refresh.
Please see an article I wrote on this topic - https://hoosierbi.com/2019/04/07/template-files-are-an-under-sung-feature/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat