Forum Discussion

hjameelq's avatar
hjameelq
Icon for Advocate IV rankAdvocate IV
9 years ago

Data 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...
Need Help
Show and Tell
Tips and Tricks
hjameelq's avatar
hjameelq
Icon for Advocate IV rankAdvocate IV
9 years ago

Thanks both for replying to my question, that is appreciated. 

 

I wanted to ask few things about the limitations of using large dataset in power BI, so if it is that limited, I have a dataset with 500 columns, will it be okay according to your expereince to separate these columns into different datasets but not using power BI, but by using the excel and then I can add it as a source to my dashboard. Yes our data is a bit huge, and we tried many BI tools, and we founf power BI good as it serves our requirements. But the only concern now and that might get in our way to carry on using power and looking for another platform is the dataset size limitation.

 

 

 

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

hjameelq

 

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_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago
    1gb 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