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
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
Employee
Employee

@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,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
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,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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.