Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Imagine I have monthly tables with data i'm interested in showing on a report.
Can I create a month slicer to change the data source to the corresponding monthly table and automatically update the whole report based on the user selection?
Or should I just append all the tables into 1? The issue is that every table averages ~700K rows, what's the row limit on Power BI?
Solved! Go to Solution.
In general you should append them all into a single table. Power BI can handle millions of rows of data, it really depends on the amount of data and how much it can be compressed.
In general you should append them all into a single table. Power BI can handle millions of rows of data, it really depends on the amount of data and how much it can be compressed.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |