Using Microsoft Flow with Power BI As Serverless
Using Microsoft Flow with Power BI • As Serverless Middleware to Turbo-Boost your Power-BI • John Liu Power. BIWorld. Tour. com #PBIWorld. Tour
About John Liu Share. Point Gurus • dev, consultant, blogger, community (Sydney & Australia) • Share. Point/O 365 usergroups, Saturday, conf • Flow. UG* • MVP Office Services (Share. Point) • MVP Business Solutions (Flow) • john. liu@sharepointgurus. net twitter. com/@johnnliu #Flow. Ninja https: //johnliu. net Power. BIWorld. Tour. com #PBIWorld. Tour
Plan • Introduce Microsoft Flow • • What it is, what it does Quick Demo mobile Flow Architecture, where does it sit Pricing • Demos • Discussions • End – afternoon tea? ! Power. BIWorld. Tour. com #PBIWorld. Tour
Architecture – what Flow really is • The story of Microsoft Flow • It is linked to Logic Apps • It is linked to Biz. Talk • It is linked to Azure Integration Services • It is also IFTTT/Zapier • It replaces Dynamic / Share. Point workflows Power. BIWorld. Tour. com #PBIWorld. Tour
Power. BIWorld. Tour. com #PBIWorld. Tour
Demo • HTTP Request and Response • Get File • Get Football Power. BIWorld. Tour. com #PBIWorld. Tour
Demo • ETL • Moving Binary • Add additional cognitive services • List. Data. As. Stream http: //www. cleverworkarounds. com/2018/06/30/someseriously-powerful-and-free-pdf-functionality-in-powerapps-and-flow-part-1/ Power. BIWorld. Tour. com #PBIWorld. Tour
Demo – Trigger on Data Alert • https: //powerbi. microsoft. com/en-us/blog/turn-insight-into-deepmeaningful-action-using-microsoft-flow-and-power-bi/ Power. BIWorld. Tour. com #PBIWorld. Tour
Demo – Push into Streaming Dataset • https: //powerbi. microsoft. com/en-us/blog/push-rows-to-a-power-bistreaming-dataset-without-writing-any-code-using-microsoft-flow/ • Demo by: Kawabata Yoshihiro Power. BIWorld. Tour. com #PBIWorld. Tour
Numbers Power BI Microsoft Flow • Special Powers: • Pivot (Power. Query & DAX), Visualization, Drill in • Special Powers: • Parallel, Asynchronous, Serverless, Event Driven, Low-Code processes and automation, Auth • Data Sources: 70+ • Refresh: Scheduled 15 mins+, Live. Query • Connectors: 200+ • Refresh: Anytime you fancy “Power-Flow” Power. BIWorld. Tour. com #PBIWorld. Tour
Learning – 3 tips • Data Types in Microsoft Flow (and Logic. Apps) • For Every Actions There Is An Output • Expressions Power. BIWorld. Tour. com #PBIWorld. Tour
Data Types • number, integer, Boolean • binary, XML, JSON • string • datetime string, email string, url string Power. BIWorld. Tour. com #PBIWorld. Tour
For Every Actions There Is An Output • Flow – flows data • Data doesn’t only live in variables. It lives in every action – the Action. Body() Power. BIWorld. Tour. com #PBIWorld. Tour
Expressions • • • “No Code” vs “Low Code” aka. ms/logicexpressions Why do we need this? - manipulate data between actions. variable names = [ { “name”: “John”, “age”: 39 }, { “name”: “Andrew” } ] names[0]. name first(names). names[1]? . age concat(first(names). name, ‘Liu’) http: //johnliu. net/blog/2018/4/test-yourself-a-microsoftflow-expressionsquiz Power. BIWorld. Tour. com #PBIWorld. Tour
Expressions… do you need • Do we really need this? • e. g. Date Connector Power. BIWorld. Tour. com #PBIWorld. Tour
Scenario • Building Information Client • Pull data from Autodesk Forge BIM 360 API • C# code through SSIS – 10+hours • Parallel Flow – continuous • Free up the database server • Future – delta query – update only changes • Future – webhooks – update on demand Power. BIWorld. Tour. com #PBIWorld. Tour
Scenario • Office 365 Resource Creation and Governance • Trigger from tenant admin Office 365 Message Admin Centre & Azure AD Power. BIWorld. Tour. com #PBIWorld. Tour
Scenario • Ticketing system from Service. Now • Power. BI dashboard Power. BIWorld. Tour. com #PBIWorld. Tour
Scenario – Power Family • Imagine a Power BI Dashboard • Use Power. Apps as a Low Code custom visual in Power BI, select data row in Power BI and filter the Power. Apps visual • Enter some data in Power. Apps - when submit button clicked – send data back to Microsoft Flow to execute new actions (email, call new connectors, update data source etc) • Embed the solution anywhere you like: • Office 365, or Dynamics or your own web page Power. BIWorld. Tour. com #PBIWorld. Tour
Demo • Power. BI Gateway for on-premises data • Minecraft Power. BIWorld. Tour. com #PBIWorld. Tour
Summary • What is Microsoft Flow • Where it might fit with your toolkit with your Power. BI Story • May be proof of concept – extreme rapid prototype & development • Internal-only dashboards – extremely fast to set up • “No Cliff Development” upsize into Logic. Apps, and/or add Azure. Functions • May be use this to supplement your existing Data Refresh, or integrate with Data. Flow or Data Bricks • There is no one-size-fits-all prescription, but Microsoft Flow is a seriously flexible and powerful tool you already have – so you should consider diving deeper into it. “Check out the iceberg” Power. BIWorld. Tour. com #PBIWorld. Tour
resources • https: //docs. microsoft. com/en-us/flow/guided-learning/ • https: //docs. microsoft. com/en-us/power-bi/service-flow-integration • https: //aka. ms/logicexpressions • https: //johnliu. net/microsoft-flow/ • @johnnliu #Flow. Ninja • https: //www. youtube. com/watch? v=9 ZVq. M-l. U 7 Og&t=2027 s Power. BIWorld. Tour. com #PBIWorld. Tour
Sponsors twitter. com/@johnnliu #Flow. Ninja https: //johnliu. net https: //flowstudio. app
- Slides: 23