Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
JSV
Frequent Visitor

Recommended architecture for Power BI and SQL server in a small charity

Hi,

Would anyone happen to know of a good source for best practices in Power BI integration architecture?

(I mean where Power BI fits into the picture rather than modelling within Power BI itself)

 

I've recently joined a small IT team and am trying to build reporting and analytics but my IT understanding is limited when it comes to servers and services (yes, I am an analyst and love data but the infrastructure supporting it is a somewhat mysterious to me). In my previous job, I was using data warehouse but the scale on my current data is comparatively small (most of the data lives in SQL server, o365 is widely used and scalability will likely be important faily soon).

 

I've tried looking around but this would be likely be responsibility of an architect in a bigger organisation so I am wondering if anyone knew of good source of information.

 

Thanks,

Jana

 

1 REPLY 1
Greg_Deckler
Super User
Super User

Well, as with most things, it depends. I have seen Power BI tagged on to the end of a data and reporting architecture and I have seen Poewr BI be the data and reporting architecture. So, traditional modern data warehouse:

 

Source systems -> Azure Data Factory -> Azure Blob Storage -> DataBricks -> Azure SQL Data Warehouse -> Power BI Dataflows/Reports

 

or

 

Source Systems -> Power Query/Dataflows -> Power BI Datasets/Data Models -> Power BI Reports

 

Depends on your scale and budget what makes sense for you. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.