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