Forum Discussion
Best way to develop and implement a solution
Hi Everybody... what is the best way to implement an enterprise solution working with large databases, because I can develop my model in Power BI Desktop and ok no problem, the problem is that there...
Hi
The 250MB limit is pr. dataset and due to great compression you can pack a lot into 250MB. In Power BI pro each user has 10GB of storage so you can potentially have 40 250MB datasets pr. user.
The main way to keep down data size is to be careful when you import data in such way that you only import the data you need. This is a columnar store database so number of columns and their sparsity is very important. Don't for example import id columns on tables if you don't need them as they are unique for each row.
Hope that helps you. I'm sure others can pitch in with their experience as well