Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
binayjethwa
Helper IV
Helper IV

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

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

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.