cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sb_powerbi Regular Visitor
Regular Visitor

Power BI dashboard integration with Visualforce page in Salesforce

  Greetings Team,

 

We need some suggestion on integrating  Power BI dahsboards with Visual force Page in Salesforce instance, based on my initial analysis we can able to embeded the power bi into Sales force by using steps metnioned in the below blog.

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

 

We need some comfirmation on the Power BI features supported after integrations

 

  1. Is Row level secuity feature will work same as its in Visual force page after integration ?
  2. Power BI Direct query mode will support for the integrations? and data refresh .

It would be very helpful for us for the suggestions on the above questions .

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Power BI dashboard integration with Visualforce page in Salesforce

@sb_powerbi,

Firstly,  it is possible to apply row level security to the report for end user, for more details, please take a look at  this similar thread.

Secondly, does your dataset contain salesforce data source? If so, DirectQuery mode is not available in this case. However, if your dataset contains other data sources that support DirectQuery mode, you are able to integrate the report to visualforce page in salesforce.

Moreover, you can achieve the refresh requirement by using  Data Refresh APIs.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-yuezhe-msft
Moderator

Re: Power BI dashboard integration with Visualforce page in Salesforce

@sb_powerbi,

After you apply RLS for your dataset, as long as the user have no issues viewing his own data in Power BI Service, he should also see the same data in the embed report in salesforce.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Power BI dashboard integration with Visualforce page in Salesforce

@sb_powerbi,

Firstly,  it is possible to apply row level security to the report for end user, for more details, please take a look at  this similar thread.

Secondly, does your dataset contain salesforce data source? If so, DirectQuery mode is not available in this case. However, if your dataset contains other data sources that support DirectQuery mode, you are able to integrate the report to visualforce page in salesforce.

Moreover, you can achieve the refresh requirement by using  Data Refresh APIs.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sb_powerbi Regular Visitor
Regular Visitor

Re: Power BI dashboard integration with Visualforce page in Salesforce

@v-yuezhe-msft

Thank you so mcuh for response

 

My Power BI dashboadrd connected to Sql Server not SalesForce.

Business users would like to see the Power BI dashbord in Visualforce Page, As users compatibale with SalesForce.

 

We are planning to embedd report to salesforce so bit confused on row level security will support same as Power BI service .

 

Moderator v-yuezhe-msft
Moderator

Re: Power BI dashboard integration with Visualforce page in Salesforce

@sb_powerbi,

After you apply RLS for your dataset, as long as the user have no issues viewing his own data in Power BI Service, he should also see the same data in the embed report in salesforce.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sharad3010 Occasional Visitor
Occasional Visitor

Re: Power BI dashboard integration with Visualforce page in Salesforce

I am trying to integrate PBI into Salesforce. But i am getting an error "AADSTS50011: The reply url specified in the request does not match the reply urls configured for the application: '2XXXXdab1-aXXa-1abb-XXXX-89XXXXXXXX61e4'".

 

Any help on how I can resolve this error? 

 

I have followed the steps as mentioned below:
https://powerbi.microsoft.com/en-us/blog/embedding-a-power-bi-report-into-salesforce/

 

In this, when we are registering our app, what should we enter in Home Page URL?