Forum Discussion
Advocate IVData Preparation on Power BI Desktop
Advocate IVThanks 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.
Solution SupplierI understand you have survey data, presented in rows (UserId, Question, Response) and you want to be able to answer questions like "how many customers answered A to question 1 and answered B to to question 2?"
Creating new columns is the way to go, if you want to use an un arbitrary number of filters.
Alternatively, Marco Russo and Alberto Ferrari have proposed a pattern that only allows the user to apply a predefined number of filters:
http://www.daxpatterns.com/survey/
This drawback comes with the advantage that no unpivoting is required, resulting in less memory being required (due to fewer columns being present in the data model).
See if it works for you.
- dkay84_PowerBI
Microsoft Employee
How does this turn into 500 columns?- hjameelq
Well for me it worked perfectly, what I did is I splitted the data sets into separate sheets and it worked without any huge slowness, I thought it is not gonna work but apparently, it did :)
