Forum Discussion
Advocate IIIHuge 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
Super UserHello 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
Advocate IIIThank you...I'll try the Direct Query!