Refresh data set manually for Power bi Report server(Using button or any other solution)

[binayjethwa]

Hi ,

I have the following requirement, I am currently working with power bi report server and using import mode to connect to SQL server . The requirement is to have a manual refresh where user can click on any refresh button and data has to update to latest data and visual should display same. We have schedule refresh option but its for every 1 hour but the user want to see the real time data as the data refreshes.

I tried direct query but i need to redo everything from beginning and there are transformations which are not accepting using Direct Query so i cannot use direct query. 

Is there anyway we can refresh the data manually for power bi report server or any other workaround solution.

Thanks in advance.

Thanks,

 Binay