Forum Discussion
dataset limitations
Yes.. one PBIX file corresponds to one dataset. Within a dataset you can have any number of tables in it. 30M rows is considered pretty small dataset for Power BI. If you model it properly (for example check the link which v-lili6-msft shared above), you can get very good compression. I was once able to compress a 10M row dataset to 1.3MB (it had only 6-7 columns though). Lesser columns, lower distinct values in each columns, etc. help a lot with compression.
Yes.. one PBIX file corresponds to one dataset. Within a dataset you can have any number of tables in it. 30M rows is considered pretty small dataset for Power BI. If you model it properly (for example check the link which v-lili6-msft shared above), you can get very good compression. I was once able to compress a 10M row dataset to 1.3MB (it had only 6-7 columns though). Lesser columns, lower distinct values in each columns, etc. help a lot with compression.
Given: Two Power BI Pro Users (No Premium tenant)
If User-A published a 700 meg data set to WorkSpace-X his total available overall memory (10 gig) is reduced by 700 meg. Now if User-B also subscribes to WorkSpace-X will his available 10 gig memory also be reduced by 700 meg since the 700 meg data set is available to him there?