Datasource rendering

[Anonymous]

Hi All,

I am working on a report where user wants to load dataset everytime.SO please let me know how to give that feature, where the user loads data everytime when he wants to see the report. WE want to give load dataset from datasource feature and hen the user can see the report created with default visualization.

[Icey]

Hi @Anonymous ,

Hope this video could help you: Power BI - Refresh Dataset by Button with Power Automate.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

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.

[Anonymous]

I want everytime user to load new data from new datasource. Like the one there is afeature in PowerBI Get DATA which asks which datasource to use.

[amitchandak]

@Anonymous , I think you need a schedule , can you please check

http://desktophelp.sage.co.uk/sage200/sage200standard/Content/Concepts/PowerBI%20Refresh%20data.htm

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

[Anonymous]

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.

@amitchandak 

[mahoneypat]

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

[Anonymous]

@mahoneypat 

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.

[mahoneypat]

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