Forum Discussion
hjameelq
Advocate IV
Advocate IVData Preparation on Power BI Desktop
I do have a huge dataset that has aggregated data that has to be disaggreated to be able to present it on different types of charts. The issue with that I got that I need to create a table for each q...
v-sihou-msft
Microsoft Employee
Microsoft Employee
In Power BI, we have the 1 GB limitation per dataset. So if your dataset will exceed this size, please separate into multiple datasets.
Regards,
dkay84_PowerBIMicrosoft Employee
Microsoft Employee1gb AFTER compression.
Another option might be using Direct Query, if your source data is a supported option. Then you can pull in only the data you actually use instead of importing the whole data set
Another option might be using Direct Query, if your source data is a supported option. Then you can pull in only the data you actually use instead of importing the whole data set