topic Re: embedded-expiration/timeout issue? in Developer

embedded-expiration/timeout issue?

ThomasDay — Tue, 16 Aug 2016 15:47:24 GMT

Hello fellow Embedders,

I have a site that is working great...until it sits for 3 minutes or perhaps 5. Then I get this when I click another tab in the report.

The token expiration is set for 1 hr, btw, so I'm not sure what's up. A refresh sets things straight. What's to be done here..any ideas?

Thanks,

Tom

Re: embedded-expiration/timeout issue?

wabreza — Tue, 16 Aug 2016 15:52:00 GMT

If you click on one of the "See Details" links do you get an activity or request id GUID? If so please share. I'll be able to look up the root cause of the issue with this information.

Re: embedded-expiration/timeout issue?

wabreza — Tue, 16 Aug 2016 15:58:37 GMT

If this does come down to being a timeout issue you can try one of the following:

In a server generated app you can get around this by generating a token for each render of the page.
In a single page app (SPA) - one option is to set a client-side timer on your page/view that is shorter than your token expiration. At that point you can regenerate the token and reload the report passing in the new access token.

Re: embedded-expiration/timeout issue?

ThomasDay — Tue, 16 Aug 2016 16:23:00 GMT

@wabreza Here are the tech details of the error. Let me know what you see as a root cause.....and thanks, Tom

Re: embedded-expiration/timeout issue?

wabreza — Tue, 16 Aug 2016 16:37:14 GMT

Its a 403 which is an access issue. What is the expiration of your generated tokens? Is the expiration you are setting inline which the timeout you are seeing in the embedded report?

Re: embedded-expiration/timeout issue?

ThomasDay — Tue, 16 Aug 2016 16:57:56 GMT

@wabreza No the token timeout is set to 1hr. We've had 403's forever to be honest. They happen when the site has been sitting and I click on another tab in a report. Time is 3-7 minutes, but not always. Sometimes longer...but seldom a non-issue. We have 4 embedded reports up behind our paywall. The tabbed ones are the main issue. There are lots of filters and data...and the app is really useful and fast. Very good market reception. Can't say I recall a non-tabbed one giving me trouble but I'll look more carefully going forward. Now that we're live and have users starting up...we're paying more attention in general. Tom

Re: embedded-expiration/timeout issue?

wabreza — Tue, 16 Aug 2016 17:27:26 GMT

You mentioned you have 4 embedded reports. Are they all embedded within the app at the same time? Or are they embedded seperatly in different views?

If they are all embedded in the page at the same time I'm thinking of some potential issues where their may be some shared state (cookies/local storage) that have the potential to be shared accross the iframes.

Re: embedded-expiration/timeout issue?

ThomasDay — Tue, 16 Aug 2016 18:33:57 GMT

@wabrezaThey all are called via the same iFrame. We have a wordpress site where the page behind our paywall has a side menu navbar where you pick the report--and it's retrieved via it's id from the collection/workspace. There is seldom an issue as it's retrieved...just when it's been sitting and I click a report page tab or sometimes just click a slicer on the idle page and sometimes there are no problems.

This morning's picture of problems had a single chrome tab open to our site iframe and the x's appeared when I clicked a powerbi report tab to switch pages.
The picture I sent to this topic, had two chrome tabs open to our site--and the second chrome tab iframe presented problems when I clicked a powerbi report tab to switch pages.
BTW, the first chrome tab iframe has not shown problems at all and has been sitting for quite some time.

Is there something I can do to understand any shared state issues?

Tom

Re: embedded-expiration/timeout issue?

wabreza — Tue, 16 Aug 2016 18:35:07 GMT

OK - So to be clear your app is re-using the same iframe to load multiple reports. Correct?

How are you loading the reports? Are you manually making the postMessage(...) calls or are you using the JavaScript SDK?

Re: embedded-expiration/timeout issue?

ThomasDay — Tue, 16 Aug 2016 19:15:37 GMT

@wabreza I just called the embed site guy (I'm the powerbi guy) and he says "every time a new menu item is called, I load a new page and a new token." So, I don't think that's the same iFrame in this sense.

And using the JavaScript SDK...

Thanks for patience on this...

Re: embedded-expiration/timeout issue?

ThomasDay — Wed, 17 Aug 2016 14:00:45 GMT

@wabreza Are we out of pursuable options as you think about this? I'm not sure how we'd pursue/fix conflicts in the shared state. Do I need to put in a ticket of some sort? Tom

Re: embedded-expiration/timeout issue?

wabreza — Wed, 17 Aug 2016 15:07:25 GMT

Can you put together a small sample app that reproduces the problem? I haven't been able to reproduce your issue locally.

Re: embedded-expiration/timeout issue?

ThomasDay — Wed, 17 Aug 2016 15:57:06 GMT

@wabreza That's a great next step. It may take awhile as we're in active dev of features etc as we launch, but that seems like a good exercise for a lot of reasons. Tom

Re: embedded-expiration/timeout issue?

ThomasDay — Wed, 31 Aug 2016 19:29:01 GMT

@wabreza In the interim--I thought a short video of the failure would be helpful to the community and perhaps allow you to get further along in deciphering what is happening when our site "fails" when inactive for a short while (3-5 minutes). To recap, each report loaded from a menu gets it's own page and token and the timeout period is set to 1 hour. We are embedding using Javascript in wordpress. Jesse will post the embedding code on git hub to benefit the opensource community that is embedding powerbi models. Here is a link to the video in dropbox which I've set to share for 7 days. Hopefully you'll get a flavor for what's happening and can perhaps direct us to more inquiry or a path to eliminate our issue. Tom

PS: there are no report level filters--all slicers/filters are contained on a page. Not that it matters...the x's appear for report level filtered pages as well.

Re: embedded-expiration/timeout issue?

ThomasDay — Wed, 31 Aug 2016 19:52:41 GMT

@wabreza finally, here is the embedding code on github. The `getEmbedTokens` method makes it look as though maybe we’re reusing tokens--we thought about that as an option at one point, but we don’t save tokens across requests, so in reality the way it works out is that a new token is generated for each request. We should probably pull that out for the sake of clarity. You'll most likely want to look at the `includes/powerbi.inc` file

Re: embedded-expiration/timeout issue?

arujindal — Tue, 20 Feb 2018 10:38:05 GMT

@ThomasDay Did you get a solution for this? We are facing similar issue where we are using Sharepoint PowerBI webpart and embedding the reports inside that webpart. After navigating to another tab in report 403 error pops up.

Re: embedded-expiration/timeout issue?

arujindal — Tue, 20 Feb 2018 10:42:18 GMT

Re: embedded-expiration/timeout issue?

arujindal — Tue, 20 Feb 2018 11:04:27 GMT

@ThomasDay did you get resolution of this issue. we are facing similar issue with PowerBI webpart in SharePoint site. Reports working fine in PowerBI but erroring out in SharePoint site.

Re: embedded-expiration/timeout issue?

ThomasDay — Tue, 20 Feb 2018 13:59:16 GMT

@arujindal Actually I never got an answer from the forum. I did get to the Microsoft person who built the github code for embedding V1. (You'll notice this is quite an old post). The end of this story was that there is a php command in the embedding code we used that sets the timeout period and it's measured in seconds not minutes, so turns out se had set the timeout to 60 instead of 3600 for a one hour timeout period.

I really don't know how the sharepoint embedding works, but that's what did it for us.

Hope that helps,

Tom