using power apps in power bi reports enabling writeback · intro to power apps by building a power...
TRANSCRIPT
04/16/2020 Shabnam Watson
Power Apps Power BI
04/16/2020 Shabnam Watson
Shabnam WatsonBI Consultant
BI Consultant20 years of experience developing data warehouse and business intelligence solutions with focus on Analysis Services and Power BI
BackgroundBachelor’s degree in Computer Engineering. Master's degree in computer science. Certified Business Intelligence Professional (CBIP) by The Data Warehouse Institute (TDWI)
Speaking/CommunityPASS Summit, SQL Saturdays, PASS Virtual Chapters, .NET South, BI and SQL Server user groups. SQL Saturday Atlanta BI Organizer
/ShabnamWatson
@shbWatson
BLOG: https://shabnamwatson.wordpress.comGitHub: Sample code for this presentation
04/16/2020 Shabnam Watson
Anyone who wants to learn:
• Intro to Power Apps.• Power Apps Visual• Have a Power App refresh a Power BI report
Intended Audience
04/16/2020 Shabnam Watson
AgendaConcepts: Power Apps, Power BI reports, Power BI Integration
Intro to Power Apps by building a Power App based on a SQL Server table
Build a PBI report from the same table, create a new App from PBI service to update the table
04/16/2020 Shabnam Watson
Power AppsWeb based business applications development environment
Design by dragging and dropping elements
Very little code, Excel like formulas, without writing traditional code.
Template Apps
Multi-platform: Desktop, Mobile, Web
04/16/2020 Shabnam Watson
Mobile devices
04/16/2020 Shabnam Watson
Power Apps Licensehttps://powerapps.microsoft.com/en-us/pricing/
Run single apps
Run unlimited apps
$10 per user/app/month
$40 per user/month : Free Trial
Community Plan: https://docs.microsoft.com/en-us/powerapps/maker/dev-community-plan
04/16/2020 Shabnam Watson
Power BI reportsInsights from data
Semantic model and actual data depending on the storage mode
Table Storage modes: Import, DirectQuery (per table)
Composite models: Combination of Import and Direct Query
04/16/2020 Shabnam Watson
Power Apps and Power BIPower Apps visual a default visual.Update data
Power BI and Power Apps integration: Automatic Refresh : PowerBIIntegration.Refresh()
04/16/2020 Shabnam Watson
Power Apps and Power BI
Power BI Report
PowerApps Visual
Data Source (Direct Query)
UpdateContext aware data
04/16/2020 Shabnam Watson
Power Apps and Power BI
Power BI Report
PowerApps Visual
Data Source (Direct Query)
Update
Data
PowerBIIntegration.Refresh()
Context aware data
04/16/2020 Shabnam Watson
Power Apps and Power BI
Power BI Report
PowerApps Visual
Data Source (Direct Query)
Update
Data
PowerBIIntegration.Refresh()
Context aware data
04/16/2020 Shabnam Watson
Demo
04/16/2020 Shabnam Watson
Order of operations
Always Publish the report to PBI Service first.Open the report from the web interface and edit.Add the Power Apps visual.Select fields to add them to the visual.Follow the visual’s instructions.Save and share the App.
04/16/2020 Shabnam Watson
Power Apps Visual Limitations
Must be edited from Power BI Service after changes to fields
Can't trigger a refresh of Power BI reports from Power BI Desktop
Can't filter a Power BI report
Not supported in Power BI Report Server
Fully supported in Edge/Chrome
04/16/2020 Shabnam Watson
PowerBIIntegration.Refresh()
Create New App or use an existing App that has been previously created from PBI Service.
Existing Apps not created from PBI Service, do not work!
Table to be updated must have a Direct Query storage mode.
04/16/2020 Shabnam Watson
Page Refresh Summary
Report Created InPower BI Desktop
Report Published and Edited In Service
New App from Power BI Service
Existing Power App Not Created from Power Apps visual
Existing Power APP Created from Power Apps visual
Page Refresh Works?
Yes No - - - Yes Yes Yes Yes Yes - Yes Yes Yes - - Yes
04/16/2020 Shabnam Watson
ReferencesPower Apps Custom Visual for Power BIForms in Power AppsDaniel Christian https://www.youtube.com/watch?v=LxKLLgUhlBo
https://www.youtube.com/watch?v=BxQGGzdH3vo
Patrick LeBlanc https://www.youtube.com/watch?v=BxQGGzdH3voCharles Sterling https://www.youtube.com/watch?v=3eiUR8Lo4i4Prathy Kamasani and Charles Sterling
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-PowerApps-Introduction-to-PowerApps-and-integration/m-p/711409
Shane Young https://www.youtube.com/watch?v=H9yYzPg0LwM
04/16/2020 Shabnam Watson
Thank you. • Questions?
Connect/ShabnamWatson
@shbWatson
BLOG: https://shabnamwatson.wordpress.com
GitHub: Sample code for this presentation