Forum Discussion
Datasource rendering
If the user has access to the data, you can just give them the pbix button and show them where the Refresh button is on the ribbon.
If not, you could add a simple PowerApp with a refresh button to your report that has a connected flow to refresh the dataset. However, based on your plan, you have a limited number of refreshes per day.
Regards,
Pat
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