Forum Discussion
Design advice needed
Hello, Being new to Power BI, I am not sure what the optimal design for the following problem is. Any thoughts/ideas would be appreciated. I would like to create a business user friendly data...
Hm, why do you want millions of records in a table visualiization?
Have you tried visualizations that aggregate the data, like bar charts?
Our financial crime have asked for a tabular output, showing each transaction in the 1 Half of 2015. I have emailed them asking them to reconsider their requirements because even SSRS would struggle with the vast number of rows.
Being new to Power BI / Excel Data Models, I would like to understand the optimaldesign aproaches to use.
So far, I have picked up from the previous replies to my quesiton (thanks everyone):
- Use Direct Query (as opposed to import)
- Group/Aggregate the data (as opposed to large number of "atomic" rows)
Are there are any other important deisgn principles to follow?