Forum Discussion
Huge table
Hello rmcgrath ,
but power bi can handle 10 million rows and more, so what's the thing with your report.
and do you need this level of details ? maybe you could aggregate the data and remove unnecessary columns.
also, you can connect to the source as direct query, this way you don't need to import all these records.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Hello rmcgrath ,
but power bi can handle 10 million rows and more, so what's the thing with your report.
and do you need this level of details ? maybe you could aggregate the data and remove unnecessary columns.
also, you can connect to the source as direct query, this way you don't need to import all these records.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Thank you...I'll try the Direct Query!