Forum Discussion
Power Bi embedded and External User
Hello,
I don't found a clear answer to my questions so I hope some could point me in the right direction. I would like to use power bi in a web app for user which are external to my compagny.
I understand there are 2 options :
-Publish to web
-Power BI embedded
I need security so the first option is not possible.
I am exploring how work power BI embedded and I was wondering what source does it support. I need security so the external user must connect to the report their are allowed to see and only see their data. If I am right the access will be secured within the app workspace and security for the data by the rls.
I have data on premise, I can import in Power BI and I will have an Azure Analysis Service Model. Does embedding support in directy query, live connection or import mode ? What is the best solution for embedding ?
Thanbks for your help,
Thanks for your help,
Hi Anonymous
I think to better explain it, it can be explained in the following way.
You would develop and configure your report as you would do, if it was being used in the Power BI Service. So this includes how you connect to your data. In your case using Azure Analysis Services would mean it is a DirectQuery
Once you have done the above, as part of the embedding, is where you would use the API calls to call this report.
And then finally if the user is external, but being authenticated by your own custom application and authentication, you are then passing through a token to Power BI. So that would work.
3 Replies
Hi Anonymous
You are on the right track and as far as I am aware when you use Power BI Embedded within your own application, you will be able to pass through a token which will tell Power BI to which Role they belong to and apply the RLS.
Your application would handle the users authentication also.
There are some great video's by Guy in a Cube which has details around what you are trying to do: Guy in a Cube - YouTube
With regards to the data sources, you would still have to author and deploy the reports as you would currently do in the Power BI Service. This includes configuring the data sources, connecting to the Gateway and or refreshing of the data.
And finally if you are embedding it into your own application you can use the new Azure Power BI Embeddes scenario's which is great for pricing and scalability: https://powerbi.microsoft.com/en-us/blog/power-bi-pro-power-bi-premium-flexibility-to-choose-the-licensing-best-for-you-and-your-organization/
thank you GilbertQ for your answer.
I still have some concerns about the data source.
So I understand you well, for the on premise data it is possible to configure a gateway to use direct query or import to refresh.
If I want to use live connection on a model in Analysis Services in Azure, is it also possible ? If I have role and external user assigned, will it work ?
Thanks for your help,
Hi Anonymous
I think to better explain it, it can be explained in the following way.
You would develop and configure your report as you would do, if it was being used in the Power BI Service. So this includes how you connect to your data. In your case using Azure Analysis Services would mean it is a DirectQuery
Once you have done the above, as part of the embedding, is where you would use the API calls to call this report.
And then finally if the user is external, but being authenticated by your own custom application and authentication, you are then passing through a token to Power BI. So that would work.