I created a VisualForce page that pulls data from an embedded Power BI report and shows it in an iframe. For a regular SF user, it works fine and it is even interactive like any normal Power BI Report.
Here's a screenshot of an extremely simple example:Here's the complete code of the VisualForce page:
<apex:page standardController="FCC__c" showheader="false" sidebar="false">
<apex:iframe src="https://app.powerbi.com.[EmbedURL]$filter=FCC/FCC eq '{! FCC__c.SAP_Id__c }'" height="1000px" width="100%" frameborder="0">
</apex:iframe>
</apex:page>
This is literally the last step I need to achieve a major milestone.
I'd really appreciate it if somebody could help me out here.Thanks a lot in advance.
답변 2개
Hi Swetha,Thanks a lot for looking into it.The report does actually show up, and it shows the correct result. But what is weird is that I cannot click on the Power BI report itself. The entire area where I put the VisualForce page has a transparent layer on top of it. The screenshot below shows that the mouse becomes a pointer even when it's not over the report itself.This layer prevents me from clicking on the Power BI report. Instead, it wants to open the underlying VisualForce page, but that makes no sense. It tries to open this URL:https://ourdomain.force.com/BusinessHubTest/s/BusinessHubTest/FV_FCC?id=a0D5W0000009QxjUAEHowever, I don't want to open the VF page (after all, it's just a container for an iframe). The customer should just be able to interact with the Power BI report.This DOES work for regular users in Salesforce (our staff), but for community users, I get this weird layer that keeps them from using the Power BI report.So to your point, there is no error message because after all, the Power BI report does show up, I just can't click on it.I could really need a hand here...
