POWER BI EMBEDDED WHO AM I Lori Sites
POWER BI EMBEDDED
WHO AM I • Lori Sites • Fusion Alliance • @lorisites • http: //lorisites. blogspot. com/
AGENDA • Getting Started • Options • Demo • Lessons Learned • Q&A
GETTING STARTED
WHAT IS POWER BI EMBEDDED • “Embedding for your customers is also known as Power BI Embedded is a Microsoft Azure service that lets independent software vendors (ISVs) and developers quickly embed visuals, reports, and dashboards into an application through a capacity-based, hourly metered model” • You can embed for your organization or your customers.
WHY POWER BI EMBEDDED • End users don’t have to know Power BI. • End users don’t have to have Power BI licenses. • Users can view/edit/create/save off • Reports can be embedded through use of API. • • • C# JS Java • Can be embedded in web apps and native apps.
WHAT DO I NEED TO GET STARTED • Power BI Pro user • Power BI Desktop • Azure Subscription • Power BI Embedded.
WHAT ARE THE COSTS • Power. BI Pro user: $9. 99 a month • Azure Power. BI Embedded: depends on the node type you need
NODE TYPE DEDICATED INFRASTRU CTURE VIRTUAL CORES MEMORY FRONTEND / BACKEND CORES PEAK RENDER S PER HOUR PRICE A 1 No 1 3 GB RAM 0. 5 / 0. 5 300 $1. 0081/hour ~$735. 92/month A 2 No 2 5 GB RAM 1 / 1 600 $2. 0081/hour ~$1, 465. 92/month A 3 Yes 4 10 GB RAM 2 / 2 1, 200 $4. 0242/hour ~$2, 937. 67/month A 4 Yes 8 25 GB RAM 4 / 4 2, 400 $8. 0565/hour ~$5, 881. 25/month A 5 Yes 16 50 GB RAM 8 / 8 4, 800 $16. 13/hour ~$11, 768. 33/month
WHAT ARE THE STEPS Add Power BI Embedded to Azure Subscription In Power. BI Create Workspace In Power. BI Desktop Create Report Embed Report in Application Set Workspace to use Power BI Embeded Capacity
OPTIONS
HOW DO I SECURE IT • Tenants • • Azure AD Office 365 • Row Level Security
EMBEDDING OPTIONS • Publish to Web • Rest API’s
DEMO
LESSONS LEARNED
THINGS THAT TRIPPED ME UP • Making sure my user was a pro user • Putting in the db credentials once the report was published to the workspace • Figuring out how to get the token
THINGS THAT HELPED ME • Power BI Embedded Playground • https: //microsoft. github. io/Power. BI-Java. Script/demo/v 2 -demo/index. html# • Github samles: • https: //github. com/Microsoft/Power. BI-Developer-Samples • Videos • Adam Saxton (Guy in a Cube) videos
TIPS • Only use permissions that you need. • Use the preload Java. Script API • Use the npm/Nuget packages •
SUMMARY • Getting Started • Options • Lessons Learned
QUESTIONS
Q&A • Links • • • https: //portal. azure. com https: //app. powerbi. com https: //www. npmjs. com/package/powerbi-client https: //www. npmjs. com/package/msal https: //github. com/Azure. AD/azure-activedirectory-library-for-js/blob/dev/lib/adal. js https: //www. nuget. org/profiles/powerbi https: //github. com/Microsoft/Power. BI-Java. Script/wiki/Embed-Configuration-Details https: //github. com/Microsoft/Power. BI-Java. Script/wiki/Filters https: //docs. microsoft. com/en-us/powershell/power-bi/overview? view=powerbi-ps https: //www. youtube. com/watch? v=4 Kuy. PNt. Vijo&feature=youtu. be
- Slides: 21