Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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


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.





Super User IV
Super User IV

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

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




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


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


Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors