Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5NdbIEYdnY2N3nYzLTcrf8
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,966 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

🌸 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…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Pages - Design & Build

#1
oliver.rodrigues Profile Picture

oliver.rodrigues 33 Most Valuable Professional

#2
JB-10040341-0 Profile Picture

JB-10040341-0 12

#3
Fubar Profile Picture

Fubar 7 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started
Loading complete