cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meddojeddo
Helper IV
Helper IV

Is is possible to a run a report on demand without caching in the browser?

I am running a report on the report server in the browser, and i am running into the issue that when the data is updated, the newly updated data is not immediately visible in the browser because of caching. This can be solved by creating a cache schedule, but is it possible to turn of caching so the data updates when the report is run?

7 REPLIES 7
pranit828
Community Champion
Community Champion

Hi @meddojeddo 

Yep, it is possible.

You have to use direct query or live connection.

 

Direct Query -

Limits your ability to manipulate data in the Desktop (removes the Data section)

Leaves the data in the SQL database

Is "live", no need to schedule a refresh (In the Service)

 

Check the below video for more details.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

@pranit828 I believe this report is using directquery, is there a way I can verify that? I do have the data section though. However I am not on the service, I have uploaded this report to the report server, but I am editing it in Desktop.

HI @meddojeddo 

Why not give it a try with a simple table and a slicer. Don't schedule a refresh and on change of the slicer it should get the data from database.

It worked for me although it was bit slow for the turn around time and the volume of data I was using; so, i had to do it through live connection using Python and lambda.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

@pranit828 ok so my report is in import mode. However the issue is that when I upload a report in directquery mode to the report server, I get an error saying "Cannot Connect to the Analysis Services server". So I think it needs to be in import mode. Is it not possible to run a report in import mode in the browser without a cache so that the data is up to date?

DataZoe
Microsoft
Microsoft

@meddojeddo You can pin the individual visuals to a dashboard (then use that), and then it will keep itself updated as soon as the new data is detected. 

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

@DataZoe but this is only possible in a workspace and not on the report server, right?

@meddojeddo Ohhh, I missed that part of your original question! Yes, that's how it works for a report in a workspace. I am not sure for the report server -- sorry I can't offer anymore help.

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors