AtlasPublicPolicy / power-bi-embedded

Use Power BI Embedded to embed dashboards, reports, report visuals, Q&A, and tiles in your WordPress website.
GNU General Public License v3.0
49 stars 34 forks source link

Reports do not display anymore #15

Closed egdevteam closed 4 years ago

egdevteam commented 4 years ago

In Chrome, Safaro, and Edge, reports do not display anymore. The frame where the report is supposed to be appears, but it says This content is not available. Learn more about Power BI.

If I refresh the page a bunch of times, some buggy version of the report may eventually load.

It seems to work fine in IE, and in Firefox it works sometimes, but fails other times.

Other users are experiencing this as well: https://wordpress.org/support/topic/problem-displaying-reports/

This has been happening since sometime late last week. My users started reporting it over the weekend.

npnigro commented 4 years ago

We are currently unable to reproduce the issue here. We could see it this afternoon but not now. Any one still seeing it? If not, it looks like it was an issue on Microsoft’s side.

npnigro commented 4 years ago

After additional troubleshooting, we could reproduce the problem but it is intermittent. It appears that a bad token is being retrieved causing the dashboard to not load. If a caching plugin is used (e.g., WP Rocket), then this problem can persist for an extended period. It also appears that the browser cache might be playing a role.

ryanblenis commented 4 years ago

FYI, it appears that we were able to get rid of the issue by removing the localeSettings object in includes/class-power-bi-shortcodes.php on line 169-172.

At least for about ~75% of the page loads, whereas with it in there, we were at 0%.

alwyng commented 4 years ago

We are experiencing this issue mainly in the latest Chrome release (78), IE very little and Firefox not at all.

Chrome gives this message: image

ryanblenis commented 4 years ago

It's definitely got to be something on the MS side, even loading the parameters into the playground results in a 401 error the first 1 or 2 times, then appears to load normally. No idea why removing the localeSettings makes it work most of the time...

alwyng commented 4 years ago

Has come up on the Power BI forums as well: https://community.powerbi.com/t5/Developer/Embed-report-fails-to-load-intermittently-with/td-p/850980

alwyng commented 4 years ago

Also removed localeSettings and hit rate also went up. Not perfect yet unfortunately.

npnigro commented 4 years ago

Thanks for sharing. Are these reports hosted on premium or shared capacity? Also, has anyone reported this to Microsoft? We are still investigating on our side to see if there's anything we can do.

alwyng commented 4 years ago

We host on Premium embedded capacity. Not sure what route to take to report to MS.

npnigro commented 4 years ago

Good to know. How about creating a support ticket through Power BI's website? https://powerbi.microsoft.com/en-us/support/pro.

ryanblenis commented 4 years ago

I logged an issue with MS and a couple hours later was on the phone with a couple MS guys. They took a bunch of debug info and to my shock a couple hours later they called back and said they pushed through a fix. Haven't seen the issue again yet!

npnigro commented 4 years ago

Great! Are you using the current version of the plugin? Just want to confirm you didn't make any modifications.

ryanblenis commented 4 years ago

I do still have the modification to remove the localeSettings object, but we'll be testing putting that back in shortly.

npnigro commented 4 years ago

OK, please reply back here with your results!

alwyng commented 4 years ago

We've tested putting back localeSettings and all works fine. We're on plugin version 1.1.0

Thanks for all the help everyone!

npnigro commented 4 years ago

Good to know. We have some small changes from @webdev312 that we'll be merging into a future release. It could improve performance. I'm closing this one out.