Embed Power BI Reports into Access Forms

[jg_1981]

Hello everyone!

I need some help. I'm developing an MS Access Project, and I need that a specific form uses a WebBrowser Control. That's the easy part.
The hard part comes next: I need that WebBrowser Control shows me an webpage that have a Power BI report (it's embedded in a sharepoint online site). I done all that but when I open the form MS Access gives the following script error:

"An Error Has Occurred in the Script On This Page." The power bi report don't appear.

How can I turn this around?

Thank you for your help.

Best regards,

Joaquim Guedes

 

[GPGeorge]

Try adding this line to the Load event of the form where the web browser control is embedded:

Me.YourembeddedPBIWebBrowserNameGoesHere.Object.Silent = True

 

[isladogs]

I've not tried your exact situation but in similar circumstances with a Web browser control script error, it is often solved by changing the IE emulation mode to IE11 or Edge.

See point 4 in this thread

How to fix Google maps display issues in Access web browser control

A few months ago, I experienced issues displaying Google maps in an Access web browser control, The issue was that the map loads perfectly for a second or so followed by a pop up window advising you to switch off compatibility mode. When this is dismissed, all of the map except the outer edge...

www.access-programmers.co.uk

 

[jg_1981]

Try adding this line to the Load event of the form where the web browser control is embedded:

Me.YourembeddedPBIWebBrowserNameGoesHere.Object.Silent = True

Thanks GPGeorge for your help. The message error does not appear any more but the Power BI report does not show up. I just send you a image to demonstrate the situation. I'm I doing anything wrong? Thanks for for your help.

 

[GPGeorge]

Well, guess what. It doesn't appear for me either. The last time I looked at that form a few weeks ago it was okay. I think maybe "something changed" again. Time for new research it seems. Unfortunately, the rest of my afternoon is booked.

 

[GPGeorge]

I made a little progress, but still not totally resolved. I changed the URL to only go to the PowerBI environment, without specifying a specific PowerBI chart. This time I did get another message. I "upgraded" but that makes no difference. I'm taking off for today. Maybe fresh eyes will help in the morning.

 

[GPGeorge]

At this point, I'm convinced Microsoft recently changed something in PowerBI that is now blocking the web browser control in Access.

You can review this site for additional information. Also review the link Colin posted earlier.

I'm going to report this as a possible bug to MS.

 

[jg_1981]

At this point, I'm convinced Microsoft recently changed something in PowerBI that is now blocking the web browser control in Access.

You can review this site for additional information. Also review the link Colin posted earlier.

I'm going to report this as a possible bug to MS.

Hello GPGeorge. Thanks you for your help. I hope I can find some solution to this problem.

 

[GPGeorge]

I was able to report this to the Access team at a recent conference, but I have not a lot of confidence it'll get addressed as it appears to be a problem with the PowerBI side of things, out of their control.