ExpiredMsBIP møde nr. 71

Hvis det er første gang du tilmelder dig et møde via MsBIP.dk vil du automatisk få oprettet en MsBIP profil. Alternativt skal du logge ind med den profil du fik oprettet ved tidligere tilmelding og derefter tilmelde dig mødet.

Mødet afholdes i samarbejde med Fellowmind.

Agenda:

• Velkomst og nyt fra MsBIP
• Introduktion fra Fellowmind
• Integrating Power Apps in Power BI for enhanced reporting with writeback options
• Pause – netværk og let forplejning
• Advanced Power BI refresh scheduling in ADF/Synapse
• Ingesting JSON data dynamically to a SQL Server database with ADF/Synapse

Indlæg

Der er til dette møde følgende tre tekniske indlæg.

Integrating Power Apps in Power BI for enhanced reporting with writeback options, Daniel Østvand

• Short high level overview of the Power Platform, use case for each tools and potential integrations between them
• Integrating a Power App inside a Power BI report including main considerations
• Demo time – how do we set up a Report and an App to integrate them irl

Advanced Power BI refresh scheduling in ADF/Synapse, Mathias Halkjær Petersen

After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.

• Why use a different orchestration tool than Power BI itself?
• Exploring the toolbox – what options do we have?
• Example implementation: Asynchronous Power BI refresh schedules orchestrated by ADF
• Demo: How to set it up in practice
• Discussion/Questions

Ingesting JSON data dynamically to a SQL Server database with ADF/Synapse, Just Blindbæk

• Quick introduction to Integration Pipeline in Azure Data Factory / Synapse Analytics
• How do we go from semi-structured JSON data to a relational SQL table?
• Demo: Dynamic data mapping with a metadata driven copy activity