Multi-developer architecture for Power BI

[Kudy]

Hi, 
I work in a medium size ecommerce company with approx 100 employees and I want to build Power BI's backend in a smart way using a Pro license. 

- So one good alternative is a "shared dataset" where one big dataset (up to 10 tables, 200MB) is a source of all reports. 

cons: we are three developers on only me/owner can edit this dataset, in Power Query locally through my pc. But I want other developers to edit it too.

- Another alternative I found in RADACAD is having all your tables/data as Dataflows. Then create a shared dataset that gets data from these dataflows.

pros: other developers can now edit Dataflows online in Power BI Service. 

cons:

- i read that Dataflow cannot be that big and recommended for small table, i dont understand why?
- no incremental refresh for Pro users;
- maximum number of refreshes is 8/day, and if i want to refresh my 10 tables once a day then I cant.

How would you recommend me to architect? feel even free to recommend PPU if it has a big privilege. 

Regards,
Kudy

[lbendlin]

Is your company's data management based on Azure?  Would you benefit from Fabric and its data lake offerings?

[Kudy]

Hi, 
Yes, based on Azure.
I am a business-employee with limited tech-skills, so can you please give me some more details about what you meant by using Faric's data lake offerings? 

PS, i wrote 200GB instead of MB. So, yeah, it is relatively a small data 

[lbendlin]

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog | Microsoft...