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
