Forum Discussion

dguevara's avatar
dguevara
Icon for Advocate IV rankAdvocate IV
10 years ago

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...
Need Help
bidgeir's avatar
bidgeir
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago

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