Forum Discussion
Multi-developer architecture for Power BI
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
3 Replies
Is your company's data management based on Azure? Would you benefit from Fabric and its data lake offerings?
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
