Dynamic data source on report

[Anonymous]

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?

[Greg_Deckler · Accepted 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.