Embedding with Power BI - What's the difference?

Рет қаралды 117,886

Күн бұрын

In this video, Adam looks at the differences between the two embedding options with Power BI. We get a lot of questions about what steps need to be taken, what Capacity SKUs are needed and where can they be used.
Power BI App registration
dev.powerbi.com/apps
App registration - Grant Permissions step
docs.microsoft.com/power-bi/d...
Power BI steps to get Auth token from Azure AD
docs.microsoft.com/en-us/powe...
Azure AD doc for REST API calls to get auth token
docs.microsoft.com/en-us/azur...
LET'S CONNECT!
Guy in a Cube
-- guyinacube.com
-- / guyinacube
-- / guyinacube
-- Snapchat - guyinacube
-- / guyinacube
**Gear**
Check out my Tools page - guyinacube.com/tools/

Пікірлер: 116

@mswcap 3 жыл бұрын

Thank you Adam! Awesome explanation, much appreciated. You really know your stuff AND also know how to share it in an understandable way. Respect!

@TristanMalherbe 6 жыл бұрын

Very very clear - Thanks Adam. WIll help a lot of my clients :)

@alexpeles5107 4 жыл бұрын

Excellent explanation! Well done Adam

@mihaelailieva4841 3 жыл бұрын

WOW! Amazing explanation!

@Sivakumarpoornima 3 жыл бұрын

Interesting Adam . Thank you so much for sharing

@shankarchintada 5 жыл бұрын

Very good information.

@indavisual 5 жыл бұрын

Hi Adam, Do you know if PowerBI could be embedded into a Unity 3d application? Or if a Unity application could be embedded into a PowerBI tile/report? By the way, great videos Adam. Very clear and concise. :)

@asankaboteju5941 11 ай бұрын

Great demo, Thanks! I have quick clarification. Is there a possibility for a user to download the report to excel/pdf from the Web App Integrated Embeded Report View (Not Directly from Power BI Report Dashboard/Console)?

@patenik2 6 жыл бұрын

Very well done.. Great work..

@GuyInACube 6 жыл бұрын

Thanks for watching Nikunj!

@idanwolf9041 6 жыл бұрын

Is it also on premise?

@Lead2345678 6 жыл бұрын

I learn a lot here - thanks guys! I would REALLY like to see an example of how to use Power BI Embed with SharePoint online. My organization has O365 Enterprise E4 and Power BI Premium. I know I can embed a Power BI report in SharePoint modern pages, but I need a solution that works with Premium capacity, I want more control over what gets embedded in my SharePoint sites and I don't use modern pages. Any chance you could do an end-to-end walk-through of the whats and hows to accomplish this?

@bhavithareddy7095 5 жыл бұрын

Hi Adam ,Thanks a lot for the information its really helpful , can we handle pin to dashboard option in power bi embedded application as we have the same option in power bi service if yes can you help me out

@unclegaryh 3 жыл бұрын

Thanks! So.. can we embed a chart/dashboards from Power Bi Premium onto a external customer facing website and external users can access it?

@swapnab4453 3 жыл бұрын

Hi Adam.. Is there a way to initiate PBI refresh and have that integrated into the daily load, which reduces the manual work of refreshing one report at a time. Thank you.

@MrErolyucel 6 жыл бұрын

Adam, thanks for all your efforts. Please show us how to embed a report tile to a word or even to a powerpoint document and keep it live. You are the last chance, tried my best to find it out, but no luck.

@GuyInACube 6 жыл бұрын

The only way I'm aware of for something like that is to use a 3rd party plugin like DevScopes Power BI tiles.

@vishalpawashe9487 4 жыл бұрын

Hi Adam - A quick question on Capacity in Power BI: Is there a limit on the number of calls we make using the API to get the access token. We have embedded few reports into our Web Application and getting the access token from Power BI GET REPORT API. Had a call with MS and got to know that there is a limit on the number of API calls if we don't have a capacity purchased

@anmolganju1864 6 жыл бұрын

Explanation with an example will be the best possible way to explain... (Just a thought..you did explain that beautifully but through an example would be best for this.)

@dagg497 6 жыл бұрын

Anmol Ganju i wished the same. Took me 140 hours over 2 weeks time to get to a working PBI embedded app with all the lacking documentation and Deprecated embed service.

@anmolganju1864 6 жыл бұрын

Do you know how can I pass values inside the html page so that my report should be sorted A/Q.

@dagg497 6 жыл бұрын

Anmol Ganju When you embed your report you select what API call you want to make. There are several ways to call a report: Q&A, edit mode/view/create mode. In the december or januari update Q&A was enabled per graph tile but maybe only in power bi desktop. Guaranteed functionality for Q&A and Power BI are for Dashboards, not Reports

@anmolganju1864 6 жыл бұрын

Can you provide any documentation where I should look into, I want to pass external date filters so that report gets rendered according to those values, How and where should I start.

@dagg497 6 жыл бұрын

Anmol Ganju Can you give me more details. Are you talking filters or Q&A filter both can be outside of the embedded Iframe. You want a special custom filter menu im guessing?

@AHMEDALDAFAAE1 4 жыл бұрын

This is ultimately the most wonderful explanation of Power Bi Embedded I ever seen. Thank you guys

@robertgenesis9278 2 жыл бұрын

Sorry to be offtopic but does any of you know of a way to get back into an Instagram account?? I was dumb forgot my login password. I love any assistance you can offer me!

@robertrudy4788 2 жыл бұрын

@Robert Genesis Instablaster ;)

@robertgenesis9278 2 жыл бұрын

@Robert Rudy i really appreciate your reply. I found the site thru google and Im waiting for the hacking stuff atm. I see it takes a while so I will reply here later with my results.

@robertgenesis9278 2 жыл бұрын

@Robert Rudy It worked and I actually got access to my account again. I'm so happy:D Thanks so much you really help me out !

@robertrudy4788 2 жыл бұрын

@Robert Genesis Happy to help :D

@yumyumhotsauce1 6 жыл бұрын

Hi Adam, Gr8 vid as always. if my org has several desktop developers, potentially a medium report viewer base and likes the PBI portal interface. What's the best option I have? I want to avoid creating 100 individual accounts just for reading. All users within our organization can view our reports. Wanted to see if I can just buy capacity for reader usage and PBI Pro licenses for dev? thanks for any guidance.

@JoshOsif 5 жыл бұрын

In the ever-changing MSFT space, is this at all relevant for D365 for Finance and Operations v8.0.... if not, any links to another great video or help docs? I've got some cool and helpful reports built that we'd like to make visible to our client. Thanks!

@komalgupta5448 10 ай бұрын

HI Great video. Can you do powerbi embedding using service principal as well?

@duarteraminhos2078 4 жыл бұрын

Hello Adam, thank you for all the content and the time you guys put into delivering valuable explanations. I'm trying to embed to customers, just have a question that can be determinant in advancing or not with the solution. Can you tell me if you can assign a Premium capacity (Px) to embed for your customers or is it always necessary an E capacity to do so? Despite the answer keep up the great work, it's hugely useful for BI users so thank you for that!!

@gazzam6344 Жыл бұрын

This is answered at 9:31 You can use either Premium capacity or "Azure" Embedded

@duarteraminhos2078 Жыл бұрын

@@gazzam6344 Thanks for the reply, I know but when I asked the question (2 years ago) I was working with a company that add to purchase an E capacity despite having a P capacity, cause it was no longer possible to use the P to use the Embeddded. So I just wanted to clear that out since it seems to be quastionable

@ravishankar0612 6 жыл бұрын

I am trying to create an embedded report following the steps in your other video, creating embed token. However I am getting an error {"accessing_ws_metadata_exchange_failed: Accessing WS metadata exchange failed"} in the AcquireTokenAsync() method - Not sure what I am doing wrong.

@mustafabiviji00711 6 жыл бұрын

Hi Adam, Thanks for the video. Can you also address how embedding would work for on-premise report server (not Premium) but Power BI Report Server got with SQL Enterprise & Software Assurance?

@gahhef 5 жыл бұрын

Has anyone been able to figure out if similar capability are available for on-premise?

@kjaypark 4 жыл бұрын

Where are the "links down below" that you are talking about?

@siddhi166 3 жыл бұрын

Can we embedd PowerBI alerts feature?

@anildeep1988 6 жыл бұрын

Hello guys could you help me for custom matrix visual where I can edit cell level color

@anvarp7000 3 жыл бұрын

Hi Adam, Thanks a lot for the clear explanations. In my case, I have to go with power BI embedded solution. I am planning to purchase , A power BI pro license and A sku for power BI embedded . Do I need to purchase power BI premium Instead of power BI pro If I need following features 1.Expecting 10 GB of data as part of power BI solution 2.Incremental Refresh’s is required 3. 24 Refresh in a day is required 4.Power BI gateway -Standard mode 5.Embed paginated reports in your own application for your customers

@Mgiusto 5 жыл бұрын

Adam, I have a problem trying to embed a Power BI item in an application for customers because my company's AD requires 2-factor authentication when connecting outside of our network. How would you go about resolving this issue? Thanks!

@michalpoterek5492 3 жыл бұрын

Hi it would be cool to see RLS example for embeded power bi :)

@youtubieee 4 жыл бұрын

excellent video, thanks! I do have a question still. Imagine a web app based on SPO. Users login to the app with their SP accounts. Now they all happen to have PowerBI pro license too. I want to embed reports in the web app, but I don't want them to get prompted for logging in to PowerBI or anything else after they logged in to the app. Is there a way to use the token that is generated when they log in to the web app (which is used for working with SP content) to get the embedding done? otherwise they'll be paying for pro licenses and also the capacity. Thank you in advance :)

@quentinwinisdoerffer421 3 жыл бұрын

Hey there, such an old video and still don't get it all... Is there a significant saving of costs if passing from Pro users to everyone internally to Azure capacity to embed content so internal free user can consume content? Thanks!

@kurtpetteloot6105 4 жыл бұрын

Very valuable content! But, this video was posted almost 2 years ago. What has changed since? Is it still up to date?

@GuyInACube 4 жыл бұрын

Thanks for watching Kurt! This main items are still there. There are a few other options. I actually have this on my list to revisit. It will be done this month. Secure Embed being the biggest update to this as it provides an authenticated approach with a no-code/low-code option.

@amrbakoor3434 4 жыл бұрын

Hi I am wondering if there is an option to let my application users create power BI dashboard or reports inside my application Thanks

@manojcherian4832 3 жыл бұрын

Hi, Can I embed Power Bi with Oracle web forms application?

@suryatejatammana2671 3 жыл бұрын

Sir, I am having a doubt that if when i have granted permission for the registered app. I am trying to get access token using master user approach and i have multi factor authentication enabled on the user. Still the request would be successful because i have granted permission or it will give error back

@rafaelsampy4406 4 жыл бұрын

HELPP me please!! Secure embed code is not working in HTML Viewer bookmark in Power BI. Solutions??? Thanks!

@anmolganju1864 6 жыл бұрын

How can I embed a Report with RLS for the external users??

@jonathanwhittenton2252 6 жыл бұрын

There a multiple ways of doing this, usually based on the data source you are using in the report. On the basic example, in a report that has imported data you can set up regular DAX RLS Roles and use the USERNAME() function. Now when calling to get the Embed Token you can specify the username and roles to be used for the embedding.

@3statesnetllc Жыл бұрын

Stupid question since MS wasn’t of use. The per hour charge on the embedded is that per hour in use or per hour available?

@manishkumbhkar Жыл бұрын

How can we get token

@ravitejak9414 8 ай бұрын

HI Adam Is there a possibility that scheduled refreshes set in Power bi services will also work for the public Embed report like if refresh is happened at 2:00 pm in Power bi services then would it reflect automatically in the public Embed report also or else we need to copy the public embed url and paste it again ? Please answer .

@pankaj78784 5 жыл бұрын

Adam, good video... At 3:28 you mention we have to use AAD app type as Native App... Why? Why not AAD app type as web app?

@pankaj78784 5 жыл бұрын

At 4:49, you mentioned that consent permission is not required for Native App so it better to use the Native App. But still not clear as the master user will have always have consent for embedded why not use web app?

@chrisweis 5 жыл бұрын

At 9:00 Adam says "free users must be added as members of that workspace in order to have permissions to get into content within that workspace"... but don't they only need to be granted access to the published App or a shared report/dashboard? They don't need to be full members in the workspace, right?

@GuyInACube 5 жыл бұрын

You are correct Chris! That change happened after this video came out. I put this video on the list to update.

@cesargoyzuetameneses542 3 жыл бұрын

What is the difference between embedded and apps?

@coderider3022 Жыл бұрын

How valid is the embedded approach ? I’m reviewing my companies approach based on the assumption embedded tokens are security risks but I think this is a valid approach.

@jonathanwhittenton2252 6 жыл бұрын

How is the capacity requirement enforced for the Power BI Embedded example, once it is moved to production? The only thing I can think of is that if there is no capacity applied to the app workspace, then there might be a degradation of performance at a sooner point than if it had capacity. So if a production application did few page renders, then you could get away with not having capacity.

@GuyInACube 6 жыл бұрын

Performance degradation is one. Also, it is monitored on our end. So, you may get a nastygram at some point :)

@johnmatta9577 6 жыл бұрын

Adam I normally just use the embed code that's generated from Power BI service and just put it in either Share Point or our intranet and it's all working fine...how that is different from what you've described in the video?

@pradeepkailasa 6 жыл бұрын

John Matta how is your intranet site working?

@visheshjjain 6 жыл бұрын

When embedding PBI content into my own web app, how often is the data refreshed by PBI?

@AlbertoGastaldo 5 жыл бұрын

I think it depends on your policy. If data are into your dataset (import mode) you need to schedule refresh If you are live-connected to a SSAS, refresh must be done @ server side by processing your model.

@cafenona 4 жыл бұрын

Thank you for the video, now bit more clear.I registered your channel. I have other question. when report is published, workspace name has owner access. Does this mean that everybody in this workspace O365 group has owner access ? we do not need to grant access separately but they have access R&W? if this O365 group has 400 people, does this mean 400 people can modify my report ?

@GuyInACube 4 жыл бұрын

It depends on the role you assign to them. There are four roles. If you only want them to be read/consume make the viewers. See this doc for more information docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces.

@JovanCosta 4 жыл бұрын

I think there are a lot of updates since the release of this video. it would be great if you guys, record a new version of it. at 8:50 you said that premium capacity is required to allow free users in a workspace. In the next sentence you said another requirement of premium... I don't believe this is the case anymore.

@chrisUyehara 5 жыл бұрын

Does Power BI Report Server include or have the capability of Power BI Embedded?

@hariviggu 4 жыл бұрын

No Chris. PBI RS currently doesn't support embedded capabilities and it can't be shared outside the organization scope.

@stephanieallen4152 2 жыл бұрын

I feel llike this is the solution I need but I'm totally lost. I'm trying to figure out how to use confluence as a datasource on my PBI reports. Tired of typing up the same tables in both places [insert crying and banging head on desk]

@grhnisaacs 5 ай бұрын

Is this video still valid? Is this describing the last version of what we have in power bi app development?

@vikash7328 Жыл бұрын

Embedding with power Bi works with onpremise reporting server as well??

@GuyInACube Жыл бұрын

It depends 😁 Power BI Embedded itself is a concept for the Power BI Service. But you do have some options with Power BI Report Server - docs.microsoft.com/en-us/power-bi/report-server/quickstart-embed It's a bit different though.

@SURESHSURESH-kv6dg 4 жыл бұрын

hi please make a vedioes on power bi adminstration i am looking for lot vedioes on admin it was not good please make vedies on power bi admin

@GuyInACube 4 жыл бұрын

We have a few videos on Power BI administration. Is there a particular area you are looking for?

@Faeemworld 5 ай бұрын

Q: I have a power BI dashboard, Can I embed it into an app? If yes, can you share a process or video link please. Thank you

@yasothadevis7203 6 жыл бұрын

Can I Embed a powebi dashboard in SharePoint Online site using SharePoint Add In. In this case I need to authenticate to Azure AD via Javascript SDKs and generate the powerbi EmbedToken also using javascript SDK. Is that possible?

@GuyInACube 6 жыл бұрын

No. Power BI Web Part for SharePoint Online is only for reports. The Generate Token call is just a REST API call which can be done from JavaScript. The JavaScript SDK does not allow for that, you would need to make the rest api calls outside of the SDK. Once you have the token, you could then use the SDK. Although if you are in SharePoint Online, why would you need the EmbedToken? that is more for ISV type approaches. WIthin SharePoint Online you have a user context for your Tenant.

@yasothadevis7203 6 жыл бұрын

Guy in a Cube we are trying to display a powerbi dashboard ( not report) in SharePoint online site. The powerbi webpart only supports reports. So my thought is to develop a SharePoint addin which will use REST API calls and powerbi sdk to get the dashboard displayed. Any other options? Our reports are published into powerbi premium and only our internal org users required access to dashboards from SharePoint.

@wongyejie 3 жыл бұрын

Hi Adam and Team, #QuestionsHere I'm working on Power BI Embedded - App Owns Data (Master User - with Power BI PRO Account Access) as I would like my clients skip the Power BI login access. I noted Power BI new updates on enabling Action Bar (which allow to export to PDF/PPT) available for User Owns Data. #Q: Is there any way to export to PDF/PPT with App Owns Data? (I hope there is another way than using REST API with Premium Account) Hope you can advice. Thanks!

@andywilbourn8761 6 жыл бұрын

Trying to follow your steps and to go dev.powerbi.com/apps and it does not render properly. I have tried multiple browsers and multiple machines so is this something you can ping the support team on?

@andywilbourn8761 6 жыл бұрын

URL is working today, which directed to the portal.azure to register the app.

@visheshjjain 6 жыл бұрын

Can you please tell me if I can use my own computer as a server for embedding instead of buying capacity from Microsoft? And when using with PBI Embedded are the Azure Virtual Machines and the A1, A2 A3 etc. same or is there a difference? Thank you!

@pradeepkailasa 6 жыл бұрын

Vishesh Jain did you figure this out?

@visheshjjain 6 жыл бұрын

pradeep kailasa not really. If you need embedded you have to buy capacity, that’s the only way...

@pradeepkailasa 6 жыл бұрын

Vishesh Jain I have very few users and would like to integrate reports into intranet site.

@jw715 5 жыл бұрын

I am still confused, there is too many different things, i cannot get a whole picture. Power BI have pro and premium licences, pro is pay as you go, premium can control the capacities. and then on Azure portal, there is Power BI Embedded resouce. And then in D365, also have embedded power BI reports, embedde power bi.com.

@GuyInACube 5 жыл бұрын

There is definitely a lot of stuff. Just remember Pro licenses are for users. Dedicated capacity (Power BI Premium and Azure Power BI Embedded) is for content/workspaces. Embedded reports within D365 is a bit different. From a basic standpoint, you can consume reports from the Power BI portal (app.powerbi.com), or you can use the Power BI APIs to embed content in an application/location of your choosing. Then you need to deal with what is needed from a license/subscription perspective to make sure you are legal :)

@jw715 5 жыл бұрын

@@GuyInACube Thanks for reply, a lot of great videos from you. Just found a doc of planning a power bi enterprise deployment, it pretty much explains the questions I have. Here is the link in case someone is interesting in download.microsoft.com/download/C/2/0/C209BC23-EFEB-4684-A3F2-5CF495F51EED/Planning%20a%20Power%20BI%20Enterprise%20Deployment.docx

@GuyInACube 5 жыл бұрын

Awesome! 👊

@rohanperera9830 4 жыл бұрын

Hello I have studied power bi to an advanced level yet, I found one requirement that i could satisfy. That is to pass the live dashboard/charts to display inside a html tag/content though it appears possible to publish a dashboard with static data inside a html tag/content. Our company is trying purchase power bi licences to create a cusomized realtime charts but I am in a doubt whether it would be possible to create realtime updating dashboard with powerbi and exlpoing it inside a html tag. Looking for help with this.

@jaimemolina1777 2 жыл бұрын

my Company needs to hire someone to do this for us. Adam, can you help?

@hoganmcdade Жыл бұрын

Great Shirt

@valtyrj 6 жыл бұрын

When will embedded Power Bi reports that are using Azure Analysis Services with RLS be supported? community.powerbi.co... This is a big issue for us and apparently a lot of other customers.

@heidipark883 6 жыл бұрын

The goonies 😍

@VaskoBog 4 жыл бұрын

I don't understand anything of this fancy words. Please give example.

@piyushkh 3 жыл бұрын

what is the difference between two links... dev.powerbi.com/apps & app.powerbi.com/embedsetup ?

@manasvilife 5 жыл бұрын

Hello All, Please reply to me if anyone knows about this...! Can we not embed the Power BI dashboard into a third-party website just using PowerBI Pro License? Do we need to have PowerBI Embedded? ( I even tried to embed a dashboard URL in a simple HTML page, but it is not showing up) Please guide me on how to do this. I did exactly all steps mentioned in docs.microsoft.com/en-us/power-bi/developer/embedding ( Embed for your organization) Thank you in advance.