Power BI Architecture Best Practice

Using Power BI is simple. However, using it properly needs a good architecture. In a multi-developer environment, the architecture of a Power BI implementation should allow multiple developers to work on the same solution at the same time. On the other hand, the Power BI architecture should be designed so that different layers of that can be decoupled from each other for better integration. In this video, I explain how Dataflows, Datamarts, and Shared Datasets can help build such architecture in Power BI.
To learn more and find links to study more, read my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[joaorataoo]

Right now, I have started working with shared datasets in the Power BI service.
This collaborative environment uses the Power BI service live connection, however, one of the main limitations is that left navigation and modeling are disabled.
How to overcome this limitation?

[Babayagaom]

Reza how can I become power bi architect? I am just a developer right now. can you help me? Please let me know what all things I should know

[netmonkey]

The heavy lifting should be done in SQL. Thats also a single version of the truth

[tolgakaptan]

A Date table is commonly used by all departments data and takes place in all data models. Q: Such common tables must be kept as a separate Dataflow and so must be included as a different Data Source Query (only one Dataflow for Date Table) or must be included at every separate Department tables (repeating Date table at each Dataflow for different departmensts).

[oscarcampos]

Thank you Reza for sharing your knowledge. We are always grateful for that! Do you know how to use calculated groups and field parametrers in Datamart?

[FragementZer]

Thanks for the video, very helpful.

Would there be any benefit to use Staging Dataflows with azure datalake for storage INTO Datamarts for transofmation and azure sql storage INTO Datasets for the reports?

[sajfaml]

For what scenarios in regards to data volume you consider Dataflow Staging layer usefull? I asume that at some point (big data volumes) to load all data to Dataflow staging layer will consume a lot of time. Thanks

[davidcurtin]

Do you recommend dimensions via dataflow and large fact e.g orders with in a shared dataset skipping the dataflow?

[benioktopiansah]

Thanks, multi developer means colloborative developer, right?