Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
TerenceL
Frequent Visitor

Power BI embedded in Salesforce (Error: Contain isn't available)

Hi,

I followed below URL to embed PowerBI dashboard in the Salesforce VisualForce page. I successfully embedded my PBI visual into the Salesforce visualpage and I can view the PBI visual perfectly from the Salesforce. However, non-Power BI users(Salesforce user received below error message.

Error.PNG

Below are my configuration:

1) I used Embed Power BI content with service principal and an application secret.

2) I am Power BI Pro user.

3) All our non-PBI license users are in same organization and using the same Azure Tenant AD.

4) I have granted all our users as members in the PBI workspace and share my report to all of them but still they cant view the contain.

https://powerbi.microsoft.com/en-us/blog/embedding-a-power-bi-report-into-salesforce/#comment-309798...

I appreciated if someone can help me.

Thanks,

Terence

4 REPLIES 4
Jayendran
Solution Sage
Solution Sage

Hi @TerenceL ,

 

Are you using any RLS in your report ? if so did you add all the users in the RLS Security ?

 

You can also try debugging from the browser using F12 (Developer Option) to get some insights about which call gets failed and the reason.

Thank you Jayendran for your quick respond.

 

No, we didnt use any RLS for our report.

 

Looks like every one with Power BI pro licensed can view the report from VisualPage successfully but other (without PBI pro license) received this error message. Looks like something not set properly between PBI apps and PBI services?

Hi @TerenceL ,

 

I think you are using User owns data approach for the pbi embedding. Using this approach the embed token and the report can be viewed by the end users licensing, meaning your end users should have a proper powerbi pro licenses.

 

if you don't want to use this approach you can have dedicated service account/spn to embed your report. with this the end user license is not really needed. This is called Apps Owns Data

Thanks Jayendran.

I followed Apps Own Data steps provided as above and now even I(with PowerBI Pro license) received the Content isn't available. I have granted the service principal as admin in the respective workspace.

 

Below is my embed config:

 

var embedConfiguration = {

type: 'report',
tokenType: 1,
id: selectedReport,

embedUrl: 'https://app.powerbi.com/reportEmbed',

settings: {

filterPaneEnabled: true,

navContentPaneEnabled: true

}
};

 

powerbi.accessToken = '{!PBIaccess_token}';

var element = document.getElementById('myReport');

var report = powerbi.embed(element, embedConfiguration);

 

PBIEmbeddedError.PNG

 

Also, it worked perfectly from "PowerBIEmbedded_AppOwnsData.sln" with my application secret.

 

From the F12, I received below error message.

api.powerbi.com/metadata/cluster:1 Failed to load resource: the server responded with a status of 403 ()

 

Thanks again for your quick respond. 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Solution Authors
Top Kudoed Authors