Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1qsA6jg01ecg8ed0yA0g00
Power Pages - Design & Build
Unanswered

Optimal Data Integration Strategy for Power Apps and Power BI Using Snowflake and Azure DevOps Data

Like (0) ShareShare
ReportReport
Posted on 22 Oct 2024 13:27:36 by 1
I'm developing a solution that integrates both Power Apps and Power BI, sharing a common data source. The data originates from two primary sources:
  1. Multiple tables in Snowflake (approximately a dozen)
  2. Azure DevOps (ADO) via an OData connection
Additionally, I plan to embed some Power BI report visualizations within the Power Apps solution.
My main concern is establishing the most efficient and maintainable process for data ingestion and modeling. Specifically:
  1. What's the recommended approach for importing the data and constructing the data model?
  2. Should I utilize a Power BI dataflow, a Dataverse dataflow, or an alternative method?
  3. How can I avoid duplicating efforts in data management between Power Apps and Power BI?
  4. What's the best way to ensure that any changes to the data model can be implemented in a single location, affecting both Power Apps and Power BI simultaneously?
I'm seeking a solution that minimizes redundancy and simplifies ongoing maintenance of the data pipeline and model across both platforms.
Also, we will not be utilizing any of the Fabric premium functions.

Many Thanks!
Categories:
  • Suggested answer
    SaiRT14 Profile Picture
    1,983 Super User 2025 Season 1 on 27 Nov 2024 at 01:39:39
    Optimal Data Integration Strategy for Power Apps and Power BI Using Snowflake and Azure DevOps Data
    here is Solution best practice:
     
    Use Dataverse Dataflows to pull data from Snowflake and ADO.
    Model data centrally in Dataverse.
    Use Dataverse tables in both Power Apps and Power BI.
     
    if you need more details, let me k now.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Pages - Design & Build

#1
oliver.rodrigues Profile Picture

oliver.rodrigues 33 Most Valuable Professional

#2
Fubar Profile Picture

Fubar 22 Super User 2025 Season 1

#3
JB-10040341-0 Profile Picture

JB-10040341-0 18

Overall leaderboard

Featured topics

Loading started