displaying Power BI dashboards and charts in SharePoint on-premise

%3CLINGO-SUB%20id%3D%22lingo-sub-2939%22%20slang%3D%22en-US%22%3Edisplaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2939%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20tell%20me%20what%20the%20options%20are%20for%20displaying%20Power%20BI%20dashboards%20inside%20SharePoint%20on-prem%3F%26nbsp%3B%20And%20can%20you%20display%20individual%20charts%20as%20well%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20different%20options%20available%20for%20SharePoint%20Online%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-11414%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20displaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11414%22%20slang%3D%22en-US%22%3E%3CP%3EDavid%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20and%20foremost%2C%20I%20think%20you%20may%20want%20to%20reach%20out%20to%20a%20Power%20BI%20(or%20MS)%20rep%20to%20get%20clarification%20on%20the%20licensing%20implications.%20There%20are%26nbsp%3B%22free%22%20and%20%22pro%22%20licenses%20available%20to%20users.%20Your%20%22free%22%20users%20have%20the%20ability%20to%20view%20reports%2C%20but%20may%20not%20get%20the%20full%20Power%20BI%20experience%20(refreshed%20data%20every%20%22x%22%20minutes%20%2F%20hours).%20My%20memory%20is%20quite%20hazy%20on%20the%20specifics%2C%20but%20I%20suggest%20you%20reach%20out%20to%20MS..%20there%20is%20definitely%20value%20in%20leveraging%20%22free%22%20licenses%20to%20expose%20reports%20to%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegarding%20a%20solution%20for%20embedding%20-%20while%20there%20has%20yet%20to%20be%20a%20Power%20BI%20web%20part%20made%20available%20(although%20it%20looks%20like%20there%20will%20be%20some%20sort%20of%20an%20embed%20option%20in%20Modern%20Team%20Sites%20once%20they%20release%20-%20check%20out%20the%20recent%20announcement%20on%20that%20front%20and%20watch%20closely%20to%20the%20gifs%20%2F%20videos)%2C%20there%20was%20a%20new%20JavaScript%20API%20announced%20at%20the%20beginning%20of%20this%20month%20for%20Power%20BI.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fintro-pbi-js-api%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fintro-pbi-js-api%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20haven't%20see%20much%20communication%20of%20this%20API%2C%20but%20I%20thought%20it%20was%20a%20great%20enhancement%20that%20should%20allow%20you%20to%20embed%20Power%20BI%20into%20SharePoint%20(or%20other%20web%20apps)%20-%20albeit%20with%20the%20assistance%20of%20a%20web%20developer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%26nbsp%3B%3CEM%3Esome%3C%2FEM%3Eof%20this%20helps%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Steve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6476%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20displaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6476%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20the%20%22story%22%20evolved%20any%20yet%3F%26nbsp%3B%20I've%20been%20waiting%20for%20a%20year%20to%20have%20a%20SharePoint%20Online%26nbsp%3Bweb%20part%20solution%20that%20is%20devoted%20to%20publishing%20Power%20BI%20dashboards.%26nbsp%3B%20It's%20getting%20to%20a%20critical%20point%20for%20us%20as%20we%20have%20been%20hearing%20that%20it's%20going%20to%20be%20a%20%22few%20months%22%20for%20that%20period%20of%20time%2C%20relaying%20that%20to%20our%20team%20mates%20and%20having%20nothing%20show%20up.%26nbsp%3B%20The%20technology%20is%20quite%20good%2C%20but%20we%20are%20not%20excited%20about%20managing%20an%20entirely%20new%20platform%20when%20we%20can%20simply%20manage%20the%20same%20assets%20in%20SharePoint%2C%20which%20we%20already%20manage%20quite%20effectively.%26nbsp%3B%20Please%20update%20the%20progress%20and%20possible%20release%20date%20for%20this%20feature%20if%20you%20can.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3250%22%20slang%3D%22en-US%22%3ERE%3A%20displaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3250%22%20slang%3D%22en-US%22%3EThat%20story%20is%20evolving.%20As%20noted%20above%2C%20building%20an%20app%20is%20likely%20your%20only%20option%2C%20but%20that%20should%20change%20over%20the%20next%20few%20months.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20displaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20input%20Massimo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20a%20look%20at%20that%20but%20it%20is%20a%20dev-oriented%20service.%20It%20probably%20wouldn't%20be%20too%20difficult%20to%20write%26nbsp%3Ba%20web%20part%20that%20made%20use%20of%20it%2C%20but%20licensing%20it%20for%20general%20in%20an%20intranet%20for%20a%20big%20organisation%20could%20get%20expensive%20very%20quickly.%26nbsp%3B%20It%20would%20have%20to%20be%20used%20in%20a%20targeted%20way%2C%20with%20a%20select%20group%20of%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20did%20make%20me%20realise%20that%20I%26nbsp%3Bhad%20not%20thought%26nbsp%3Bthrough%20the%20licensing%20implications%20properly%20though.%26nbsp%3B%20Every%20user%20who%20is%20going%20to%20view%20the%20dashboard%20will%20need%20a%20Power%20BI%20license.%26nbsp%3B%20The%20individual%20amount%20is%20not%20that%20high%2C%20but%20if%20you%20multiply%20it%20by%204%2C000%20users%2C%20you%20have%20%2440%2C000%20per%20month%2C%20which%20is%20quite%20expensive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20Power%20BI%20will%20not%20be%20replacing%20the%20good%20old%26nbsp%3BReporting%20Services%20and%20Excel%20approach%20we%20have%20been%20using%20in%20SharePoint%20for%20so%20long.%26nbsp%3B%20Though%20the%20SQL%20licences%20for%20Reporting%20Services%20are%20not%20cheap%20either%2C%20especially%20if%20you%20want%20the%20Enterprise%20features%20(like%20Mobile%20Reports)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2996%22%20slang%3D%22en-US%22%3ERE%3A%20displaying%20Power%20BI%20dashboards%20and%20charts%20in%20SharePoint%20on-premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2996%22%20slang%3D%22en-US%22%3EI%20think%20the%20only%20actual%20solution%20is%20tu%20use%20Azure%20PowerBI%20Embedded%20feature.%20You%20can%20read%20more%20about%20it%20here.%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fpower-bi-embedded%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fpower-bi-embedded%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Can anyone tell me what the options are for displaying Power BI dashboards inside SharePoint on-prem?  And can you display individual charts as well?

 

Are there different options available for SharePoint Online?

 

5 Replies
I think the only actual solution is tu use Azure PowerBI Embedded feature. You can read more about it here. https://azure.microsoft.com/en-us/services/power-bi-embedded/

Thanks for the input Massimo.

 

I had a look at that but it is a dev-oriented service. It probably wouldn't be too difficult to write a web part that made use of it, but licensing it for general in an intranet for a big organisation could get expensive very quickly.  It would have to be used in a targeted way, with a select group of users.

 

It did make me realise that I had not thought through the licensing implications properly though.  Every user who is going to view the dashboard will need a Power BI license.  The individual amount is not that high, but if you multiply it by 4,000 users, you have $40,000 per month, which is quite expensive.

 

I guess Power BI will not be replacing the good old Reporting Services and Excel approach we have been using in SharePoint for so long.  Though the SQL licences for Reporting Services are not cheap either, especially if you want the Enterprise features (like Mobile Reports)

 

That story is evolving. As noted above, building an app is likely your only option, but that should change over the next few months.

Has the "story" evolved any yet?  I've been waiting for a year to have a SharePoint Online web part solution that is devoted to publishing Power BI dashboards.  It's getting to a critical point for us as we have been hearing that it's going to be a "few months" for that period of time, relaying that to our team mates and having nothing show up.  The technology is quite good, but we are not excited about managing an entirely new platform when we can simply manage the same assets in SharePoint, which we already manage quite effectively.  Please update the progress and possible release date for this feature if you can.  Thanks.

David,

 

First and foremost, I think you may want to reach out to a Power BI (or MS) rep to get clarification on the licensing implications. There are "free" and "pro" licenses available to users. Your "free" users have the ability to view reports, but may not get the full Power BI experience (refreshed data every "x" minutes / hours). My memory is quite hazy on the specifics, but I suggest you reach out to MS.. there is definitely value in leveraging "free" licenses to expose reports to users.

 

Regarding a solution for embedding - while there has yet to be a Power BI web part made available (although it looks like there will be some sort of an embed option in Modern Team Sites once they release - check out the recent announcement on that front and watch closely to the gifs / videos), there was a new JavaScript API announced at the beginning of this month for Power BI.

https://powerbi.microsoft.com/en-us/blog/intro-pbi-js-api/

 

I haven't see much communication of this API, but I thought it was a great enhancement that should allow you to embed Power BI into SharePoint (or other web apps) - albeit with the assistance of a web developer. 

 

Hope some of this helps :)

 

-Steve

www.000webhost.com